cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Excel Online to Create Event Date and Time

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

 

1 ACCEPTED SOLUTION

Accepted Solutions
v-bacao-msft
Community Support
Community Support

 

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,

Community Support Team _ Barry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

4 REPLIES 4
v-bacao-msft
Community Support
Community Support

 

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,

Community Support Team _ Barry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous
Not applicable

Screen Shot 2020-01-28 at 12.48.10 pm.png

Anonymous
Not applicable

Screen Shot 2020-01-28 at 12.51.50 pm.png

Anonymous
Not applicable

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

 

Screen Shot 2020-02-06 at 4.16.33 pm.png

Helpful resources

Announcements
MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

New Process Advisor Capabilities carousel.png

Read the blog for the latest news

Read the latest about new experiences and capabilities in the Power Automate product blog.

PA Survey Carousel Image.png

We want to hear from you!

If you are a small business ISV/Reseller, share your thoughts with our research team.

Users online (3,715)