Power Platform Community Forum Thread Details

how to reference column name in expression for update a row in a table excel connector

I'm trying to build a flow that references the column name in the excel 'update a row in a table' connector via expression but can't seem to figure out the correct syntax to reference the item.

For context: I have a large report that I use to update my more limited scope report in a slightly different format. To do this I list rows present in a table for both reports (so that I have dynamic content available). I then call the update a row in a table connector and place it inside an apply to each where it references the value of each item in the larger report. I then match the large reports employee column to my colleague column for 'key column' and 'key value' in the update a row connector. I have an if statement in each of the columns that I'm updating where I'm checking that the larger report item matches the smaller report column and if true it places an 'x' on that cell in my smaller report. I have it working now but I'm having to manually type the column name in my if statement as the evaluator condition but I would like to have it dynamically reference the column that the if statement resides in (This will future proof my flow by not requiring the if statement to need to be fully retyped anytime one of these columns changes names).

I've also tried

if(contains(body('Update_a_row')?['item'], body('Select')?['Name']), 'Fizz', 'Buzz')

But I get this error:

Flow save failed with code 'InvalidTemplate' and message 'The template validation failed: 'The 'inputs' property of template action 'Update_a_row' at line '1' and column '4622' is not valid. The action cannot reference itself.'.'

In closing. Is this possible with power automate or not. I see the item/column_name in the 'peek the code' (see screenshots) so I know its there I just can't figure out how to reference it. Any help would be greatly appreciated. TIAPeek the code outputupdate a row connector