Answered

Filter choices

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

So I'm building out an app and having trouble with a function I have been asked to add to it. I have a toggle yes/no and I want that to allow only one choice in a dropdown in another datacard.

But if the toggle is set to no I want the full choices list selectable. Is this possible and if so how do I get this to work right.

Thank you.

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (1)

eka24 20,923 on at

Like (0)

Report
Copy link

Link copied!

Consider this on the Items Property:

If(Toggle6.Value,Datasource,Filter(Datasource,Column="Your Item You want to see"))

------------

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.

Consider Checking My Youtube Channel

Was this reply helpful? Yes No
Verified answer

v-qiaqi@microsoft.com Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!
Hi @Anonymous,

Based on the issue that you mentioned, do you want to filter the Combo Box based on the Toggle value?

Could you please share a bit more about the scenario, is this 'Computer Type' a Choice column?

If it is a Choice column, please try the formula as below:

If( DataCardValue3.Value, Filter( Choices(YourSPList.'Computer Type'), Value = "Engineering Computer" ), Choices(YourSPList.'Computer Type') )

Note: DataCardValue3 represents the Toggle control.

Hope it could help you.

Regards,

Qi

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

Like (0)

Report
Copy link

Link copied!

Thank you so much this work perfect!

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

Like (0)

Report
Copy link

Link copied!

Well it does work but now it breaks updating the SP page and the app shows noting after submitting the form.

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

Like (0)

Report
Copy link

Link copied!

So yes this is a Choice column in my SP list. The toggle when flipped to yes should filter my selecton in the drop down to only show the 'Personal Computer' option. With the string provided it did work but the update to the SP list as well as the app now only show the default selection as 'None' not what is selected now. Two screen shots that I hope will help. Thank you all.

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

Like (0)

Report
Copy link

Link copied!

Fixed I had the column name wrong for the sharepoint list and its broke. All good now and works as it should.

Was this reply helpful? Yes No