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 Platform Community / Forums / Power Automate / Problems with extracti...
Power Automate
Unanswered

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?

Categories:
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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 462 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 456 Moderator

#3
abm abm Profile Picture

abm abm 243 Most Valuable Professional

Last 30 days Overall leaderboard