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

[Anonymous]

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

[abm]

Hi @Anonymous,

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

Thanks

[Anonymous]

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

[abm · Accepted solution]

Hi @Anonymous,

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-b006-4f8a-9806-5af9df0ac664?ui=en-US&rs=en-GB&ad=GB

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

Step2:

You need the following flow to configure.

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

[Anonymous]

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

[abm]

Hi @Anonymous,

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

[Anonymous]

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

[abm]

Hi @Anonymous,

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

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

[Anonymous]

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

[abm]

Excellent. Any questions please let me know.

Thanks