web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id : opX7fsL1zc5gSpvMljLuix
Power Automate - Using Connectors
Answered

Email link with the Excel data that contains formula

Like (0) ShareShare
ReportReport
Posted on 2 Jan 2020 06:38:38 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
    10 on 02 Jan 2020 at 10:01:46
    Re: Email link with the Excel data that contains formula

    Hi again Gareth,

     

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

  • v-alzhan-msft Profile Picture
    on 02 Jan 2020 at 10:01:16
    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
    306 on 02 Jan 2020 at 09:20:43
    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
    10 on 02 Jan 2020 at 08:38:20
    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
    306 on 02 Jan 2020 at 07:15:04
    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

Announcing our 2025 Season 2 Super Users!

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

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 497 Super User 2025 Season 2

#2
David_MA Profile Picture

David_MA 436 Super User 2025 Season 2

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 244 Super User 2025 Season 2

Featured topics

Loading complete