Announcements
Hello,
i have a power automate flow that takes the attachment (CSV) from an email and saves it to a sharepoint folder. The flow was working okay, until recently, the flow keeps failing. I get an error "Action failed. No dependent actions succeeded" for the For Each, Condition and on another for each. While my create file to Sharepoint gets a "Bad Request".
My flow is as follows My trigger is when a new email arrives (V3), initialize variable Name: varWHBooking Reference, Type:String, Value: empty, Initialize variable - Name: LoadingFinishedTime, Type: String, Value: empty, Html to Text, Compose1 (substring(triggerOutputs()?['body/subject'], 35, 27)), Compose2: (concat( substring(body('HTML_to_Text'), add(indexOf(body('HTML_to_Text'), 'Loading Finished Time:'), 155), 13), substring(body('HTML_to_Text'), add(indexOf(body('HTML_to_Text'), 'Loading Finished Time:'), 169), 2) )), set variable Name:varWHBooking Reference, set variable - Name: LoadingFinishedTime, For Each - attachment from the trigger, Condition - attachment name contains csv, get attachment - message ID: message Id of the trigger, Attachment ID: attachment id of the attachment, Compose3 - concat(variables('varWHBookingReference'), ' ', variables('LoadingFinishedTime')), For Each - attachment from the trigger. Create file (Sharepoint) - File Name: Output of the compose3, File Content: Content Bytes (Get attachment)
What could be causing this error, because it has worked before and i dont know where to look anymore.
concat(variables('varWHBookingReference'), ' ', variables('LoadingFinishedTime'))
concat(variables('varWHBookingReference'), ' ', variables('LoadingFinishedTime'), '.csv')
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.