Unanswered

Lookup/Filter record based on multiple columns

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi All,

I was running into issues when trying to get a unique return of record based on values in 2 different columns 'WODescription' & 'PN'

I am currently using this function, 'Description' & 'PN' are 2 columns in my list 'Inspection Findings'. I was trying to filter out a table with 'Description', which could return me with a table of all same 'Description', then I lookup from this table returned to look for the specific 'PN' I am looking at.

LookUp(Filter('Inspection Findings',Description=BrowseGallery4.Selected.Description),PN=BrowseGallery1.Selected.PN)

But this function gives me error message as below:

Would appreciate if anyone could help with this.

Thanks.

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Sort by

PowerAddict 7,316 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Please let me know what BrowseGaller 4 and 1 are. And where have you placed the above formula? Is it the Item property of either of the 2 galleries?

Glad I could help! Good luck with the rest of your app! Feel free to reach out in case of any questions!

Thanks,
Hardit Bhatia
The Power Addict
https://thepoweraddict.com

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

Like (0)

Report
Copy link

Link copied!

Hi My browseGallery 4 is connected to a different list 'Inspection Task List" when browseGallery 1 is connected to a third list 'Inspection Part List'. The formula I am placing on item property of a form in a new screen connected to the original list 'Inspection Findings'.

Hope it clarify.

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

Like (0)

Report
Copy link

Link copied!

Hi My browseGallery 4 is connected to a different list 'Inspection Task List" when browseGallery 1 is connected to a third list 'Inspection Part List'. The formula I am placing on item property of a form in a new screen connected to the original list 'Inspection Findings'.

Hope it clarify.

Was this reply helpful? Yes No