Unanswered

MULTIPLE FILTERS NOT WORKING

(0) Share

Report

Posted on by Gorilla_8

Hey guys, I have an app who I wanna to filter by:

OnStart app: Show all the data from SharePoint list, and filter by email permissions.

Like, "Shane" has power to filter all the gallery with the all data on SharePoint

But "April" has no permission to filter all the data, just the data he created.

And I need to show all the data if "Shane" is logon

And if is not, show the data only the user created = "April" only see her creation.

And I make this formula:

If(User().Email="xy@email.com";Despesas;Filter(SortByColumns(Despesas;"ID";Descending);'Criado por'.Email = varUser.Email))

And it works, but I need to add a multiple filters on the formula,

When the gallery visible:

Show the gallery Descending by the data, and search by "name" on a text input" or filter by a dropdown "ID" or filter by a "status of payment"

And I tried this one:

Search(Sort(Filter(Despesas;StartsWith(Solicitante;TextInput1.Text)||ID=DropDown1.Selected.ID);ID;Descending)||ComboBox4.Selected.Value="pago")

Is that possible?

Thanks dor the help!

Categories:

Building Power Apps

All responses (4)

Answers (0)

Sort by

KrishnaV 5,023 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Gorilla_8 ,

This has to be done with one collection assigned to the gallery and that collection has to be filtered and sorted as accordingly.
OnVisible get all the records to collection "collListData"
Then apply this filter on the collection to get the required data at level one

If(User().Email="erica.dias@arapyauinstituto.onmicrosoft.com";Despesas;Filter(SortByColumns(Despesas;"ID";Descending);'Criado por'.Email = varUser.Email))

Now on change of the text input for search use below formula

Set(collListData1,search(collListData,textinputsearch.text in namecolumn)) clearcollec(collListData,collListData1); clear(collListData1); // These 2 steps to get the filtered data to collection

Now for filter on ID also OnSelect property of the dropdown do as below:

Filter(collListData,ID=dropdownlist.select.value)

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.
Gorilla_8 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks for the reply @KrishnaV , but the collection dont get all the data like before, he dont filter my data based on my email, I have to recreate it, and I dont wanna do that
KrishnaV 5,023 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Gorilla_8 ,

Then do the same set of filters on the list directly.

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.
Gorilla_8 on at

Like
a
(0)

Report
Copy link

Link copied!

I dont understand