Unanswered

How to link a drop-down list to SharePoint lookup

(0) Share

Report

Posted on by Community Power Pla...

Hi there

How would I connect a drop down list in power apps to a SharePoint list? The SharePoint primary column is a lookup list.

so when I go

Items = (list name)

I can select the columns from ‘Value’ but the lookup lists are not there for me to select .

any help would be appreciated

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (1)

Ami K 15,674 Super User 2024 Season 1 on at

Like (1)

Report
@Anonymous - the Items property of the Dropdown control should contain the following syntax:

Choices([@'Your List'].Your LookUp Column)

Was this reply helpful? Yes No
Ami K 15,674 Super User 2024 Season 1 on at

Like (0)

Report

@Anonymous - thanks for the kudos but has that answered your question?

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Thanks so much!

I’ve tried the syntax and I’m getting the following errors : Name isn’t valid ‘{0} isn’t recognised?
I’m not sure what it relates too?

Was this reply helpful? Yes No
Ami K 15,674 Super User 2024 Season 1 on at

Like (1)

Report

@Anonymous - could you take a screenshot? It would help if I could also see the tree view in your app.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Thanks again!

this is what I’ve entered with the error message.

I’m not sure why it’s returning errors .

Was this reply helpful? Yes No
Verified answer

Ami K 15,674 Super User 2024 Season 1 on at

Like (1)

Report
@Anonymous - to obtain the syntax you need;

Add an Edit Form control somewhere into your app

Add the LookUp column into your Form as a DataCard

Click into the automatically generated ComboBox control inside the DataCard and select the Items property for the syntax you need.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

That worked!!!!!

Thank you very much

Was this reply helpful? Yes No