You’re offline. This is a read only version of the page.
Announcements
2
Hi!
I was able to use filter array to compare two columns from different sharepoint lists, one masterlist and one record, then add the unique values into a new sharepoint list. But I also need some of the other information from the other columns on the masterlist to be included in the new list. Whenever I just try to add the flow automatically creates an 'apply to each' and the output values on the masterlist gets all messed up and duplicated. How do I avoid this.
This is what the masterlist looks like:
This is what the records look like:
I would like the flow to look at the employee numbers only and generate a new list that's all the employee numbers that aren't in the records. But I would also like the First Name, Department, and Position Code column to be included in the new list like this:
Please help!
@mcfkim Please reference this YT Tutorial I recently uploaded that covers how to use the Filter Array action to cross-reference data.
The first section covers how to cross-reference data from an Excel Table against a SP list. The same concept applies for cross-referencing two SharePoint lists.
Tip: You can also toggle on enforce unique values for the Employee No. column to prevent any duplicates as well.
Hope this helps!
Share
Report
All responses (
Answers (
