Retrieve ID of new row in Excel

(0) Share

Report

Posted on by CF-13012059-0

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

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (0)

Sort by

narayan225 2,547 Moderator on at

Like (0)

Report
Copy link

Link copied!
I am not sure what you are doing with the flow as I cannot see you updating a row in your excel file with the form submission.

But, you can achieve what you are after with following steps:

Trigger a flow on form submit.

Add an action to create the ID variable in Power Automate.

Add an action to add a new row in excel file with the ID variable and the response from the form submission.

Add one more action that references the responses and ID variable in the email.

This way, you both create an entry for each response with a customised ID as well as send an email to the user with ID and other content using a single flow.

Hope this helps.

Cheers!

Was this reply helpful? Yes No
Suggested answer

Mark Nanneman 993 Moderator on at

Like (0)

Report
Copy link

Link copied!

This flow will send an email for each file attachment in the "For each" loop it's inside the way it's written.

If you want to send only one email per form submission with all the attachments in it, you need to create an array variable, and save each file attachment to that array variable, then put the array variable in the email.

It would look something like the following (you would just have to make sure you're giving the attachment a proper name with the correct file extension):

Put the array in the "Attachments" of the email.

If this helped you, please click "Does this answer your question" and give it a like to help others in the community (+ close the ticket)!

Power Platform Developer | LinkedIn: Mark Nanneman | Blog: Power Stuff | YouTube: Mark's Power Stuff

Was this reply helpful? Yes No