cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
tkrause5
Frequent Visitor

Displaying multi-select lookup column in PowerApps Datatable

I am having issues displaying a SharePoint multi-select lookup column in PowerApps Datatable. 

 

Lookup list

tkrause5_0-1614374502665.png

WM List with the Lookup column 

tkrause5_1-1614374549279.png

 

PowerApps data table referencing the WM List (error shown)

Capture.23PNG.PNG

It gives me an error in the Text proprieties that: "This formula uses scope, which is not presently supported for evaluation" AND it displays [obeject], [obeject] for the lookup column. 

 

Can you display a muti-select SharePoint lookup column in a PowerApps datatable? If so how? 

 

 

Thanks, 

 

1 ACCEPTED SOLUTION

Accepted Solutions
RandyHayes
Super User
Super User

@tkrause5 

The message - "This formula uses scope, which is not presently supported for evaluation" is not an error, it is just a notice telling you that, since you are referencing an item that can have multiple values based on the record selected (ThisItem) it cannot tell you what the result would be.  This is completely normal and does not indicate an error.

You are using a DataTable control and it is showing you that your programs column has multiple records (which is normal for a multi-capable lookup).  The DataTable, however, cannot display the value in them and will only show Object.

 

You would need to consider using a Gallery rather than a DataTable in order to customize that information and get what you need.

Or..you could change the Items property of your DataTable to the following:

AddColumns(yourDataList, "_programs", Concat(Programs, Value & "; "))

Then you can display the _progams column in your datatable and it will be a semicolon separated list of the values of that column.

 

I hope this is helpful for you.

_____________________________________________________________________________________
Digging it? - Click on the Thumbs Up below. Solved your problem? - Click on Accept as Solution below. Others seeking the same answers will be happy you did.
Check out my PowerApps Videos too! And, follow me on Twitter @RandyHayes

Really want to show your appreciation? Buy Me A Cup Of Coffee!

View solution in original post

2 REPLIES 2
RandyHayes
Super User
Super User

@tkrause5 

The message - "This formula uses scope, which is not presently supported for evaluation" is not an error, it is just a notice telling you that, since you are referencing an item that can have multiple values based on the record selected (ThisItem) it cannot tell you what the result would be.  This is completely normal and does not indicate an error.

You are using a DataTable control and it is showing you that your programs column has multiple records (which is normal for a multi-capable lookup).  The DataTable, however, cannot display the value in them and will only show Object.

 

You would need to consider using a Gallery rather than a DataTable in order to customize that information and get what you need.

Or..you could change the Items property of your DataTable to the following:

AddColumns(yourDataList, "_programs", Concat(Programs, Value & "; "))

Then you can display the _progams column in your datatable and it will be a semicolon separated list of the values of that column.

 

I hope this is helpful for you.

_____________________________________________________________________________________
Digging it? - Click on the Thumbs Up below. Solved your problem? - Click on Accept as Solution below. Others seeking the same answers will be happy you did.
Check out my PowerApps Videos too! And, follow me on Twitter @RandyHayes

Really want to show your appreciation? Buy Me A Cup Of Coffee!

View solution in original post

AddColumns(yourDataList, "_programs", Concat(Programs, Value & "; ")) worked for me. Wonder why Microsoft can't just put this functionality in place for multi-value Sharepoint columns. Thanks for the workaround.

 

Kind regards, 

 

TK 

Helpful resources

Announcements
PA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

secondImage

Power Apps Community Call

Please join us on Wednesday, October 20th, at 8a PDT. Come and learn from our amazing speakers!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Top Solution Authors
Users online (2,136)