Hi,
Yes, this is doable. The key is to stop relying on the List rules for the assignment and do the whole VLOOKUP and the notification in one Power Automate flow.
You have an intake list where you get a new item in the form.
You want to perform a lookup in the reference list based on the Location and FoodType, then set the ‘Assigned To’ (person) field in the intake list, and then send a custom email to the assigned person.
You can use the rules to assign the value, but you cannot chain the custom email off the rule result in any reliable fashion. Also, you cannot scale beyond the rule limit.
You can use a small ‘mapping’ reference list, use the ‘Get items’ action in the flow with an OData Filter Query (your VLOOKUP), take the first result, update the ‘Assigned To’ in the intake list, then send the custom email to the person in the ‘Assigned To’ field.
Adding a couple of helper values as an example.
Compose, AssignedPersonEmail
first(body('Get_items')?['value'])?['AssignedTo']?['Email']
Compose, AssignedPersonClaims
first(body('Get_items')?['value'])?['AssignedTo']?['Claims']
Compose, SupervisorClaims (if you also set supervisor)
first(body('Get_items')?['value'])?['LocationSupervisor']?['Claims']
Thank you!
Proud to be a Super User!
📩 Need more help?
✔️ Don’t forget to Accept as Solution if this guidance worked for you.
💛 Your Like motivates me to keep helping
