Unanswered

Filling up drop down with choice values from SharePoint column.

(0) Share

Report

Posted on by rssilvaba

160

Hi All,

I need to create a drop drown filter for a gallery, I was thinking if it is possible to query and fill the drop down with the choices from the SharePoint column instead of manually putting them there.

I tried List.Column but the app says I am bringing a nested table. Any ideas how to do it?

Categories:

Building Power Apps

All responses (4)

Answers (0)

Sort by

eka24 20,925 on at

Like
a
(0)

Report
Copy link

Link copied!

If you want to put choice column on Dropdown:
Choices (Datasource.Column)
------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.
v-qiaqi@microsoft.com Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi@rssilvaba,
Based on the issue that you mentioned, do you want to filter a gallery based on a drop down?
Could you please share more about that which column do you want to pull the values from, is it a Choice column?
Considering that you want to query and fill the drop down with the Choice column from your SharePoint list, I think a Combo Box can achieve your needs.
We use Choices([@List].Column) when it comes to quoting the Choice column. A Choice column is a table of records, even if it contains one item, it is still a table instead of a record.
On this premise, I have a test on my side, please take a try as below.
Add a ComboBox, set the Items property as:

Choices([@List].Column)

Turn the option below “ON”
After then, you can filter the gallery by query or filling in this ComboBox.

Best Regards,
Qi
v-qiaqi@microsoft.com Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi@rssilvaba,
Have you solved your issue?
If it solves your request, Mark it as a Solution to enable other users to find it.
Best Regards,
Qi
v-qiaqi@microsoft.com Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi@rssilvaba,
Have seen the issue that you mentioned again. There are several types of choices dropdowns within SharePoint. Except for the Choice column, a Person column can be choice dropdown too.
Do you want to populate a dropdown based on choices from another dropdown?
Generally, we use ComboBox to fill in multiple choices in SharePoint.
Firstly, if the dropdown is a people picked based on selections from a people choice field, you can take a try as below.
Please make sure that you have connected to Office 365 Users connection except for SharePoint within your app.
Within the Edit form, set the DefaultSelectedItems property of the Combo Box control within the Persons Data card as below.

If( EditForm1.Mode=FormMode.New, { Claims: "i:0#.f|membership|" & Lower(LookUp(Office365Users.SearchUser(),DisplayName = DataCardValue2.Selected.Value,Mail)), DisplayName: DataCardValue2.Selected.Value, Email: LookUp(Office365Users.SearchUser(),DisplayName = DataCardValue2.Selected.Value,Mail), Department:"", JobTitle:"", Picture: "" }, Parent.Default )

Note: The DataCardValue2 represents Combo Box control within the TEST Data card.
Secondly, if you want to populate ComboBox based on selections from another ComboBox, it will do occur the table issue.
I have a test on my side, please take a try as below.
Set the first ComboBox Items property as below

Choices([@Tep].Choices)

Set the second ComboBox DefaultSelectedItems property as below

Filter(Choices(Tep.Choices), Value in Concat(Filter('Tep',ChoicesT.Value = DataCardValue6.Selected.Value), Choices.Value & ";"))

Best Regards,
Qi