Answered

WORKING WITH FILTERS

(0) Share

Report

Posted on by Gorilla_8

I wanna filter a gallery based on a user().Email and if is not, show the only which he created.

And I try this code:

If(User().Email="USER@ADMIN.COM";Despesas;Filter(Despesas;StartsWith(Solicitante;TextInput1.Text) || ID = DropDown1.Selected.ID || 'Status de pagamento'.Value=ComboBox4.Selected.Value;SortByColumns(Despesas;"ID";Descending);'Criado por'.Email = varUser.Email))

My goal is:

If is the USER@ADMIN.COM he can filter by name or ID or "status de pagamento", and if is not she only show the items he created.

Categories:

Building Power Apps

I have the same question (0)

All responses (20)

Answers (1)

Sort by

KrishnaV 5,023 on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @Gorilla_8 ,

Change your filter as below:
If(User().Email="USER@ADMIN.COM", Sort( Filter(Despesas, StartsWith(Solicitante;TextInput1.Text) || ID = DropDown1.Selected.ID || 'Status de pagamento'.Value=ComboBox4.Selected.Value, 'Criado por'.Email = varUser.Email)),SortByColumns(Despesas,ID,Descending))

I hope this resolved your issue if you see any challenge/need further help let me know I am always happy to help.
Regards,
Krishna
If this post helps give a 👍 and if it solved your issue consider Accept it as the solution to help the other members find it more.

Was this reply helpful? Yes No
Gorilla_8 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @KrishnaV , thanks again for the help!

But I got same error, he expects 2-3 parametres, I think I got lost some parentheses..

Take a look:

If(User().Email="user@admin.com"; Sort( Filter(Despesas; StartsWith(Solicitante;TextInput1.Text) || ID = DropDown1.Selected.ID || 'Status de pagamento'.Value=ComboBox4.Selected.Value; 'Criado por'.Email = varUser.Email));SortByColumns(Despesas;ID;Descending))

Was this reply helpful? Yes No
KrishnaV 5,023 on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @Gorilla_8 ,

My bad I have correct my syntax errors, silly me 😞
If(User().Email="user@admin.com", SortByColumns( Filter(Despesas; StartsWith(Solicitante;TextInput1.Text) || ID = DropDown1.Selected.ID || 'Status de pagamento'.Value=ComboBox4.Selected.Value; 'Criado por'.Email = varUser.Email);ID;Descending))

Was this reply helpful? Yes No
KrishnaV 5,023 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Gorilla_8 ,

I just noticed that you like my reply is there anything I am missing to mark that as a solution?

Please let me know so that I can help you better.

Was this reply helpful? Yes No
Gorilla_8 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @KrishnaV !, Igot this error:

I dont know why, i dont worl well with multiple filters.

The 'sort columns' function has invalid arguments

Was this reply helpful? Yes No
KrishnaV 5,023 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Gorilla_8 ,

Please change the Combobox selection as :
ComboBox2.Selected.Title where my combobox is populating with SampleList.Title

Was this reply helpful? Yes No
Gorilla_8 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @KrishnaV !

Didnt work out

Was this reply helpful? Yes No
Gorilla_8 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @KrishnaV !

I have make a filter by all the data, but can you help me to filter by selected user?

Filter(Despesas;CreatorEmail=varUser.Email||Solicitante = TextInput1.Text||'Status de pagamento'.Value=DropDown1_1.Selected.Result||ID=DropDown1.Selected.ID)
I have this code, but I wanna the user logged filter by only his created item.

Was this reply helpful? Yes No
KrishnaV 5,023 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Gorilla_8 ,

Filter(Despesas;Creator.Email=varUser.Email||Solicitante = TextInput1.Text||'Status de pagamento'.Value=DropDown1_1.Selected.Result||ID=DropDown1.Selected.ID)// if creator is a people picker column Filter(Despesas;Created.Email=varUser.Email||Solicitante = TextInput1.Text||'Status de pagamento'.Value=DropDown1_1.Selected.Result||ID=DropDown1.Selected.ID)// this will pull with the default created sharepoint list column

I hope this resolved your issue if you see any challenge/need further help please let me know I am always happy to help.

Regards,
Krishna
If this post helps give a 👍 and if it solved your issue consider Accept it as the solution to help the other members find it more.

Was this reply helpful? Yes No
Gorilla_8 on at

Like
a
(0)

Report
Copy link

Link copied!
I understand, but I created a column "CreatorEmail" on sharepoint to get the email and filter by, the "created" wont workout here.

So i tried this

If(User().Email="user@admin.com";Despesas;Filter(Despesas;CreatorEmail=varUser.Email||Solicitante = TextInput1.Text||'Status de pagamento'.Value=DropDown1_1.Selected.Result||ID=DropDown1.Selected.ID)

And dont show the only items I created

Was this reply helpful? Yes No