Answered

Dropdown not filtering Gallery

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi,

I have set up a dropdown box, pulling it's items from defined column entries in colum 'Tag Status', Data Source 'Tagging Results'.

I have a gallery pulling all info from data source 'Tagging results'.

I have also added a variable to display Gallery results based on User (if selected).

I would like the user to have the ability to filter the results by 'Tag Status' from the dropdown if the User Variable is not True.

My formula is set up with an If function to look at the variable and then to filter the results based on the Dropdown selected value.

If(minevar=true,Filter('Tagging results','Created By'.Email = User().Email),Filter('Tagging results','Tag Status'=Dropdown2.Selected.Value))

In this case I do not get any errors, just a warning, but the results do not display. Any ideas?

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Jeff_Thorpe 6,085 Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!

The warning is probably about delegation because you are using User() in the formula. Is 'Tag Status' a text field?

To get around the delegation of User() add a global variable in the OnStart of the app or the OnVisible of the screen and set it to the email address of the user. Then use that variable in the filter formula.

Example:

Global Variable: Set(gvUserEmail, User().Email)

Formula: If(minevar=true,Filter('Tagging results','Created By'.Email = gvUserEmail ),Filter('Tagging results','Tag Status'=Dropdown2.Selected.Value))

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

Like (0)

Report
Copy link

Link copied!

Thanks so much for your reply. Unfortunately, when I tried it out it was not successful. I think that it is the 'Filter by dropdown' portion of the if function rather than the 'filter by user' portion. When I remove the 'Filter by dorpdown' section I am able to disply the gallery using the existing variable to navigate between all results and current user results.
If(minevar=true,Filter('Tagging results','Created By'.Email = User().Email),'Tagging results')

If i remove the 'Filter by user' portion and just leave the filter by dropdown portion I get an invalid argument type error. Screen Snip attached.
Thanks

Was this reply helpful? Yes No
Verified answer

v-monli-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!
Hi @Anonymous ,

What is the column type of 'Tag Status' column? If it's a choice column, then the formula should be:

Filter('Tagging results','Tag Status'.Value=Dropdown2.Selected.Value)

Also, what is the formula that creates the variable minevar?

Regards,

Mona

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

Like (0)

Report
Copy link

Link copied!

Thank you so much, you were right, it is a choice column, I was missing that additional '.Value'.
Thanks again for saving the day, appreciate all the help.

Was this reply helpful? Yes No