Unanswered

How to use Update a Row in Excel, when the Key Value is blank

(0) Share

Report

Posted on by KDV

Hello

I am building a flow to update a row in excel but I need it to update blank fields within the column, and power automate does not allow me to leave the Key Value as blank. I was wondering what expression I could use to update the blank spaces in a specific column

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (0)

v-xiaochen-msft on at

Like (0)

Report

Hi @KDV ,

First, flow expects a record which needs to be updated.

So, the key column is important.

Best Regards,

Wearsky

Was this reply helpful? Yes No
KDV 80 on at

Like (0)

Report

Thank you for replaying! I have a key column but I dont have a key value, so im looking for a way to have the key value be 'If Empty"

Was this reply helpful? Yes No
v-xiaochen-msft on at

Like (0)

Report

Hi @KDV ,

How many records do you have that the key column have no value?

If you have multiple such records, what is the logic? Update all records or update the first one?

Best Regards,

Wearsky

Was this reply helpful? Yes No
KDV 80 on at

Like (0)

Report

Yes all the records for that column. some backround we receive this report from a vendor and to input it into or system the file needs to be formatted a specific way and im trying to have the flow complete the formatting once the email comes in

Was this reply helpful? Yes No