Display and Edit SharePoint List LookUp Column in PowerApps

(0) Share

Report

Posted on by Salamander94

184

Hey Everyone,

To the best of my knowledge there is not a way to display a "lookup" field from a SharePoint list in a powerapps "data table" correct? No matter what I do, I cannot even see the field display in the data table's "fields" selection. I cannot find anything online saying you can manipulate a SharePoint list "lookup" field in powerapps/display it in a data table. If you can, could you please help me / point me in the right direction?

If you cannot, can you please give me a reference/article that proves this? I am trying to get my boss off of my back on this one if I am correct.

Thank you!

Categories:

Building Power Apps

I have the same question (1)

All responses (6)

Answers (1)

RandyHayes 76,297 Super User 2024 Season 1 on at

Like (0)

Report

@Salamander94

Yes, you can display this in your DataTable.

Just add it as a column in your Items property:

AddColumns(yourDataSource, "LookupValue", yourLookupColumn.Value)

You will now see "LookupValue" in your list of fields to add to the datatable and it will show the value of the lookup.

I hope this is helpful for you.

Was this reply helpful? Yes No
Salamander94 184 on at

Like (0)

Report

So I get to this point: AddColumns( '101 FG Orders',"LookUpValue",'101 FG Orders'.<My_Column>)
However, I cannot find the column I am looking for. It is like it's invisible to powerapps. Or do I need to be using LookUp() instead of "101 FG Orders".<example>"?

Was this reply helpful? Yes No
Verified answer

RandyHayes 76,297 Super User 2024 Season 1 on at

Like (0)

Report

@Salamander94

Your syntax is not as suggested. You should be using:

AddColumns( '101 FG Orders', "LookUpValue", <My_Column>.Value)

Was this reply helpful? Yes No
Salamander94 184 on at

Like (0)

Report

Okay I feel like I'm missing something here. The name of the lookup column is 'Item ID'. If I were to use the syntax you suggested above, I still cannot see 'Item_ID'.

Was this reply helpful? Yes No
RandyHayes 76,297 Super User 2024 Season 1 on at

Like (0)

Report

@Salamander94

Is Item_ID the name of your Lookup column in your list?

Was this reply helpful? Yes No
Salamander94 184 on at

Like (1)

Report

My apologies....come to find out the column "Item ID" had been originally the "Title" column. I changed it back and everything is working as it should. Thank you for all of your help!

Was this reply helpful? Yes No