Hi PowerUsers,
I have a gallery of suppliers (binded to SPList) that allows a user to tick per line. User can select 1 or more suppliers and collect the supplier Title and ID of the record to a collection.
On another screen I have a SP Lookup (lookup Title to the same SP List the gallery is binded to). I would like to set the default for the lookup field to the collection of suppliers the user has selected. Is this possible? If so, I would hope to patch this collection to the lookup field in SP.
Hi @aadilganie,
SharePoint lookup columns are difficult to deal with in Powerapps because they are actually embedded tables. IMHO it is better to avoid them and instead to bring in the values as a second datasource. They can then be referenced using a dropbox on the original Edit Form. Items in the second list can be added or modified using a regular Edit form in Powerapps. If you want to persist in trying to use them. I suggest reviewing https://powerusers.microsoft.com/t5/General-Discussion/How-to-patch-a-SharePoint-Lookup-Column/m-p/2....
User | Count |
---|---|
252 | |
126 | |
104 | |
50 | |
49 |