web

You’re offline. This is a read only version of the page.

Power Platform CommunityForums Power Automate - Building Flows Reading formula cell f...

Power Automate - Building Flows

Answered

Reading formula cell from excel to display in email

(0) Share

Report

Report

Posted on by JohnoMDX

Hi all,

I am new to building flows and am trying to embed the output of a sum formula into a 'send email' step in my process.

The trouble i am having is that when the email is sent, the sum output value shown in the image below as 'Total Risk Score' is blank. I assume its because the flow cannot read the information in the cell to give the final value, but i don't know how to get it to read the cell by using the appropriate expression. Any help would be greatly appreciated.

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

ChristianAbata 8,949 Most Valuable Professional on at

Like (0)

Report

Re: Reading formula cell from excel to display in email

hi @JohnoMDX you can try by adding a compose value before your condition and inside add the output of get row your total risk score propertie, just to see if you are getting well the values, if is empty you are not geting the values and you need to try with get values, and use a condition to filter the value that you are looking for. If the compose shows the value just use the output compose to add it into the email.

Was this reply helpful? Yes No

Join the conversation

Helpful resources

News and Announcements

Welcome to the Power Platform Communities

Quick Links

Leaderboard > Power Automate

#1

Michael E. Gernaey 788 Super User 2025 Season 2

#2

Tomac 452 Moderator

#3

developerAJ 302

Last 30 days Overall leaderboard

Featured topics

Share your ideas and struggles with building Power Automate flows!

Start and wait for an approval action

Product updates

Microsoft Power Platform Community release plans