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 :
Power Automate - Building Flows
Answered

Problems with extracting the results from Excel cell with a formula

(0) ShareShare
ReportReport
Posted on by 2

Hello,

I'm using a simple approvals flow and an excel table with some data that need to flow to approval details. 

 

So for example approval request looks like that:

 

Requestor: *Data from Excel column 1*

Number of days: *Data from Excel column 2*

Labor cost: *Data from Excel column 3, calculated via formula* 

 

When I test the flow, I get requestor and number of days without any problem

However there's nothing coming from a cell from column 3, where formula is. 

 

When I look in excel, I see all the numbers properly, but for some reason the calculated result is not picked up by my flow

 

What can be a problem? 

I cannot re-do the calculations in Flow, formula is quite complex with multiple Vlookups, can this maybe cause the problem?

I have the same question (0)
  • Verified answer
    v-mengmli-msft Profile Picture
    on at
    Re: Problems with extracting the results from Excel cell with a formula

    Hi @Vlad_B ,

     

    Are you use Labor cost dynamic content in approval? The flow can get value of it because you didn't pass value to it. Excel calculates the result after you insert a row.

    There is another way:

    vmengmlimsft_0-1704270203298.png

    Something just like this:

    vmengmlimsft_1-1704270287259.png

    Math functions: Reference guide for expression functions - Azure Logic Apps | Microsoft Learn

    vmengmlimsft_2-1704270329119.png

     

     

    Best regards,

    Rimmon

  • v-mengmli-msft Profile Picture
    on at
    Re: Problems with extracting the results from Excel cell with a formula

    Hi @Vlad_B ,

     

    How is the situation now?

    If my answer helps solve your problem, hope you could accept it as a solution.

    If you have associated problem, you can reply to me. If you have another problem, please post it in community and I will reply to you as soon as I see it.

     

    Good luck.

    Rimmon

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Chiara Carbone – Community Spotlight

We are honored to recognize Chiara Carbone as our Community Spotlight for November…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 560 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 347 Moderator

#3
Expiscornovus Profile Picture

Expiscornovus 262 Most Valuable Professional

Last 30 days Overall leaderboard