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

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Problems with extracti...
Power Automate
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?

Capture.JPG
Categories:
I have the same question (0)
  • Verified answer
    v-mengmli-msft Profile Picture
    Microsoft Employee on at

    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
    Microsoft Employee on at

    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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the March Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Haque Profile Picture

Haque 592

#2
Valantis Profile Picture

Valantis 340

#3
11manish Profile Picture

11manish 284

Last 30 days Overall leaderboard