Power Platform Community Forum Thread Details

Good Morning,

In the posted excel sheet there are two sheets that have user names and ID. I need a flow that will read sheet 1 and if there are any blank cells is the ID column to go to sheet 2 and get those id and write them back to sheet 1. I'm using power automate desktop.

If current item row ID in sheet 1 is blank then check sheet two current row ID get data and write back to sheet one