Unanswered

Filters

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hello good afternoon.

I hope you can help me I have two lists in sharepoint, one with users and another with the accessories data, the accessories list extracts information from the user list (email, name, location) by means of a lookup of the RID column of the list of accessories to know who has that accessory.

I have a nested filter that looks for the serial number and the control number of the accessory but I can't make it also filter by name or email, I hope you can help me, the error is attached.

Formula:

Filter (Inventory, StartsWith ('Serialnumber', TextSearchBox1.Text), StartsWith (ControlNumber, TextSearchBox2.Text), StartsWith ('RID', TextSearchBox3.Text))

Regards

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (0)

Sort by

StalinPonnusamy Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Anonymous

Updated to avoid Delegation warning

With( { sData: Filter( Inventory, IsBlank(TextSearchBox1.Text) || StartsWith( Serialnumber, TextSearchBox1.Text ) ) }, If( !IsBlank(TextSearchBox2.Text), Filter( sData, StartsWith( ControlNumber, TextSearchBox2.Text ) ), If( !IsBlank(TextSearchBox3.Text), Filter( sData, StartsWith( 'RID', TextSearchBox3.Text ) ), sData ) ) )

sData - Variable name

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

Like
a
(0)

Report
Copy link

Link copied!

hello Stalin
I already tried but the same thing keeps happening when I try to place the email that is in the gallery and that does the search by RID where the user data is, it sends me an error (invalid argument) but if I replace it with a data from the inventory list if you search without problems.
The data without searching the user's email and department if it shows them in the gallery but unlike the data that is extracted from the list directly from inventory are without quotes (ThisItem.Email.Value) I do not know if it has something related.

Thank you so much

Was this reply helpful? Yes No
StalinPonnusamy Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Anonymous

I spend quite a bit of time filtering the lookup but it seems you can filter but good for dropdown or combo box. Not for gallery filter.

Another option is to use a button to filter the main list first and loop through the second list using a collection.

Was this reply helpful? Yes No
StalinPonnusamy Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Anonymous

To test this, create a new screen and have a button. On select of the button place this code
ClearCollect( colTest1, Choices(IssueTracker.Event) ); ClearCollect( colTest2, Filter( EventIItinerary, StartsWith( Title, TextSearchBox3.Text ) ) ); ClearCollect( colTest3, Filter( Choices(IssueTracker.Event), Id in Filter( EventIItinerary, StartsWith( Title, TextSearchBox3.Text ) ).ID ) )

IssueTracker - SP list 1
EventIItinerary - SP list 2
.Event - Lookup to List 2

Was this reply helpful? Yes No