Filtering Using 2 SharePoint

(1) Share

Report

Posted on by NCa2

Hello

I have 2 SharePoint List
SP1 (column names)

cEmail

FName

LName

SP2

Email
Items

Amount

SP1 is displayed to Gallery1
ThisItem.ID (labelID - name of the object)
ThisItem.cEmail (labelEmaill - name of the object)

If Gallery1 is selected
ClearCollect(MyCollection, Filter( SP2, Items = labelItem.Text && Email = labelEmaill.Text))

Issue:
When I add the " && Email = labelEmaill.Text " it not working or not filtering, but when I removed the Email, it shows all the Items that is equal to labelItem.Text

Categories:

Building Power Apps

I have the same question (0)

All responses (8)

Answers (0)

CaN2 11 on at

Like (1)

Report

Hello

I have 2 SharePoint List
SP1 (column names)
c_Email
ID
FName
LName

SP2 (column names)
Email
Items
Amount

SP1 is displayed to Gallery1
ThisItem.ID (labelID - name of the object)
ThisItem.cEmail (labelEmaill - name of the object)

If Gallery1 is selected
ClearCollect(MyCollection, Filter( SP2, Items = labelItem.Text && Email = labelEmaill.Text))

Issue:
When I add the " && Email = labelEmaill.Text " it not working or not filtering, but when I removed the Email, it shows all the Items that is equal to labelItem.Text

Please help. TIA

Was this reply helpful? Yes No
WarrenBelz 153,079 Most Valuable Professional on at

Like (1)

Report

Hi @NCa2 ,

What type of field is Email and can you see the correct matching value in labelEmaill

Was this reply helpful? Yes No
CaN2 11 on at

Like (1)

Report

Email field is Text in SP and yes, it is matched.
Thank you for your response, @WarrenBelz

Was this reply helpful? Yes No
WarrenBelz 153,079 Most Valuable Professional on at

Like (1)

Report
@NCa2 ,

If you are selecting from the Gallery

ClearCollect( MyCollection, Filter( SP2, Items = ThisItem.Items && Email = ThisItem.Email ) )

Calculated labels are often not reliable if you refer to their content for other purposes.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No
CaN2 11 on at

Like (1)

Report

ThisItem.Items is not working, but when I removed the "ThisItem"
It's working fine and showing all the data that is equal to Items(Value), but the email is not working even the
SP1 email is equal to SP2 email

I tried with and without ThisItem in Email

Was this reply helpful? Yes No
CaN2 11 on at

Like (1)

Report

@WarrenBelz
Gallery1 Items: SP1

Onselect:
ClearCollect(
MyCollection,
Filter(
SP2,
Items = labelItems.Text && Email = ThisItem.Email
)
);

Error/Message of the code above
MyCollection: We didn't find any data

________
I tried this code
ClearCollect(
MyCollection,
Filter(
SP2,
Items = labelItems.Text && Email = labelEmail.Text
)
);

and same issue/message

Was this reply helpful? Yes No
WarrenBelz 153,079 Most Valuable Professional on at

Like (2)

Report

@CaN2 ,

Where are you running this code from and where are the labels situated (I assume in the Gallery) ? ThisItem will work if you are running the code from inside the gallery. If not, it will only refer to the first record in the gallery, so will not do what you want.

Was this reply helpful? Yes No
CaN2 11 on at

Like (1)

Report

Thank you @WarrenBelz

Was this reply helpful? Yes No