cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
RMITRic
Frequent Visitor

Action 'Condition_3' failed

I am part-way through developing a flow to aggregate data from multiple Excel files into one excel file. All the source files have multiple worksheets and the data is not in tables. In this part of the flow, I need to skip the first worksheet (no data of interest) and depending on whether the worksheet name begins with "VCVE", create a 3 or 4 row table in the sheet. The flow tests the worksheet name twice but the second condition (named 'Condition_3') fails, indicating "no inputs" error the first iteration through but in the second and subsequent iterations it tests correctly. Is there a different way of achieving what I want to do and avoid this error?

Thanks in advance for your advice.

 

Below: Conditon_3 results in "No inputs" error on the first iteration of the loop.

First iteration: No inputs errorFirst iteration: No inputs error

 

Below, Condition_3 results in 'false' and evaluates correctly in subsequent iterations.

2nd iteration: condition evaluated false2nd iteration: condition evaluated false

 

Below: shows how the conditions are set

Conditions settingsConditions settings

 

1 ACCEPTED SOLUTION

Accepted Solutions
RMITRic
Frequent Visitor

This error message ceased when I fixed the 'Bad request' error in the create table action. I still don't understand the 'Condition_3' fail error but it appears to be caused by a downstream action failure. Anyway, things are working now.

View solution in original post

1 REPLY 1
RMITRic
Frequent Visitor

This error message ceased when I fixed the 'Bad request' error in the create table action. I still don't understand the 'Condition_3' fail error but it appears to be caused by a downstream action failure. Anyway, things are working now.

View solution in original post

Helpful resources

Announcements
MPA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Top Solution Authors
Users online (1,737)