Answered

Getting multiple choices as a dropdown in PowerApps from SharePoint List

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hello Forum,

I have a scenario where i have to use multiple choices from SharePoint list as a dropdown function in a PowerApps and i have tried multiple formula like Distinct, Concat and choice but no result, Anyone in the community has an idea to address the issue

Thank you in advance.

Categories:

Building Power Apps

All responses (5)

Answers (1)

Sort by

Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Anonymous ,

Use formula in default of dropdown - choices([@datasource].columnname).
Thanks,
Chitrakant27
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Anonymous ,

sorry bro use same formula in item property in drop down

Thanks,
Chitrakant27
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Chitrakant27 ,

Thank you for the suggest, I have tried that formula but doesn't work as the fields in the SharePoint is choices and they have multiple choices already updated, now they have to be used as a filter in the PowerApps,

So it is not a single choice but of a multiple choice

Hope this helps
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Anonymous ,

Can you use combo box as like , I used in below and apply property in items.

Thanks,
Chitrakant27
Verified answer

v-qiaqi@microsoft.com Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Anonymous,

Have you solved your problem?

Do you want to get the whole Choice column values as the dropdown list options?

Could you please tell me that if this Choice column allows multi select?

If you want to get distinct choices from the Choice column in SP list, you just need to set the Items property of the Combo Box as below:

ForAll(Distinct(List,ChoiceColumn),Result)