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
Solved! Go to 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://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,
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://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,
Have also tried the excel format as - any ideas??
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
Read the latest about new experiences and capabilities in the Power Automate product blog.
User | Count |
---|---|
25 | |
25 | |
25 | |
22 | |
15 |
User | Count |
---|---|
50 | |
38 | |
36 | |
31 | |
30 |