I built a flow that populates a list from a submitted microsoft form. It fails most of the time but is also successful. Let me explain, there are two scenarios:
1. Form is submitted with an attachment: Status is successful and form information populates successfully into list
2. Form is submitted without an attachment: Status is Failed and form information populates successfully into list
Each time, the flow does what it needs to do, i.e., populates the form with the right info; however, when there isn't an attachment, the flow "fails" even though an attachment is not mandatory. As a result, Power Automate keeps turning off my flow because it thinks it's failed even though it's working as designed.
How do I add a condition that will make sure it runs successfully each time, regardless of whether an attachment is present?
Screen caps below:
Successful (attachment added):
Failed (no attachment included but list successfully populates):.
It makes sense to me. You have the Create Item first, which takes the non-array items from the Form.
Then you are doing an Apply to each, which is most likely the Question that lets them upload 1-10 files.
Unfortunately that person didn't upload any files (must be not a required field), so that fails, because the Array is blank.
If you want to not have this happen
A) Set the question to Required, so they have to upload something
or
B) Use a Condition first. Have it check if the Question has any files returned. If its NULL, do nothing, if its NOT null do something.
That will solve your issue.
Was this reply helpful?YesNo
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
2
Share
Report
All responses (
Answers (
