Im trying to compare 2 Sharepoint lists and have it output the differences. I went with the below formula:
Clear(TEMP_COLLECTION_B); ForAll( Local_Collection_A, Collect(TEMP_COLLECTION_B, Filter( Local_Collection_B, !(Local_Collection_B[@Email] = Local_Collection_A[@Email])) ) )
Whren I tried to run that code, it crashes my browser ... Both lists have about 800+ entries and both have the same columns.
Would anyone know if im missing something?
There was a solution for this in the Flow Forums. It may work here also. Here's the thread:
Thanks for the info but this isnt quite the problem. My 2 lists are already in sync using MS FLOW but some entries didnt quite follow it seems. The whole reason why im trying to build an app is to identifiy the deltas. Any ideas on how to go about this?
Hi @Owizardo ,
Do you want to filter the items that are not in listA?
Try this formula:
ClearCollect(TEMP_COLLECTION_B,Filter(Local_Collection_B,Not(Email in Local_Collection_A.Email)))
Community Support Team _ Phoebe Liu
Can you provide the list of columns and any columns other than ID that would have unique values? Can you guarantee the ID columns in the two lists match? Since there are over 800 items you'll need to find a way to filter both lists to less than 500 or you'll need to load them into local collections. Loading them into local collections is very time consuming so it would be better to filter them.
Fill out a quick form to claim your user group badge now!
Find out where you can attend!
Features releasing from October 2019 through March 2020
Learn how to build the business apps that you need.