dear community members, i am very much to FLOW and encountered my 1st flow creation. Please help me on this or FW/share me the link if it has been discussed here this forum already.
I have a sharepoint site where i have an excel file. In the excel file i have a table with multiple rows and columns. This is some kind of meetimg action register. I captured actions and record it with action owner name and email address. Now i want to create a flow- which send email address to the owners with their specific row data. I tried to create a flow but getting error in 'delay-until' actions ----
InvalidTemplate. Unable to process template language expressions in action 'Delay_until' inputs at line '1' and column '2533': 'String was not recognized as a valid DateTime.'.
Hi @roniedhaka ,
Could you share a screenshot of your flow?
It seems that you are using action Delay until, what’s the value you’ve inputted in the Timestamp field?
According to your description, do you want to send an email with specific details from the Excel table to the owners after certain time?
Please check the following flow for a reference.
After the trigger add action list rows present in a table.
Add Delay until action with the following code:
Add action Send an email, select dynamic content “email” from action List rows present in a table, an Apply to each will be added automatically. Then select corresponding details for the body field.
An image for your reference:
hi, thanks for reply. I am trying to explain the issues to you below, please excuse me for lack of knowledge as i am totoally newbie on Flow, i got below steps via searching google. 🙂
i have the excel table- with column header : date, action owner name, email, due date, action details, comments
i want a flow which sent email to the 'action owner name' based on email next to its cell.
I want to sent the email the day i updated in 'date' column- if April 4th 2019, then email will send [upon click button] immideitly.
in my 'get a row' steps- i am facing timestamp error. The 'date' column is a excel date format i use.
one important thing- i was checking your flow example, the 'apply to all' i never got to see! How did you get it?
here is my screnshot-
Hi @roniedhaka ,
Thanks for sharing the detailed info.
It is a known issue for Excel online connector that date will be returned as an Integer but not in date format. So the error message Invalid template returned.
A workaround for your scenario. Before starting the flow, please format the Date column as Text, then input the date.
Then in the flow, set the Timestamp field of action Delay until with the following code:
It will than works as expected.
By the way, in my scenario, the action List rows present in a table is being used, which will get all the rows from the list, so an Apply to each will be added automatically if parameters are referred to this action.
Hi mabel- thanks for your reply.
i am getting still error.
Now i am sharing full screenshot of my excel online table [plz ignore informations, i am big fan of MCU!]
if you see the column date [K] i formatted as text and then update all cell manually like 2019-04-10. same for column L
Now, below is the error screenshot. I am not code expert, i just copy paste your code into 'delay until' flow actions. But what does this error means now?
the idea is -this flow supposed to trigger on what date i put in column K1, K2 K3....and send email (G1) with full row1 data.
Hi @roniedhaka ,
Please show me the detailed code that is being used in the Delay action.
By the way, you exact column name is “Date” but not “date”, please try to format the function and try again:
We've updated and improved the layout and uploading format of the Power Automate Cookbook!
Fill out a quick form to claim your user group badge now!
We've given our badges an overhaul and also added some brand new ones!
Learn how to build the business apps that you need.
Find out where you can attend!
Watch & learn from the Power Automate Community Video Gallery!