Share
Report
51Hello Everyone,
I have a Total 2 lists in Sharepoint,
One list is the "Main List" Which contains 5-6 Columns in it, out of which 1 is 'ID', which is Default Generated, & Another one is 'Final_Status' - Choice Column, which has Draft Status on the creation of the ID, & it Changes to Pending when Data Gets Generated in Second List with Its relation to 1st List.
And another list "Approver List", has 3-4 columns such as 'Approver name, 'Approver email', 'Approval Comments', 'Approval Status', & one more list as 'Master ID', which is exactly similar to the ID generated in Main List, that also helps us in Maintaining a relationship between the two.
Now Every ID from Main List Contain 5 Mater ID in Approver List
Now let's talk about what I want -
I want When a New Item Is Created in Both the List, So now, An Email should be Sent to 1st level of Approver(*In Total 5 level of Approver is there), & the Email should like that in a way, such Approver Can directly Approve or Reject, & Once 1st Level Approver Approved the Request, it Should go to 2nd Level, & Cycle Repeats till 5th Level.
How I am Thinking -
I want a Power automate to be built, in which
- a trigger is set when a new item is created.
- Action – get Items From Second List with Filter Query as Master ID eq ‘ID’
- Save the Master ID in the Variable
- Either Choose Approval or Send An Email With Options
- Send the Email to 1st level of Approver, With Option As Approve / Reject, with Comment Box.
- Repeat the Cycle.
Problem –
I am a Complete Newbie to Power Automate, So want a Step By Step, how to Approach Towards this,
What I Tried-
I already Tried Watching the Approval Series Tutorial By Reza Dorrani in YouTube, also, Read about it. But seems Nothing help.
All responses (
Answers (
