Contents
Go to Solution. 10-16-2020 08:04 AM Step 2 : Use an Apply to Each action and Get items from beta list where Filter Query will be – ( where AlphaID is a lookup column of Alpha list storing ID and replace [ID of Get Items] with the ID value )
How do you compare two lists in Excel?
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’. Running a seperate query on each item could get expensive when my list has thousands of items.
How to compare SharePoint lists Alpha and beta?
Alpha and Beta. Alpha contains all items and Beta only some. How can i create a flow that will look in to Alpha, realize whats should be in beta…see that item 2 is missing and will send an email to item 2… (we dont need to worry how to send email, just the comparison part).
How to compare master list to child list?
All I am trying to do is compare a master list (SFBForm_Course_2018GF1 – all students with their associated courses) to a child list (SFBForm_Students_1018GF1 – only students that have completed a survey). The column that matches are Key = Stu_Email_Course_Key.
You can use this technique when you are comparing other type of fields in SharePoint such as Numeric or Currency or even text based fields – First use a calculated field for the comparison then filter on the result of the calculated field.
Which is the function to compare a column to a list?
To compare one column to another column or a list of values, use the EXACT and OR functions. To check if a column value or a part of it matches specific text, use the IF, FIND, SEARCH, and ISNUMBER functions. To count nonblank columns, use the COUNTA function. To remove characters from text, use the LEN, LEFT, and RIGHT functions.
How to filter two fields in SharePoint list?
There are many instances where you might want to view a set of SharePoint list records which have been filtered on a comparison between values in 2 columns.