Compare two SP lists and only show names that haven't submitted records for today

(0) Share

Report

Posted on by Enriquitio

Hi!

I have a challenge.

So.... two Sharepoint lists which have the same denominator.

SP1 is a SharePoint that captures the report detail from the user

SP2 is a master name list of all the people I expect a report from.

SP1 (Name)	SP2 (Name)
Harry	Harry
Tom	Tom

I then have a PowerApp which I would like to have a gallery that only displays the names that have not submitted for today's date.

For example, Harry submitted a record for today but Tom didn't, All I would see on the gallery is Tom's name..hopefully, that makes sense.

Question is, how the pineapples do I do it? I have tried creating a collection that only captures all the records submitted today but when I try to compare my master name list against the collection I lose the will the live!!

Any help would be amazing!

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (0)

Sort by

Drrickryp Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@Enriquitio

ClearCollect(colC, Filter(colA, !(ID in colB).ID))

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

Like (0)

Report
Copy link

Link copied!

@Enriquitio

ClearCollect(colC, Filter(colA, !(ID in colB).ID))

Was this reply helpful? Yes No
Enriquitio 88 on at

Like (0)

Report
Copy link

Link copied!

Not sure about this, I dont have three collections? Please explain thanks

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

Like (0)

Report
Copy link

Link copied!

@Enriquitio

If you create two collections colA and colB from your tables, then This will give you a new collection of names not included in both collections.

ClearCollect(colC, Filter( ColA, !(ID in ColB).ID ))

Was this reply helpful? Yes No
Enriquitio 88 on at

Like (0)

Report
Copy link

Link copied!

Ok so i have my two collection running.

ClearCollect(colSites,'Site List') //This is my master site table.
ClearCollect(colReported,Filter('DataTable',DateDiff(Created,Today())=0))//This is my collection for capturing all records submitted today.

The third collection is the compare - ClearCollect(colC, Filter( colSites, !(ID in colReported).ID )) I get how this works but I want to use a column that has a customer contract in it. For example, Audi equals Audi and doesn't want to use ID plus that diferent work becuase the ID are not aligned.

Thanks,
Harry

Was this reply helpful? Yes No