Unanswered

Comparing sp List and collection

(0) Share

Report

Posted on by BKGOUD

Hi All,

We have a sharepoint list and collection, i need to compare the both and need to filter the data. if a particular record exists in sharepoint list with filter condition, i need to exclude those record. i have written the below code which is not working as expected.

Can someone help me on the below code.

ForAll(colEmails,
Collect(Collection1,Filter(MainCollection,Email in Collection1233.MailID &&

Not(Text(StartDateTime,"[$-en-US]m/dd/yyyy") in SPLIST.MStartDate) &&

Not(Text(StartDateTime,"[$-en-US]h:mm AM/PM") in SPLIST.StartTime)))
);

- If i add NOT condition it was not working. I have tried with '<>' and '!' instead of NOT but no luck.

Categories:

Building Power Apps

All responses (3)

Answers (0)

Sort by

Vijay Tailor 2,961 on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @BKGOUD

You can use like below code, Hope it will work for you.

ForAll(colEmails, Collect(Collection1,Filter(MainCollection,Email in Collection1233.MailID && Not(DateValue(Text(StartDateTime,"[$-en-US]m/dd/yyyy")) in SPLIST.MStartDate) && Not(Text(StartDateTime,"[$-en-US]h:mm AM/PM") in SPLIST.StartTime))) );
Thanks
BKGOUD 95 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @VijayTailor ,

Thanks for helping me. In my code the first condition returns true and others conditions are false. Will it filter the data else how it works.
Vijay Tailor 2,961 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi , if possible plz provide the more details regarding your Issue.