@CU27022257-0,
Let's setup some prerequisites for creating the flow:
You have mentioned travel request WF is needed so that approval can granted from high-officials/managers. You have MS forms, SharePoint and Outlook. Apparently, it seems you will submit the request from MS Form, users/approver are in the SP and email will be sent to respective email address for approval. Also, I am assuming country (Which country the employee will travel) list is there in the SharePoint list.
Step-1: Select the trigger "When a new response is submitted" in the power automate. When a travel request form is submitted, it will Trigger the flow.
Step-2: Assuming form has been submitted with Name, designation, country to travel, travel start date and end date with email address. In this case we will use Get response details action to retrieve form's data. Most specifically what we need is country name and the requester email.
Step-3: I assume in SP/Dataverse, you have a mapping countries to admin group users, if not please do that mapping in any SP list. Once done, we can do a lookup for country vs admin, for this we can leverage Get items (SharePoint) filtered by the country from the form, from there we can extract admin. Trick to consider - if these mapped users are your approving manager - extract approver manager's email to send for approval.
Step-4: Compose approval recipients - Combine the admin group and approving manager emails into a single string (semi-colon separated) or array for approval. The screenshot below - is a sample of email addresses (in your case these will be retrieved from SP list or User group)
Using join data operation to with semicolon(;).
Step-5: Let's use "Start and wait for an approval" action and then pick up the composed recipients (semicolon separated) and set the Assigned to field dynamically.
Step-6: Additional check you can put is If approved, proceed with the workflow (e.g., update SharePoint list, send confirmation). If rejected, notify requester or take alternate action.
I would suggest before starting a production grade WF, try this one for a play-around practice.
One more is here.
I am sure some clues I tried to give. If these clues help to resolve the issue brought you by here, please don't forget to check the box Does this answer your question? At the same time, I am pretty sure you have liked the response!
