Answered

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

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

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:

I created the flow:

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

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

Do you have any idea about how to fix it?

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

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

Categories:

General topics

I have the same question (0)

All responses (3)

Answers (2)

Verified answer

Paulie78 8,422 Moderator on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Verified answer

sumurthy Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

@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

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No