Skip to main content

Notifications

Power Automate - Using Connectors
Answered

Email link with the Excel data that contains formula

(0) ShareShare
ReportReport
Posted on by 10

Hi,

 

I am Younggu from Korea.  I have been using “Power Automate” since February last year and it upgraded my workflow, but I had one problem I couldn’t solve. 

 

My question is “Is it possible to use the excel data, calculated with formulas, at the Power Automate?” 

 

I designed a flow like below.

 

Get a response via Microsoft Form -> Add a row into a table of Excel -> Send an email via outlook with the calculated data of the Excel sheet.

 

I want to use the formula, (vlookup), but when I embed the dynamic contents into the email template, then it becomes blank. 

 

 
  • Younggu Profile Picture
    Younggu 10 on at
    Re: Email link with the Excel data that contains formula

    Hi again Gareth,

     

    Please receive my bow.  It's working well now.  

  • Re: Email link with the Excel data that contains formula

    Hi @Younggu ,

     

    For the multiple emails, you maybe add a dynamic content from the Get response details action.

    You should add a expression as below in the To field:

    outputs('Compose')?['Price']

    and refer to screenshot shot below to create the flow:

    1.png

     

     

    Best regards,

    Alice       

     

    Community Support Team _ Alice Zhang
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • Verified answer
    Gareth1 Profile Picture
    Gareth1 306 on at
    Re: Email link with the Excel data that contains formula

    In order to use the Get a Row action you would need to have a unique value in one of the columns for each row.

     

    I tried using the submitted date however Excel may change the format of the date depending on the settings for excel. I was able to get around this by creating a key value for the row when adding a new row, then when I used the Get a row action I was able to pass this in and get the correct row

     

    When creating the key I add a string to the formatted date to prevent issues with leading zeros

     

    This should only return one result so you shouldn't need to perform the compose action with Last

     

    Screen Shot 2020-01-02 at 5.15.09 pm.png

  • Younggu Profile Picture
    Younggu 10 on at
    Re: Email link with the Excel data that contains formula

    Hi Gareth,

     

    Thank you for your help.

     

    I followed your example, but the Flow sent me multiple emails as I use the vlookuped data as an email address.  

     

    Thus, I changed the Flow according to your second advice, but it seems I do not know how to set the 'Get a row' properly.

     

    Could you kindly advise me, please? 

     

    Q_1.pngQ_2.pngQ_3.pngQ_4.pngQ_5.png

  • Gareth1 Profile Picture
    Gareth1 306 on at
    Re: Email link with the Excel data that contains formula

    Hi @Younggu 

    You should be able to retrieve the value from the formula results

    If you have a table and the column is set to automatically calculated in Excel when you add a new row tot he table it will copy the vlookup down to the new row

     

    Once the row has been added you can then use the List Rows present in a table to return the rows and then using a compose action to return the last row in the table. This will return the entire row including the results of the vlookup

     

    In the example below I have the Salesperson ID column set as a VLOOKUP and once the new row is added I can retrieve the results

     

     Screen Shot 2020-01-02 at 3.08.04 pm.png

     

    Also if there was a unique value in each row, you could use the Get a Row action instead of having to list all the rows and finding the last one

     

    Are you able to share a screenshot of how you are trying to do it

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,475

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,767

Leaderboard

Featured topics