I am trying to populate data in an excel spreadsheet, this will then be used later in other flows to populate ms Lists etc.
I have a column where the filed is formatted as general, but has a numbers (Incident number) in it. some of these fields do not have anything in. in these instances i would like a 0 (zero) to be populated.
Here is the set up
The condition is as follows
When executed this flow fails to populate with the following detail
The final part of the flow the 'True' statement should populate the empty cells in the column with 0 as follows
where am i going wrong? Have i misunderstood the final screen shot where i understand this is the value that should populated?
