2 dropdown lists to filter gallery

[Anonymous]

I've attached a screenshot of my View Logs screen.

What I would like to achieve is using both Dropdowns to filter the Gallery.

Dropdown1 selects a name (Supported Person), Dropdown2 selects a shift period (Shift). Is this possible? If so, what are the formulas I need to place on the dropdowns and Gallery please.

[yashag2255]

Hey @Anonymous 

Can you try to use the below expression on the Items property of the gallery control?

Filter(DataSourceName, 'Supported Person' = Dropdown1.Selected.Name && Shift = Dropdown2.Selected.Shift)

Here, you need to update the sample names with the actual names of the controls and attributes.

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

[Anonymous]

@yashag2255 

I get an 'Invalid argument type?

I had to adapt your formula to accommodate the actual names used in the app:

Filter('Daily Logs','Supported Person' = Dropdown_SPN.Selected.Name && 'Shift period' = Dropdown_Shift.Selected.Shift)

I interested as to why its Selected.Name and Selected.Shift as these are being underlined in squiggly red - Can it be Selected.{anything you like}?

[yashag2255]

Hey @Anonymous 

Selected.Name and Selected.Shift refers to the column that you want to extract from the Items in the Dropdown. So basically it is like, DropdownName.Selected.ColumnName

If you will just write "DropdownName.Selected.", the intellisense will suggest the appropriate column names.

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

[Anonymous]

@yashag2255 

Thank you for the explanation. That makes more sense now 🙂

Sadly I am still getting an invalid argument type.

The Sharepoint list is called 'Daily Logs'

The Columns are called 'Supported Person' and 'Shift period'

The Dropdowns are Dropdown_SPN and Dropdown_Shift

So (if I am understanding this correctly) the Gallery Item Property should be;

Filter('Daily Logs','Supported Person' = Dropdown_SPN,Selected.'Supported Person' && 'Shift Period' = Dropdown_Shift.Selected.'Shift period')

Which still has the invalid argument type?

[v-siky-msft]

Hi @Anonymous ,

I guess you are almost getting the truth, however, you misused a comma in the formula, please modify to a '.' dot and check if you issue is fixed.

If the error still remains, could you share the Items property of two dropdown?

It seems that these two field are complex type columns(Choices, Lookup). you can change to use Dropdown_SPN,Selected.Value  and Dropdown_Shift.Selected.Value.

Hope this can help.

Best regards,

Sik

If my post is helpful for you, please click on “Accept as Solution” to help other members find it more quickly.

[Anonymous]

Hi @v-siky-msft 

I fixed the error but still an invalid argument type.

I'm actually trying to use 3 items to filter the Gallery - I didn't include this in the original question as I thought it would over-complicate things, and that, once I understood what to do I would be able to sort it myself).

I've included some screen shots of the work in progress.

If I can get the gallery to filter in this way, there won't be any need to have an extra Detail screen as the user will be able to see the relevant info on the single gallery.

[v-siky-msft]

Hi  @Anonymous ,

I get the point, you are using Distinct function in Support Person dropdown, so you need to use "Dropdown_SPN,Selected.Result" to call the selection.

Please modify your formula as below:

Filter('Daily Logs', 'Supported Person' = Dropdown_SPN,Selected.Result && 'Shift Period' = Dropdown_Shift.Selected.Shiftperiod)

If this doesn't work, please post back the error detail of formula.

Best regards,

Sik

[Anonymous]

@v-siky-msft 

I've attached a screenshot of the error. It appears to not like the '='?

I changed the column names to remove the spaces as I thought this may be causing some issues (now SupportedPerson and ShiftPeriod)

[v-siky-msft]

Hi @Anonymous ,

I can't see the attachment of screenshot.

We need it.

Best regards,

Sik