Time to Stop Using SharePoint Lookups in PowerApps

SharePoint lookup columns cause a lot of complexity in PowerApps. Another issue is you need someone with the knowledge to correctly add choices to your SharePoint List to Update.
Instead let your users update your lookups in your PowerApp. Simple!

No Complex Equations.
1. Create Your SharePoint List
2. Create Your Lookup List
3. Use Only Single Line Text Fields
4. Create the relationship in PowerApps!

[axioworks]

What are the advantages of this solution, versus giving the users access to the Projects lists and it's lookups directly in SharePoint?

[wendymeyer]

I LOVE this method!!! Been battling all day trying to Patch my records to a relational SharePoint data source, and am absolutely ecstatic to have found this video. Thank you Andrew! 🙌You explain so well.

[michelforro]

An advantage on this approach instead of the classic lookup is that you can use it to do a 'cross site collection' lookup, like you can have a site with master choices to be reused in more apps

[Bekesam]

Thank you for posting this solution!! This is great for Choice type columns but what about for one -to-many relationship that both have long lists, thus seemingly requiring a lookup column? I agree 100% percent on the reasons to move away from the lookup columns as it does create extra complication and syntax knowledge that maybe is not as intuitive as a regular database.

[thomasgoerlach]

Let's assume the user has made an entry to the project based on the choices, but later he is changing the name of a choice (e.g. from green to light green). How to implement that the old entries will be updated accordingly in an automated way.

[filipwinski]

Hello, Great Video! This idea might be developed by using filters in the lookup field (in my case it is a very common scenario).

[alizaz]

This is great Andrew!
I am trying to implement this in what I'm currently working on however I can't get it to auto-fill a field based on a pick from one of these columns. Have you had any success with this?

[andreiasola]

Hi Andrew, thanks for sharing your knowledge!
If we need to select multiple values, instead of just one, is it possible to adapt this solution?

[PsYc]

This was a great video. What if you have relationship between your lists? would lookup be the best way still?

[mikesutton]

This worked great for me until I deleted one of the items from the dropdown field list. After I did this, the field would not populate the default value if it wasn't available in the dropdown, even though you could see the value in the backend sharepoint list. I could never find a work-around for this. So, this feature works great as long as I keep the dropdown values available at all times. I wish I could find a work-around because I would like to delete certain available items from the dropdown over time.

[gregcalvert]

Great!!! I can now create a admin sharepoint list and only give them access to that screen to do the update?