Hello,
It's my first experience on Power Automate, I started building an approval flow.
The idea here is :
- Someone post a document on a SharePoint list (the document is attached to this new entry) with a defined link to a process, this trigger the flow.
- The flow check the process of the document (it's a code we use in our company), go on an other SharePoint list and takeout the e-mail of the reviewer (I considered that they can be 2 or more) depending of this process number.
- They send an approval request to these person (first to respond is enough)
- Once flow is ok :
- I inform the submitter of the document
- Take the actual time, change it in the good time zone
- Take the attachment in the list and copy it in a folder (our document management lib), add all the necessary information for managing and filtering these documents.
- Change the status of the approval in the first list and add the information about the comments, approver name and time in a column
All the last step where working fine till I add the multi approver part.
I get these issues :
- Every time I used an output of the approval (approver name....) it create an "apply to each" loop. I even tried to put the "string" and "first" function to be sure to get only one element and not in an array form but in a string form, it don't seem to work.
- ActionFailed error appear on my condition but it still work fine as plan
UPDATE : This happened only when the flow was not ending correctly (-> see the error of the convert time zone), but in normal condition it work fine
- I've error with time zone conversion (output of actual time is ok, input said it's null !!!), I even tried to enter manual value and it fail...
UPDATE : I solved this issue by adding something in 'format string', it was working fine without it before, don't know why it needed it now.
I was afraid something was wrong so I created this flow again from 0, I've still the same issue, I even tried to remove this multi approver part but I still have all the issue above.
Can someone have an idea of the problem(s) and could help me ?
Everything was smooth and clear 2 days ago, but yesterday I spent my all day experimenting and looking on forum without success. It's quite frustrating to not be able to reproduce correctly without issue something that worked smoothly.
Thank you 🙂


Report
All responses (
Answers (