Dropdown To Filter Gallery Connected to Excel table

(0) Share

Report

Posted on by ahmadluq

Hi,

I am new to power apps.

I have followed the YouTube channel on how to filter the gallery.

I have go through all the subject related to drop down filter.

But I still not get the solution.

I already spend 3 days searching what when wrong with my gallery's filter formula.

I have a gallery with data from excel table tbl_DetailsOpx.

I created a dropdown (Dropdwon1) with fx: Distinct(tbl_DetailsOpx, 'BUDGET CATEGORY').

Then on the gallery Items formula: Filter(tbl_DetailsOpx, 'BUDGET CATEGORY'= Dropdown1.Selected.Value).

But when preview, the gallery is empty. No filtering action happened.

Can anyone help me.

Thanks you very much.

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

v-mengmli-msft on at

Like (1)

Report
Re: Dropdown To Filter Gallery Connected to Excel table

Hi @ahmadluq ,

What data type is 'BUDGET CATEGORY'?
Maybe you can try this:
Filter(tbl_DetailsOpx, Text('BUDGET CATEGORY')= Text(Dropdown1.Selected.Value)) Or Filter(tbl_DetailsOpx, Value('BUDGET CATEGORY')= Value(Dropdown1.Selected.Value))

Hope this helps you!
-----------------------------------------------------------------------------------------------------------------------------------
If my answer solves your problem, please accept it as a solution to help more people stuck on the same problem find it.

Best regards,
Rimmon Li

Was this reply helpful? Yes No
ahmadluq on at

Like (0)

Report

Re: Dropdown To Filter Gallery Connected to Excel table

Hi Rimmon Li,

Sorry for my late response.
Thank you for your fast reply.

Sorry I don't know how to set the 'Budget Category' excel column data type.
Can you explain how to do that in this thread?

And, I've tried your 2 formula. The 1st formula is working.
I am very glad.
But, when I using this formula it have error.
FontWeight=If(ThisItem.IsSelected, FontWeight.Semibold, FontWeight.Normal)

Can you please help me how to fix this formula here or I need to create a new thread?

Thank you very much.

Was this reply helpful? Yes No
ahmadluq on at

Like (0)

Report

Re: Dropdown To Filter Gallery Connected to Excel table

Sorry Rimmy,

That error due to my bad.
I miss to the last ')', I only put the 1 instead of 2.

My filtering problem is solve due to this data type statement.
Btw, can you advise how to set the data type for the excel column?

Thank you very much.

Was this reply helpful? Yes No