Showing results for 
Search instead for 
Did you mean: 
New Member

Dynamic Content - Null


We have a shared excel spreadsheet in a 365 group that is connected to Power Automate to send emails. It pulls data from the selected row to populate the body of the 'Send an Email (V2)'.


This was working until recently. The dynamic content now returns null for any fields in the table.

I've made a new test sheet and flow but receive the same results. It seems to see the table headers but cannot pull the value within them.

The error is for a 'null' to field in the email (should have been pulled from excel) but the dynamic content for the body of the email is also null.

Error_1.jpgError_2.jpgTest Flow_1.jpg



Hey there.  This might be a bit of a stretch, but I don't like to leave anything to assumptions:

Are we certain that the rows are part of the table?  I've seen it where users will select the headers, define that as the table, and then add rows below thinking they were part of the table, but were actually appending them after.


When you select the row, you should see "Table Design" up top along with the table name on the left side.  If the row is not part of the table, those things won't show up.




Keep us posted.



If you liked this reply, please give it a thumbs up! If this reply has answered your question or resolved your challenge, please consider marking it as a Solution. This helps other users find it more easily via search.

Thank you for your help.

I have confirmed that I am selecting a row within the table. It's interesting; you used to not even be able to run the flow outside of the table and now it lets you. It even gives the same error I am receiving.


As an aside:

I've also noticed the owner of a flow/power automate cannot run the flow from excel OWA. It just loads a blank side panel page. (confirmed with two accounts) Those who have it shared with them are able to though.

Maybe there was a recent update that broke something but I digress.

Helpful resources

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

New Ideas Forum MPA.jpg

A new place to submit your Ideas for Power Automate

Announcing a new way to share your feedback with the Power Automate Team.

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

MPA Licensing.jpg

Ask your licensing questions at the Power Automate AMA!

Join Priya Kodukula and the licensing team, super users and MVPs to find answers to your questions on Power Automate licensing.

Users online (3,426)