Issue with Choice Column with "Allow Multiple Values" During Filter

(0) Share

Report

Posted on by KnightWorks009

Hello There,

I have a choice column "Client locations" with "Allow Multiple Values" turned on in Sharepoint List.

While using below formula in a drop down it doesn't give any results:

Distinct(
Filter(
SharepointList,
variableCountry in 'Client locations'
),
Customer
)

However when i turn off "Allow multiple values" in Sharepoint List and Use below formula it starts to work

Distinct(
Filter(
SharepointList,
variableCountry = 'Client locations'.Value
),
Customer
)

I want to achieve this with "Allow Multiple values" turned on. (The First Case above which is not working)

Appreciate your guidance on this.

Categories:

General topics

All responses (14)

Answers (1)

Sort by

v-bofeng-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @KnightWorks009 ,

Please try:

Distinct(Ungroup(Filter(SharepointList,variableCountry in 'Client locations').Customer,"Customer"),Value)

Best Regards,

Bof
KnightWorks009 51 on at

Like
a
(0)

Report
Copy link

Link copied!

Didn't help
KnightWorks009 51 on at

Like
a
(0)

Report
Copy link

Link copied!

hello @v-bofeng-msft @annajhaveri @SudeepGhatakNZ , good day.. is it feasible to achieve this ?
SudeepGhatakNZ 14,396 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
The below should work. Does it not? You are missing the Value property.

Distinct(
Filter(
SharepointList,
variableCountry in 'Client locations'.Value
),
Customer
)
KnightWorks009 51 on at

Like
a
(0)

Report
Copy link

Link copied!

@SudeepGhatakNZ : No, this doesn't work. As soon as you Enable "Allow Multiple Values" in SharePoint List for Choice Column this fails....
Verified answer

SudeepGhatakNZ 14,396 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

Do you have the same setup?

What does your Power Apps variable contain?
KnightWorks009 51 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks a ton ! @SudeepGhatakNZ i was missing Filter().ColumnName
KnightWorks009 51 on at

Like
a
(0)

Report
Copy link

Link copied!

@SudeepGhatakNZ : Solution works however in PowerApps in the ComboBox if I turn on "Allow Searching" it stops to function. Requesting your guidance how to make it work with Allow Searching On
SudeepGhatakNZ 14,396 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

@KnightWorks009 , what exactly stops working, can you elaborate? I can try at my end
KnightWorks009 51 on at

Like
a
(0)

Report
Copy link

Link copied!

I'm using this formula in a Combo Box.
Combo Box has a property called "Allow Searching" which automatically turn offs after i use this formula