cancel
Showing results for 
Search instead for 
Did you mean: 

Support for Lookup fields in Sharepoint list

Currently, lookup fields of Sharepoint list are not appearing.
This is a major limitation.
Lookup fields should be displayed and set to the LookupValue.
Ideally LookupId should also be accessible in a second field.

 

Romain B shared this idea  · 

Status: Completed
Comments
Level 10

We are actively looking at adding lookups.

PowerApps Staff jo
PowerApps Staff

SharePoint list "lookup" fields are now supported as read-only, please let me know if it is still not working for you once you download the latest PowerApps Windows studio client. 

 

NOTE: we are also going to be adding the ability to set/write lookups in the coming months from a PowerApp.

Level: Powered On

I just tried to connect to a list with a look up in it and it returned:

 

PowerAppsError1.png

 

No other information was provided to me to try to determine what the possible issue could be.  Visited the store to see if there was an update for PowerApps app, nothing listed.  Current version is:  2.0.412

Level: Powered On

Hi

 

 

Can lookup data be added to Flows as welll  or is there a away to do this with a connector?

 

Daniel

Level 10

Please see here how to connect to and read values from a SharePoint lookup column:

https://powerusers.microsoft.com/t5/PowerApps-Forum/Connecting-to-SharePoint-lists-with-Lookup-Perso...

 

Both the value and the ID are available

 

However, it seems to be read-only at the moment.  I have not found a way to Patch back the ID value, anyone with good ideas please contribute.

 

The only bad idea I have had is to create a number column in the same SharePoint list and then patch back the new ID to this number column.  A SharePoint workflow triggered by any change in the record can then take that ID value and copy it into the lookup column.  It is not difficult and should work, if anyone is interested please reply to this post and I will try it out.

 

Obviously it would be preferable for the PowerApps team to provide the direct solution.

 

PowerApps Staff

Lookups are not available for SharePoint lists, please give this a try with in latest PowerApps version! For quick steps on how to configure it please refer to our Support for lookups blog post. Please don't hesitate to share out you questions and feedback, can't wait to hear back from you!

Level: Powered On

Excellent.. Will check this out.

 

 

Daniel

Level: Powered On

Add support for multiple looks. For example, the people and group field type. Support for adding multiple people/groups. SPO/InfoPath support this today. Would be great to see it in PowerApps too.

Level: Power Up

Can you please add support for Dynamics CRM Online lookups? It only shows the ID field and not the entity name field.  If you check it to lookup, then it does show the name field but you then cant write it back to the lookup field in the database.

Level: Powered On

Lookups from parent site columns is not supported at the moment. Please add this functionality.