How to collect date and time from MS Form and update in Date and time field in Sharepoint list

(0) Share

Report

Posted on by PowerUser19

215

Hi there,

I am trying to collect the data of visitors in MS Form and updating the Sharepoint list. As a part of the requirement, I need to collect the date along with the time. As MS Form do not support date and time collection, I have a drop down to choose the time from.

I have a Date and Time field in Sharepoint list. How do I extract the substring of the time in Power automate and update the same in the Time portion of the Date and Time field in Sharepoint? Any help is highly appreciated.

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (1)

v-zhoqian-msft Microsoft Employee on at

Like (1)

Report

Hi @PowerUser19 ,

You could try the following method:

Because the time string in the flow will be considered as UTC by default, it may be need to convert time zone.

Best Regards,
Habsburg Qian
If this post helps, then please consider Accept it as the solution to help the other members find it.

Was this reply helpful? Yes No
PowerUser19 215 on at

Like (0)

Report

Hi @v-zhoqian-msft ,

Thank you so much for your response. I tried the above. Still quite didn't get the right number updated in Sharepoint. May I please know what I am missing here?

Was this reply helpful? Yes No
PowerUser19 215 on at

Like (0)

Report

@v-zhoqian-msft below is the set up I already have in Power Automate setting (I live in this zone). Not sure if the "source time zone " field in the flow needs to be changed.
Below is the Regional Setting in SharePoint

Was this reply helpful? Yes No
Verified answer

PowerUser19 215 on at

Like (0)

Report

Because of the default set up I had in SharePoint, I did use the Source TimeZone as AEST and destination as UTC which resolved the issue. Thanks @v-zhoqian-msft

Was this reply helpful? Yes No