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)
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,
Solved! Go to Solution.
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.
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.
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
Content remove