Displaying multi-select lookup column in PowerApps Datatable

(2) Share

Report

Posted on by tkrause5

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

Lookup list

WM List with the Lookup column

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,

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Verified answer

RandyHayes 76,297 Super User 2024 Season 1 on at

Like (4)

Report

@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.

Was this reply helpful? Yes No
tkrause5 11 on at

Like (1)

Report

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

Was this reply helpful? Yes No
iamjoydeepaec 4 on at

Like (0)

Report

Content remove

Was this reply helpful? Yes No
Rushmad 8 on at

Like (0)

Report

Thanks, your solution works, but it has bring another issue, how to remove the datatable selected records, reason the porperty items specified AddColumns(yourDataList, "_programs", Concat(Programs, Value & "; ")), Not yourDatalist, so if i use Remove(yourDatalist,datatable1.selected), it will show error message" couldn't find the records"

Was this reply helpful? Yes No