Unanswered

Flow - ActionBranchingConditionNotSatisfied so this step is skipped

(0) Share

Report

Posted on by RachelLai

Hi there

Would like to use the flow of Power Automate to update SharePoint List based on online Excel file which saved in SharePoint folder.

Most of steps run successfully except "Create item" under Yes/ No Condition as following screen shot.

Detail message : ActionBranchingConditionNotSatisfied. The execution of template action 'Create_item' skipped: the branching condition for this action is not satisfied.

Detail flow setting is as follows,

The formula of condition is: length(outputs('List_rows_present_in_a_table')?['body/value'])

Not sure is there any reason makes "If no" is not satisfied.

Ned some comment on it and how to solve it.

Thank you.

Categories:

General topics

I have the same question (0)

All responses (5)

Answers (0)

manuelstgomes 6,625 on at

Like (1)

Report

Hi @RachelLai

Looking at the first screenshot the "Condition" action returns true, that's why the "no" branch is not executed.

Can you please confirm if the "List rows present in a table" action returns any value?

Cheers
Manuel

------------------------------------------------------------------
If I have answered your question, please mark it as "Accept as Solution." It will help other members finding the solution faster. If you like my response, please give it a Thumbs Up. ?
Otherwise, reply to it, and the community will do its best to help you.

Was this reply helpful? Yes No
RachelLai 8 on at

Like (0)

Report

Hi @manuelstgomes
Thanks for your quick response.

Before running this flow, the destination of SharePoint List - "Testing flow update list by excel" is blank and only have title columns as following screen shot.
After running flow, this list still looks like blank and the condition should match "If no" - the value
outputs('List_rows_present_in_a_table')?['body/value'] = 0.

Detail setting of "If yes"

Was this reply helpful? Yes No
manuelstgomes 6,625 on at

Like (1)

Report

Hi @RachelLai

Let me see if I understand what you're doing. So you're fetching the "List rows present in a table" to check if the file is empty correct? If it is, you can add the rows to SharePoint; otherwise, you create one item.

Since your file is always empty, you'll always go to the "Yes" part of the branch since you're validating if the length equals zero. But if you go to the yes part with no values, it won't create anything.

I think what you need is to check if the length is "not equals" to zero. If it's not empty, then you have a "For Each" that iterates all items and saves them to SharePoint.

Makes sense?

Cheers

Manuel

------------------------------------------------------------------

If I have answered your question, please mark it as "Accept as Solution." It will help other members finding the solution faster. If you like my response, please give it a Thumbs Up. ?

Otherwise, reply to it, and the community will do its best to help you.

Was this reply helpful? Yes No
RachelLai 8 on at

Like (0)

Report
Hi @manuelstgomes

The purpose of creating this flow is to update SharePoint List based on online Excel file saved in SharePoint.
I refer this Youtube video https://youtu.be/MtCqbRBOOb4 to create this flow.
Current scenario
SharePoint List is empty
Online Excel file with data
Per above referred video, I thought it is to check if SharePoint list is not empty (means 0). If yes, "Update item" based on excel data by ID. . If not, "Create item" base on excel data. (follow the logic of "not equal to 0")

Was this reply helpful? Yes No
RachelLai 8 on at

Like (0)

Report

@manuelstgomes
Sorry didn't noticed that your new reply 2 weeks ago.
Did you mean this?

Was this reply helpful? Yes No