cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
obj082
Frequent Visitor

Date issue with Adaptive card and SharePoint list

Hello all,

 

My issue is with a date.input and a time.input from an adaptive card that I want to use to update a Sharepoint list. The issue is that the time when updated into the SharePoint list is different than what is originally selected. 


I have tried converting the time but that ends up making the problem worse. 

1 ACCEPTED SOLUTION

Accepted Solutions

Hi @obj082 ,

 

Please convert the time to UTC0 and then patch it to the SP list:

 

vbofengmsft_0-1663723699854.png

 

Best Regards,

Bof

View solution in original post

3 REPLIES 3
v-bofeng-msft
Community Support
Community Support

Hi @obj082 ,

 

Could you please show me your flow?

Could you please show me the time zone settings of your SP site?

vbofengmsft_0-1663641092449.png

 

In addition , you could convert the time before you update the date:

vbofengmsft_1-1663641470077.png

 

Best Regards,

Bof

Sharepoint site setting is correct 

obj082_1-1663689875795.png

Below is the part of the flow concerning the date I am trying to update the list with. 

 

obj082_0-1663689843960.png

Output from the final step which is used to update the list.

obj082_4-1663691432936.png

Output from the SharePoint list.

obj082_3-1663691363000.png

 

What shows in the SharePoint list 

obj082_5-1663691519009.png

 

Thanks for the help!

Hi @obj082 ,

 

Please convert the time to UTC0 and then patch it to the SP list:

 

vbofengmsft_0-1663723699854.png

 

Best Regards,

Bof

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Users online (4,753)