cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ankur_raj
Regular Visitor

No table was found with name '@{triggered()?['Received']}'.

I am trying to use the standard flow template for adding rows in excel upon receiving an email in outlook.com. I add an excel action insert row and provide the excel file path which is stored on oneDrive. In the table field I select dynamic content "Received Time" and the error message No table was found with name '@{triggerBody()?['DateTimeReceived']}'. is displayed. I am new to flow and not sure what is causing this issue.

 

Thanks & Regards,

Ankur

1 ACCEPTED SOLUTION

Accepted Solutions

Hi @ankur_raj,

 

Thanks for your reply. I can see where your problem is. You need to map the date recived under the excel table column. This is the steps you need to follow.

 

Step 1:

You need to create an excel sheet with columnns and table. Follow this link for how to create a table in excel.

https://support.office.com/en-gb/article/Create-or-delete-an-Excel-table-in-a-worksheet-e81aa349-b00...

 

This is my excel sheet I created. I got two columns Name & DateTime. My table is called "EmailTable".

 

e2.png

 

Step2:

You need the following flow to configure.

 

e1.png

 

 

Here you need to select the table name then define the mapped columns from the excel sheet.

 

If any questions please let me know.

 

Thanks



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blog
Power Automate Video Tutorials

View solution in original post

9 REPLIES 9
abm
Super User
Super User

Hi @ankur_raj,

 

Can you please show a screenshot of your flow and excel sheet table?

 

Thanks

 



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blog
Power Automate Video Tutorials
ankur_raj
Regular Visitor

Hi,

   I am using a blank excel sheet. Below is a screenshot of my flow.

 

Thanks for your help on this issue.

 

Thanks & Regards,

Ankur

Flow Details.PNG

Hi @ankur_raj,

 

Thanks for your reply. I can see where your problem is. You need to map the date recived under the excel table column. This is the steps you need to follow.

 

Step 1:

You need to create an excel sheet with columnns and table. Follow this link for how to create a table in excel.

https://support.office.com/en-gb/article/Create-or-delete-an-Excel-table-in-a-worksheet-e81aa349-b00...

 

This is my excel sheet I created. I got two columns Name & DateTime. My table is called "EmailTable".

 

e2.png

 

Step2:

You need the following flow to configure.

 

e1.png

 

 

Here you need to select the table name then define the mapped columns from the excel sheet.

 

If any questions please let me know.

 

Thanks



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blog
Power Automate Video Tutorials
ankur_raj
Regular Visitor

Thank You abm for your help. With your help I was able to configure the scenario which is recording the date and time of emails received from specific user with specific subject line. I have one more question, the date and time is getting updated in UTC time zone and not my profile time zone (EST). Is there a way I can have excel updated in my time zone and store date and time in 2 seperate columns instead of one.

 

Thanks & Regards,

Ankur

Hi @ankur_raj,

 

Thanks for your reply. Currently Flow won't support advanced functions such as DateTime or Calculations etc. I would do this in the excel sheet. Create extra columns and use some formulas to update the columns.

 

Thanks



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blog
Power Automate Video Tutorials
ankur_raj
Regular Visitor

I tried putting a formulae to do the conversion but unfortunately flow also doesn't support an excel file with formula. I had added the formulae in an additional column. My thought was to create a file with some charts and share it with other people. Is there a way to store this data in access or something which is easier? I also see under "runs this month" as 7 of 750, are there any restrctions on how many time I can run a flow, what is the way to get around it, I am using office 365 for business pro plus.

 

"message": "Excel files containing formula are currently not supported. Please use a file that has no formula.",

 

Thanks & Regards,

Ankur

Hi @ankur_raj,

 

Yes I tried the excel file with formula and got the same error as you. Why can't you load the data in SQL express? You can create a gateway connection locally from flow settings button ( top right hand side menu).

 

a1.png

Regarding the runs per month all depends on your price plan. Click Learn > Pricing menu to see your price plan.

 

a2.png



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blog
Power Automate Video Tutorials
ankur_raj
Regular Visitor

Thank You abm for your suggestion. I am new to Flow so I didn't know that this option existed. Will try to learn more about sql express, may be that will solve the issue for me.

 

Thanks & Regards,

Ankur

Excellent. Any questions please let me know.

 

Thanks



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blog
Power Automate Video Tutorials

Helpful resources

Announcements
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.

365 EduCon 768x460.png

Microsoft 365 EduCon

Join us for two optional days of workshops and a 3-day conference, you can choose from over 130 sessions in multiple tracks and 25 workshops.

Users online (3,094)