Unanswered

Dropdown Default

(0) Share

Report

Posted on by AP6

i have a dropdown which shows all distinct hr names from the list , show i need is when i land this screen i should see all the hr names with a an extra thing [ALL Hr] , so that if i click on that i should get data in gallery of all hr records together else if i select particular hr name in dropdown then his data should appear in gallery.

PFA

Categories:

General Questions

Capture.PNG

All responses (4)

Answers (0)

mmbr1606 13,085 Super User 2025 Season 1 on at

Like (0)

Report

Re: Dropdown Default

do you mean 1 more choice? if yes then simply add it to the options.
DBO_DV 4,663 Super User 2025 Season 1 on at

Like (0)

Report
Re: Dropdown Default

Hey could you try this :

in a first step you would need to collect all the HR names in a collection and than add the all value to it :
ClearCollect(colHRNames,Distinct(Datasource,HRNames)); Collect(colHRNames,{Value:"HR all"})
use the colHRNames Collection ad Datasource for your Dropdown
on your gallery you can now add an If statement:
If(Dropdown.selectedText.Value="All Hr",Datasource,Filter(Datasource, HRColumn= Dropdown.selectedText.Value))

Let me know if it helped you.
AP6 67 on at

Like (0)

Report

Re: Dropdown Default

i want one more field in dropdown which is all , so on selecting that i should get all the records , else if i select particular hr name in dropdown then his data should appear in gallery.
mmbr1606 13,085 Super User 2025 Season 1 on at

Like (1)

Report

Re: Dropdown Default

am i right that you ask how u can filter a gallery based on dropdown choice?