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?
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.
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.
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
Check out the News & Announcements to learn more.
Participate in the Power Virtual Agents Community Challenge
Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.
Check out our new Discover Your Career Path blog post series and get all the details.