Excel Online to Create Event Date and Time

[Anonymous]

I am building a flow that when a line in Excel Online (Sharepoint) is updated, it will send a calendar invite to the people required.

I have managed to find/figure out how I get the right date across to the flow - addDays('1900-01-01T00:00:00Z',sub(int(item()?['ReminderStartDate']),2))

BUT I cant seem to get the Time to show up. I think Im missing something basic???

-Should the start/finish times be in their own columns or in the same one as the start/end date?

-How then to I apply the best expression?

Thanks

[v-bacao-msft · Accepted solution]

Hi @Anonymous ,

Could you share screenshots of Flow configuration and details of related fields in the Excel table?

Regarding time processing in an Excel table, you can refer to the following links and see if it helps:

https://powerusers.microsoft.com/t5/Building-Flows/Excel-file-to-list-flow-date-issue/m-p/279258#M28826

https://www.bythedevs.com/post/working-with-date-time-data-of-excel-in-power-automate

Please provide more details so that we could provide a proper workaround for you.

Best Regards,

[Anonymous]

[Anonymous]

[Anonymous]

Have also tried the excel format as - any ideas??