Skip to main content

Notifications

Power Automate - Building Flows
Unanswered

Retrieve ID of new row in Excel

(0) ShareShare
ReportReport
Posted on by
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
 
 
  • Suggested answer
    Mark Nanneman Profile Picture
    Mark Nanneman 976 on at
    Retrieve ID of new row in Excel
    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  
  • narayan225 Profile Picture
    narayan225 2,390 on at
    Retrieve ID of new row in Excel
    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:
    1. Trigger a flow on form submit.
    2. Add an action to create the ID variable in Power Automate.
    3. Add an action to add a new row in excel file with the ID variable and the response from the form submission.
    4. 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!

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,422

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,711

Leaderboard