Power Platform Community Forum Thread Details

So I am trying to use the add rows to table action to routinely move Completed status rows to a completed file and then delete them from the original document.

However not all cells will have data in them all the time. I have run into issues before where if a cell is null it will return an error saying something like was expecting string when there was a null.

So I am trying to find an expression that will basically enter the data if it has it but enters N/A if null. to each section of the add rows to table.

So far the expression I did try

if(empty(outputs('Status')), null, outputs('Status'))
Is giving an error in the flow checker.
"Correct to include a valid reference to 'Status' for the input parameter(s) of action 'Add_a_row_into_a_table'."
So I am not sure how to fix this.

Basically I want to run something once a week where if the status is labeled Completed Canceled or Removed then it adds the row to a completed file and then deletes the entry in the original document.

Categories:

Building flows