Option set in gallery

(0) Share

Report

Posted on by atray13

147

Is it possible to use the values contained in an option set for one of your fields, as options in a gallery?

E.g. from the field Gender has option set for male and female. And in the gallery it shows male and female as the two items, each leading to the records that are either male or female.

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (7)

Answers (1)

Drrickryp Super User 2024 Season 1 on at

Like (0)

Report

Hi @atray13

Are you using your gallery to display data or to collect data?

Was this reply helpful? Yes No
Hamish Sheild 3,005 Most Valuable Professional on at

Like (0)

Report

Hi @atray13,

Or are you looking to filter the gallery based on gender?

Was this reply helpful? Yes No
v-yutliu-msft on at

Like (0)

Report
Hi @atray13 ,

Do you want to show option set field as radios in gallery?

Like the screen shoot:

If so, I 've made a similar test for your reference:

1)in my test, my entity named: testmanies, my option set field named 'ExpenseStatus ', my custom option set named test123

2)insert a gallery, set its Items:

testmanies

insert a radio button inside the gallery, set the radio's Items:

Choices(testmanies.'ExpenseStatus ')

set the radio's Default:

ThisItem.'ExpenseStatus '

Then the radio will display the option set field.

If you want to use this radio to update option set value, you could use formula like this:

Patch(testmanies,ThisItem,{'ExpenseStatus ':Radio1.Selected.Value})

Then the radio will be used to display and update this option set value.

Best regards,

Was this reply helpful? Yes No
atray13 147 on at

Like (0)

Report

Hi all thanks for the comments.

What i am trying to achieve is a gallery that displays these options like in the screen shot, where the items in the gallery are that of the option set for a field in the source data. So that say they clicked on the male option in the gallery this will take them to the next screen with a different gallery that displays all of the records that have male recorded as their gender.

Option gallery

Was this reply helpful? Yes No
Drrickryp Super User 2024 Season 1 on at

Like (0)

Report

Hi @atray13

Although someone else will come up with an answer for you, I usually avoid using option sets in this type of situation. Instead, I would use a simple text field in the dataset and control the user input using a radio control with items property ["Male","Female"]. (to be completely "PC", maybe add "Other"). Then, you can display the result in your gallery as a simple label. PowerApps option sets are actually a small table with an ID and Value.

Was this reply helpful? Yes No
Verified answer

v-yutliu-msft on at

Like (0)

Report
Hi @atray13 ,

Ok, this is possible.

Try this:
1)gallery1 (option set column)

Items:

Choices(testmanies.'ExpenseStatus ')

//Choices(entityname.optionsetfieldname)

2)gallery2 (filter option set field based on the selected of gallery1)

set gallery2's Items:

Filter(testmanies,'ExpenseStatus '=Gallery1.Selected.Value)

//Filter(entityname,optionsetfieldname=Gallery1.Selected.Value)

Please replace with your entity name, optionset fieldname and gallery name.

Best regards,

Was this reply helpful? Yes No
atray13 147 on at

Like (0)

Report

Perfect thank you.

Was this reply helpful? Yes No