You’re offline. This is a read only version of the page.
9
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!
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.
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
#1
Michael E. Gernaey
497
Super User 2025 Season 1
#2
David_MA
436
Super User 2025 Season 1
#3
Riyaz_riz11
244
Super User 2025 Season 1
Share
Report
All responses (
Answers (
