Contents
Is there a way to compare two lists?
What I’m really looking for is a way to compare two lists to find mismatches. In any other language, I’d loop through one array, and for each item, check if it exists in the second array. Your suggestion loops through a list, and for each item, does a ‘Get Records’.
Loop through the deleted Account array and update the SharePoint item by setting the IsActive flag to No. One final thing to note: on the settings for both the Salesforce and SharePoint queries, I turned on pagination and set the limit to 5000. I have ~1000 Accounts I’m keeping in sync, so we want to make sure we get all the records to compare.
How to delete items in SharePoint list in Salesforce account?
As an alternative way, you could take a try to create the flow as below to delete the items in sharepoint list which is deleted in the Salesforce Account: Please have a try and let me know if it works. 04-11-2018 03:34 PM Thanks for the replies. What I’m really looking for is a way to compare two lists to find mismatches.
I loop through List A, and if that item is not in List B, update List A by setting an IsActive flag to false (didn’t want to delete the Sharepoint item for legacy use). This would be considerably easier if Flow had an EXCEPT function!
How to find the difference between two lists in Python?
The difference between two lists (say list1 and list2) can be found using the following simple function. By Using the above function, the difference can be found using diff(temp2, temp1) or diff(temp1, temp2). Both will give the result [‘Four’, ‘Three’].
How to list only unique values from two lists separately in Excel?
To list only the unique values from the two lists separately, you can apply the following formulas: 1. Please enter this formula into cell D2: =IF((ISERROR(MATCH(A2,$B$2:$B$14,0))),A2,””), ( A2 is the first cell within the Column A that you want to compare with Column B,…
How to compare two columns and list differences in Excel?
1. Please enter this formula into cell D2: =IF((ISERROR(MATCH(A2,$B$2:$B$14,0))),A2,””), (A2 is the first cell within the Column A that you want to compare with Column B, and range $B$2:$B$14 indicates another column that you want to be compared with) and then press Enter key, see screenshot: