cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ankur_raj
Level: Powered On

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
Super User
Super User

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

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!



View solution in original post

9 REPLIES 9
Super User
Super User

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

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!



ankur_raj
Level: Powered On

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

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

Super User
Super User

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

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!



View solution in original post

ankur_raj
Level: Powered On

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

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

Super User
Super User

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

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!



ankur_raj
Level: Powered On

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

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

Super User
Super User

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

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!



ankur_raj
Level: Powered On

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

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

Super User
Super User

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

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!



Helpful resources

Announcements
firstImage

Power Platform Online Conference

Speakers, submit your sessions now! Call for speakers ends Feb. 10!

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

firstImage

Incoming: New and improved badges!

We've given our badges an overhaul and also added some brand new ones!

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Power Automate Community Video Gallery!

Top Kudoed Authors (Last 30 Days)
Users online (2,682)