Power Platform Community Forum Thread Details

Very new to the syntax of the formulas to specify the actions to only return a singular row. What formulas and actions are necessary to accomplish this? the unique identifier for these rows is column A of workbook A, "Truck"

Categories:

Building flows

Hello @CR-22102057-0

I am not certain how you are determining which row is the new row in workbook A, so I came up with my own approach. I'll walk through the syntax for each action in my flow. There may be other ways to do this. Also, by the way, there is no built-in trigger when a row is added to Excel. Hopefully someday. And OneDrive response can be sluggish.

To detect rows that are new I added a column to workbook A called Added yes or no.

Once the row is added to the other workbook, I set the value to yes with the flow using store number as the key.

Workbook A: