
Announcements
Hi,
I'm a complete beginner with Power automate. I checked the forum but didn't find the topic/answer I'm looking for.
There's a simple process at work I'd like to automate :Reception to Inventory to Analyse .
My idea was to
1) create a SP list with name and role
| reception | inventory | analyse | ||
| Mr A | yes | yes | no | blabla@.. |
| Mr B | yes | yes | yes | blabla@.. |
| Mr C | no | no | yes | blabla@.. |
2)Create a second list
| reception_staff | date of reception | reception_status | inventory_staff | inventory_date | inv_status |
Where reception_staff would be a dropdown list with staff a having reception role ("yes" in the 1st column of 1st SP list)
Where an email would be sent to staff having an inventory role ("yes" in the 2nd column of 1st SP list) when reception_status is recorded as "Completed".
Same logic for the rest of the workflow
etc
Maybe there's a easier way to do it...
Most appreciated if you can advise on feasibility or on the best option to doit!
Thank you