
Announcements
Dear forum,
I need a function in my flow that logs all decisions and comments of the approvers in a single column called "Log" in my sharepoint list.
A couple of people (and not only the initiator of the approval flow) need to know who has already approved and who still has to do.
Who can help?
I used the basic setup from this video (Johnn Liu and Jon Levesque) : https://www.youtube.com/watch?v=RWwD8mGF_zU
This is what I have so far:
1) When an item is created (in my sharepoint list)
2) Send http request to Sharepoint
>>> This is to get all the users of the entered Sharepoint group (all the guys who have to approve; can be up to 20 persons)
3) Initialize variable (called approverEmails; type string)
4) Parse JSON
5) Apply to Each: Append to string variable
6) update item in my sharepoint list
>>> This simply adds all emails in "approverEmails" as a multiple line text
>>> Now everyone can see, who has to approve
7) Start and wait for an approval - Custom > Wait for all responses
>>> assigned to "approverEmails"
>>> only one option called "OK"
>>> so people cannot reject. No need for a decision tree later on...
😎 Select
9) Create HTML table
10) update item
>>> This one just changes the status from "open" to "done" in the sharepoint list
11) Send an Email
>>> sends an email to the flow initiator with all comments in a table ("Output")
Total:
Thanks for your help
Best Regards
Florian
Can anyone please help? Is it too complicated?
I searched already a couple of hours but didn't find a solution ...