Power Platform Community Forum Thread Details

What are the pro's / con's of using a Sharepoint Lookup column in a Data Source vs. using two Sharepoint lists as Data Sources in PowerApps? Seems like they operate in the same way.

I've not used a Sharepoint Lookup column (only the two list method) and I'm trying to understand if/when I should.

Thanks

Categories:

Building Power Apps

Hi @ericonline,

Sorry but I have to say I do not understand what did you exactly need from your post. Please try to explain more about what you want to achieve in the app if there is any misunderstanding.

If you add a SharePoint list as data source, and it contains a lookup column, then it would have a little different from other columns. For example, you could have a look at the below blog talking about Setting a SharePoint List Lookup Column:

http://sympmarc.com/2018/02/05/powerapps-setting-a-sharepoint-list-lookup-column/

About the 2 lists, you cannot have multiple data sources for one gallery and one form. Here is an example of how to save fields from two separate SharePoint lists in one app:

https://powerusers.microsoft.com/t5/PowerApps-Community-Blog/Radio-buttons-and-saving-fields-to-multiple-SharePoint-lists/ba-p/26698

Regards,

Mona