Answered

Unmatched records query in PowerApps

(0) Share

Report

Posted on by SG-19021613-0

Hi all,

I am trying to build some data checking tools into an app. I want to be able to find records that are missing data. Within one datasouce (they are all SharePoint lists) I can make a collection and filter it to display records where a column is missing data.

I am stuggling to replicate this across multiple lists - so asking to show all records from datasource 1 which do not have a matching record in datasource 2. Is anyone able to point my in the right direction for this?

Thanks,

Sam

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Verified answer

v-yutliu-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!
Hi @SamGibbs ,

Do you want to replicate data across multiple lists and filter out the not matching record in datasource1?

If so, you need a unique field, which could be used to justify whether there's matching record.

I assume as Title field is the special field.

Then you could use formula like this to filter:

Filter(datasource1,Not(Title in datasource2.Title))

You will get records that do not have matching Title value of data source2 in data source1.

Best regards,

Was this reply helpful? Yes No
SG-19021613-0 on at

Like (0)

Report
Copy link

Link copied!

Hi

Thanks for the pointer - that didn't quite work as I needed some extra guidance, but I found this https://powerusers.microsoft.com/t5/Building-Power-Apps/Filter-a-collection-to-exclude-items/m-p/251106 which resolved it (it also got rid of the delegation issues).

Was this reply helpful? Yes No
anshenterprice 27 on at

Like (0)

Report
Copy link

Link copied!

@v-yutliu-msft in my synario , i am using Combobox instead of dropdown.
Can you assist me on this?

Thanks

Was this reply helpful? Yes No