Hello,
I have created a purchase requisition form using Microsoft forms that saves the responses into an excel file on our share-point. I have setup a working flow that captures those responses, and depending on the type of requisition (differentiated by sections) it will send a customized email containing the dynamic responses of the form, along with any files that were uploaded during the process to the original submitter and my procurement team.
I have tried numerous examples and failed to insert the correct actions and triggers that will allow me to also display in the body or subject of the email the specific ID that is assigned to each new entry that is added. I want this to display in the email so the procurement team and reference this ID when creating the purchase order.
The closest flow I was able to get working did return the ID - however it sent one email for every row in the excel file when a new row was added or modified.
Looking for guidance