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:
Check out the new Process Advisor community forum board!
Check out new user group experience and if you are a leader please create your group
Participate in the Power Virtual Agents Community Challenge
Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.
Dont miss our very own April Dunnam’s The Developer Guide to the Galaxy! Find out what the Power Platform has to offer for the traditional developer.