powerapps set default value on a lookup field of Sharepoint list

0
votes

hallo i have powerapps edit form of a sharePoint listA that contain a lookUp filed. the lookUp filed contain ids from listB.

i need the value of this lookUp filed to be selected automatically.

this is the lookup filed in the powerApps form

enter image description here

I tried to First(filter()) the Choice collection but no success.. any ideas ?

1
sharepointlookuppowerapps

1 Answers

0
votes

The PowerApps LookUp() function can contain two or three arguments and needs somekind of matching criteria.

LookUp(dataSource, column = value) returns the first record that matches the criteria

LookUp(dataSource, column1 = value, column2) returns a single column (column2) in the first record that matches the criteria.

You likely don't need the Sharepoint "Lookup-type" column once you get the hang of the PowerApps LookUp() function. (in fact, with Sharepoint as a data source, I NEVER use complex column types except for people-type).