Showing results for 
Search instead for 
Did you mean: 
Helper I
Helper I

HELP!! Dynamic Content from Excel cell with formula

When using Send an Email, it doesn't seem like Power Automate is reading excel cells that have formulas in them because it is outputting as Nulls. 

I have the steps as following:


Once feedback is submitted through Forms, Excel is updated with additional columns that are indexed with formula. This is where the problem happens because, in Excel, data is there, but in Power Automate, Send an Email is not reading the cells with formulas, so when I add the Dynamic Contents from Excel with formulated columns, they end up as Nulls.


Any thoughts on how I can fix this?



Hi @kevinkhkim 

Sorry, I posted the wrong case😂, I will study your question and tell you the result later.

Best Regards

Hello, thank you for your response, but I am not looking for date conversion. I am hoping to find a solution where Send an Email can read cells with formulas.

Hi @kevinkhkim 

Could you share me the content of your formula, and tell me what's the format of the cell?

I created a simple Flow, and it can get the value of Excel cell with formula.

Flow in details:




This is my excel and total=C2+D2


When an form is submitted and will receive the email as below:



Hope the content above may help you.

Best Regards

Many of them are Index Match formulas, IF formulas, and simply indexing from another cell as below:

To retrieve email addresses and geography names


To calculate timeliness based on submitted date vs deadline


Date and quarter/year value





Were you able to review my response above? Is your result consistent with reading formulated cells?

Helpful resources

Process Advisor

Introducing Process Advisor

Check out the new Process Advisor community forum board!

MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

V3_PVA CAmpaign Carousel.png

Community Challenge - Giveaways!

Participate in the Power Virtual Agents Community Challenge

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Users online (3,353)