Hi Team,
I'm working on a flow and I would love some assistance in getting it to work, here is the scenario:
I have 2 share point lists, from list A I need to pull out data based on certain field filters, this part is no problems. I then have a 2nd SharePoint list where I want to look at the vendor name in list A, look for that vendor in list B, if there is a match, then grab 3 fields (various account numbers and chargeback accounts) from list B, combine that data then export the data in to excel or csv.
The end result will be the contents from list A, and each vendor in list A will now have the information from the 3 fields that were matched to that vendor in list B.
EG:
List A:
Data rows from columns: Vendor, B, C, D
List B:
Data rows from Columns: Vendor (Matching from list A), E, F,G
End Result
File containing columns: Vendor, B, C, D, E, F, G
Any help you can provide would be much appreciated, thanks for your time!
