cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
kevinkhkim
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:

kevinkhkim_0-1624469350772.png

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?

 

5 REPLIES 5
v-LilyW-msft
Microsoft
Microsoft

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:

vLilyWmsft_0-1624506413058.png

vLilyWmsft_1-1624506413062.png

vLilyWmsft_2-1624506413065.png

This is my excel and total=C2+D2

vLilyWmsft_3-1624506413067.png

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

vLilyWmsft_4-1624506413068.jpeg

vLilyWmsft_5-1624506413069.png

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

kevinkhkim_0-1624543939229.png

To calculate timeliness based on submitted date vs deadline

kevinkhkim_1-1624543947055.png

Date and quarter/year value

kevinkhkim_2-1624543951158.png

 

 

 

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

Helpful resources

Announcements
MPA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

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.

PowerPlatform 768x460.png

Microsoft Learn

Check out our new Discover Your Career Path blog post series and get all the details.

Top Solution Authors
Users online (1,876)