Unanswered

Deleting all but an example row from excel spreadsheet

(0) Share

Report

Posted on by AJA21

Hi all

I'm relatively new and have looked through numerous threads but cannot seem to solve my problem. I have a flow to take a copy of an excel spreadsheet saved into sharepoint, and then after that I want to delete all the rows except an example row at the top. I have been able to delete all the rows (including the example row) but cannot seem to find a way to keep that example row.

I've outlined my most recent attempt below but happy for any other solution that works.

This is my most recent attempt using this Solved: How to delete rows in a table column with blank ce... - Power Platform Community (microsoft.com)

I created a new column called 'Automation' in the table and entered some text in the example row but not in any other row, however I get this error - WorkflowOperationParametersRuntimeMissingValue

The 'inputs.parameters' of workflow operation 'Delete_a_row' of type 'OpenApiConnection' is not valid. Error details: The resolved string values for the following parameters are invalid, they may not be null or empty: 'id'"

Details

formulas are: empty('Automation') is equal to

bool('false')

true = automation column 'not empty' false = automation column empty

If true - no action

If false- delete a row

I'm happy to try something completely different, I've tried "length" at "0", I've tried conditions for "contains" very specific text from the example row, but I keep getting errors like the above.

Any help or even entirely new flow welcome.

Thanks in advance!!

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (0)

v-yetonggu-msft on at

Like (0)

Report
Hi @AJA21 ,

Please check this test:

Excel Table:

Flow Run History:

Flow Configuration:

empty(items('Apply_to_each')?['Column1']) empty(items('Apply_to_each')?['Column2']) true

The Result:

Best Regards,

Sunshine Gu

Was this reply helpful? Yes No
AJA21 4 on at

Like (0)

Report

Hi Sunshine Gu

I tried this but got "ActionBranchingConditionNotSatisfied
The execution of template action 'Delete_a_row' skipped: the branching condition for this action is not satisfied."

A couple of questions I didn't add a second condition eg Column 1 and Column 2 as I only have one reference column, is this somehow important to the functionality? Also i could not create a fx for 'true' only bool('true') so I used that and then also tried just the word true, both gave me the same error above.

Thanks
AJA

Was this reply helpful? Yes No
AJA21 4 on at

Like (0)

Report

Some screen shots in case this helps work out where I went wrong...

Formula:
empty(items('Apply_to_each')?['Automation'])

Was this reply helpful? Yes No
NathanAlvares24 1,714 Moderator on at

Like (0)

Report

Hi @AJA21 !

@v-yetonggu-msft mentioned to use the expression 'true' which you can get under 'Expression'. Select that and see if that works.

Was this reply helpful? Yes No