cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
GerardoPlass
Helper I
Helper I

¿What do I have to modify so that this Text field is saved in sharepoint as date and time?

Currently my form is like this because in sharpoint the fields where the date goes are as text

GerardoPlass_1-1657522045564.png

 

My columns in sharepoint are as text, if I change it to date and time in power apps, the date and time box appears separately

 

GerardoPlass_0-1657521986461.png

 

In conclusion I need the dates to arrive in date and time format in sharepoint, the dates are calculated by the variable NOW() TimeZoneOfffset to obtain the UTC time of the internet

 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions

I would also avoid storing Date as Text/String because when you come to use the date value, you may want to filter your searches based on date. This can be achieved easier through the value being stored as Date or DateTime. 

 

Please Accept as Solution if it solves your question. Or just give it a Thumbs Up if it is helpful as can help others.

LinkedIn: https://www.linkedin.com/in/charlie-phipps-%F0%9F%91%A8%E2%80%8D%F0%9F%92%BB-91338715b/
YouTube: https://www.youtube.com/channel/UChmFBGU1YKIU91sNMQ7buGg
Twitter: https://twitter.com/phipps0218

View solution in original post

3 REPLIES 3
phipps0218
Super User
Super User

When storing a date or date and time you should use the data and time column type from SharePoint. You will notice in the SharePoint column configuration you are able to set it as either date only or date and time. 

 

Please Accept as Solution if it solves your question. Or just give it a Thumbs Up if it is helpful as can help others.

LinkedIn: https://www.linkedin.com/in/charlie-phipps-%F0%9F%91%A8%E2%80%8D%F0%9F%92%BB-91338715b/
YouTube: https://www.youtube.com/channel/UChmFBGU1YKIU91sNMQ7buGg
Twitter: https://twitter.com/phipps0218

WarrenBelz
Super User
Super User

Hi @GerardoPlass ,

This blog of mine for storing and editing time may be useful to you. You can store as Text if you really want to, but it is overly complex for what you are trying to achieve. Also, you are far better having it in Date/Time if you want UTC - you have already noted how to do this.

 

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps

I would also avoid storing Date as Text/String because when you come to use the date value, you may want to filter your searches based on date. This can be achieved easier through the value being stored as Date or DateTime. 

 

Please Accept as Solution if it solves your question. Or just give it a Thumbs Up if it is helpful as can help others.

LinkedIn: https://www.linkedin.com/in/charlie-phipps-%F0%9F%91%A8%E2%80%8D%F0%9F%92%BB-91338715b/
YouTube: https://www.youtube.com/channel/UChmFBGU1YKIU91sNMQ7buGg
Twitter: https://twitter.com/phipps0218

Helpful resources

Announcements
October Events

Mark Your Calendars

So many events that are happening this month - don't miss out!

Ignite 2022

WHAT’S NEXT AT MICROSOFT IGNITE 2022

Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Power Apps Africa Challenge 2022

Power Apps Africa Challenge

Your chance to join an engaging competition of Power Platform enthusiasts.

Users online (3,297)