Clear Cells - Power Automate

Like (0) Share

Report

Posted on 18 Nov 2023 17:01:36 by BenHubbard

Hi All,

I have an MS Form for people to fill out when a vehicle is returned to service (from maintenance etc).

The flow is set up to populate a 'vehicle tracker' table in excel, then copy this data across to a separate maintenance history worksheet before clearing the relevant columns on the vehicle tracker sheet (fault, date reported, date completed, latest update etc.)

As it currently stands, I can't see a way to clear the cells in the relevant column that isn't just add "[SPACE]" - this then prints a space into the cell which I want to avoid.

Is there a function I can input in the advanced parameters of the 'update row' action in the flow?

Thanks!

I have the same question (0)

All responses (2)

Answers (0)

Pstork1 67,693 Most Valuable Professional on 18 Nov 2023 at 17:35:21

Like (0)

Report

Re: Clear Cells - Power Automate

If you initialize a string variable and leave it blank you can use that variable to clear a cell value. Null won't work because the connection will ignore that, but an empty string will work. But you have to create the empty string as a variable or the connection will think you just didn't fill anything into the field.

Was this reply helpful? Yes No
ManishSolanki 15,089 Super User 2025 Season 2 on 18 Nov 2023 at 17:26:17

Like (0)

Report
Re: Clear Cells - Power Automate

Hi @BenHubbard

You need to use expression to set the blank value in excel column during update. Here is an example:

In below example, I am setting type column to blank in excel sheet:

Expression needs to be entered in the expression window as highlighted in the above screenshot:

string('')

If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.

Thanks

Was this reply helpful? Yes No