You’re offline. This is a read only version of the page.
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
@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
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.
Share
Report
All responses (
Answers (
8,407
