Hi-
I'm new to power automate and I'm trying to build a flow where after event is triggered when item is created from list it will map from reference excel table with column 'category', 'approval needed', and 'approver email'.
It will trigger approval which mapped based on 'category' input since the approver email and approval needed checklist is dynamic to each categories.
Something like this
----------------
Event is triggered in list
Category |
Date |
Status |
Attachment |
Others |
Otomotives |
1-May-25 |
Pending |
- |
- |
it will mapped to excel with reference table as below
Category |
Approval Needed |
Approver |
Otomotives |
Review Budget |
apple@live.com |
Otomotives |
Review Toolkit |
banana@live.com |
Otomotives |
Review Media |
pear@live.com |
Phone |
Review Toolkit |
grape@live.com |
Phone |
Review Media |
pear@live.com |
and the flow will go to approval dynamically to each person on what approval is needed based on input every time event is triggered and the attachment file approval to be reviewed
I have tried building flow as below but got stuck in the Approval flow where in the details for approval needed it is showing the whole list to each approver instead of dynamic. Any suggestions to the changes of workflow is greatly appreciated :)
Thankyou!