Hi There, am wondering if someone can help me with a power automate flow that would loop through a dataset for mapping. The data is currently in an xls file with 2 worksheets (All Data and Reversed Keys). I would like to map the All Data to the Reversed Keys, if there's a match then place the value in an empty column.
Below is a screen print of the data layout, I thought this might be better than my explanation above. Thanks in advance!