SharePoint Lookup Columns for Power Apps and Power Automate: Create, Filter, Patch, and more

SharePoint Lookup Columns, Power Apps, and Power Automate: Create, Filter, Patch, Odata, and more

You cannot sort or sortbycolumns on a Lookup column
Additional columns don't work the same

Create lookup column in SharePoint
Create blank app
Add data source
Show it a gallery
Filter gallery

Saving to SharePoint
Choices
Patch

Flow
Write to the column
Query the column
Create item

[cmacdhon]

The more I use PowerApps, the more I wish I had gone to veterinary school. Or joined the Navy. Or became a hockey player. Or worked on a cruise ship. Was a voiceover actor. A dentist. A pharmacist. Zoo keeper. A male model. Etc... Thanks for the awesome video, Shane. It's going to be a big help to me.

[leaflacher]

Hello Shane,
You mention in this video that is impossible to sort a Lookup columns. I thought you and the community would be interested to hear that I found a wa.! I used a AddColumns function in my gallery. With the syntax:
AddColumns(SharepointList, "NewColumnsName", LookUpColumn.Value)
You should then display those columns in the gallery instead of the lookup ones and use it for any other kind of function you may want to use (including the Sorting or Searching ones).
Thank you very much for all your videos. It is the most helpful and funny PowerApps content you can found. This video and your AddColumn video was really helpful to solve this problem. Than you again!

[maxclyde]

Hi Shane. Just want to say YOU ARE A GOD. I had been stuck on trying to get my lookup columns via automate to no avail for over an hour. Your video saved my life. Keep up the great work :) You made at least one person very happy today

[finnpower]

3 months into PowerApp, this video contains so much information that i couldn't process right now, will probably return in future again. Your videos are great.

[juanbravo]

Thank you so much Shane! I been watching your vides/blogs since years ago (installing SP)! You rocks man!

[FernandoJSantesteban]

Thank you Shane for your great content!

[laboun]

Merci Shane, t'es vidéos sont super 👍

[otanzion]

Hi Shane, Thanks so much for these great videos. Please can you do a video on updating existing row in a list using user login as the unique identifier.

[itsybitszy]

THX for the video. Flow think is really informative.

[rrq]

Hi Shane great content!! Your videos are very informative! I have a question about lookup columns. How can I set my default value of a combo box to the user who is logged in for the filter? In other words can I default combo box to filter my gallery by the user who logs in?

[sandramcgechan]

Hey Shane, I need to see some videos on multiple choice lookup columns! Would love for you to do a video on this. I'm currently failing to build a flow that updates an item in a list and I think it relates to the fact that there are a few multi-choice lookups in the list (even though those aren't the columns I need to update, nor are they mandatory, but it seems to try to apply the item ID to those column ID fields and then gives a 'bad gateway' error message).

[kashifhaque]

11:46 I ran into a similar issue today and was able to sort my result based on the 'Value'. You can also sort by 'Id' if you want. So, my formula looked like : Sort( Value, Ascending) and it worked!

[KaiW]

Hey Shane, thanks for your great videos but I have one question, is it possible to the the values of an secondary lookup field in an edit form if I update the primary lookup?

[ibrahimhnehme]

Hi Shane, great video. Thanks for that. Are you planning to make a new video regarding power apps SharePoint lookups with multiple values? Thanks

[marielcolonsantos]

Hi, Great videos i have learned soo much from them. I started experimenting and came to a dead end where i am clueless in which I'm trying to figure out if its possible to create a calculated column on SharePoint where choices appear based on previous selection. ex. selects a phone manufacturer and proceeds to select phone model based of the selected manufacturer. Any help would be greatly appreciated.

[dwinston]

Great video. Do you have any videos that show how to Update a Lookup Column with multiple values in Power Automate Flow?

[Mx]

Hi Shane, thanks again for this nice overview.

I also patch Lookup-columns to SharePoint. My experience:
* If you patch something to the SharePoint List, you don't need the odata-information and you can leaf the Value as an empty string. It only need the Id.
* Easiest way is of course using a ComboBox
* Not so easy: Patch an blank value to Lookup columns to overwrite an existing value. Here you need to use Id = -1. Because if you don't have select something in your Combobox, the value want be overwritten in SharePoint. (The same for Person, Choice, and Date-Columns).

So my PowerFX code is:
Patch(
'Demo List',
galDemoList.Selected,
{
Lookup: {
Id: || IsEmpty(cmbLookup.Selected), -1, cmbLookup.Selected.Id),
Value: ""
}
}
)

[myatix]

Hi Shane, Great video as always! Do you have a workaround for getting Managed Metadata (Terms) into powerapps? There seems to be a limit of pulling 25 terms into a PowerApp. Not very useful for a large term set. Keep up the great work! :)

[viswanthnune]

Hi Shane, Thanks for the content and guidance. Definitely amazing stuff. I do have a question regarding how do I make a lookup in power app where it looks for row match and column match in Share-point and updates the value depending on user input. I tried Patch function etc. but no luck. Could you help me?

[abeekeeshvaraantt]

Hey Shane, amazing video, I have a small doubt whether this is the same logic that would apply to connect Microsoft forms with SharePoint lists through Power Automate?