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

Manually trigger a flow + List rows present in a table + Create Event (V4)

Hi everyone,

I tried to come up with a solution to automate the process of sending out Outlook invite from an excel shift table; the idea behind it is to have the timetable in an excel spreadsheet and, through Power Automate, send the invite for the right person (whose email is indicated in one column) with the indicated time and date;

here's below the screenshot of the table:

alessandro1_0-1606386640337.png

I created the flow:

alessandro1_1-1606386744106.png

alessandro1_2-1606386831612.png

 

However, when I run the flow it gives me error:

alessandro1_3-1606386942811.png

 

When I look at the Input of the flow it seems it does not recognise the Time as time format:

alessandro1_4-1606387058287.png

 

Do you have any idea about how to fix it?

I changed the time format in excel but the problem persists:

alessandro1_5-1606387147228.png

 

If you have also other suggestions to give me are really welcome 🙂

@Jcook, @sumurthy@Paulie78  do you have any idea?

 

Thanks very much and have a great end of the week 

 

Alessandro

2 ACCEPTED SOLUTIONS

Accepted Solutions
Super User III
Super User III

It depends how complex you want to get. You can do a fancy pants formula to convert your Excel values to a Power Automate date, which is probably the right thing to do.

Or you could just change the formatting of your dates and times in Excel to be "text" and then run it again and it will probably work with your current flow setup.

View solution in original post

Microsoft
Microsoft

@Paulie78's suggestion should work. If not, please let me know and I can help with the solution using Office Scripts. 

One thing to be careful about is the TimeZone. You'll want to make sure the timezone you intend to use in the Spreadsheet is what's being used. The flow will use the server time zone, which may be different from yours. In the past, I had to explicitly include the timezone for conversion or store the time in the intended format (ISO 8601 format) so that there's no confusion. There may be an easier way to handle this -- but do pay attention to it. 

 

Thanks

View solution in original post

3 REPLIES 3
Super User III
Super User III

It depends how complex you want to get. You can do a fancy pants formula to convert your Excel values to a Power Automate date, which is probably the right thing to do.

Or you could just change the formatting of your dates and times in Excel to be "text" and then run it again and it will probably work with your current flow setup.

View solution in original post

Microsoft
Microsoft

@Paulie78's suggestion should work. If not, please let me know and I can help with the solution using Office Scripts. 

One thing to be careful about is the TimeZone. You'll want to make sure the timezone you intend to use in the Spreadsheet is what's being used. The flow will use the server time zone, which may be different from yours. In the past, I had to explicitly include the timezone for conversion or store the time in the intended format (ISO 8601 format) so that there's no confusion. There may be an easier way to handle this -- but do pay attention to it. 

 

Thanks

View solution in original post

Frequent Visitor

Thanks very much @Paulie78 and @sumurthy , very useful suggestions! for the moment I just converted the tables into "text" but later on I plan to try learning excel scripts language and I'll keep in mind the time zone problem which actually could cause some issues.

Thanks again and have a great day

Helpful resources

Announcements
PP Bootcamp Carousel

Global Power Platform Bootcamp

Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.

secondImage

Power Platform Community Conference On Demand

Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!

MPA Community Blog

Power Automate Community Blog

Check out the community blog page where you can find valuable learning material from community and product team members!

Users online (10,026)