Hello,
I have an app that converts Local Time from two dropdowns (Hours and Mins) to UTC Time in ISO8601 format.
This is supposed to be written to a Sharepoint list in this format but Sharepoint is changing the format.
Specifics:
Text( DateTimeValue( Concatenate( Text(dt_eventDate.SelectedDate), " ", Text(dd_startDateHour.Selected.Value), ":", Text(dd_startDateMin.Selected.Value) ) ), DateTimeFormat.UTC )
How do I get Sharepoint to honor the text and not try to convert it!
Thank you
Solved! Go to Solution.
Hi @ericonline ,
Could you please share a bit more about your issue?
Do you mean that the UTC time text value could not been saved into your SP list text column as expected format?
Based on the issue that you mentioned, I have made a test, and the issue is confirmed on my side. When you pass the UTC time text value into your SP list, the text time value would be recognized as a date time value rather than text string value.
Currently, if you want to use a Single text type column to store the UTC time text value passed from your app into your SP list, I afraid that there is no way to achieve your needs.
If you would like this feature to be added in PowerApps, please consider submit an idea to PowerApps Ideas Forum:
https://powerusers.microsoft.com/t5/PowerApps-Ideas/idb-p/PowerAppsIdeas
Best regards,
Hi @ericonline ,
Could you please share a bit more about your issue?
Do you mean that the UTC time text value could not been saved into your SP list text column as expected format?
Based on the issue that you mentioned, I have made a test, and the issue is confirmed on my side. When you pass the UTC time text value into your SP list, the text time value would be recognized as a date time value rather than text string value.
Currently, if you want to use a Single text type column to store the UTC time text value passed from your app into your SP list, I afraid that there is no way to achieve your needs.
If you would like this feature to be added in PowerApps, please consider submit an idea to PowerApps Ideas Forum:
https://powerusers.microsoft.com/t5/PowerApps-Ideas/idb-p/PowerAppsIdeas
Best regards,
Hi @v-xida-msft ,
Thank you for responding. Rather than submit this as an "idea", I'd prefer to report it as a "bug".
- Sharepoint is not honoring datatype = string
Do you have a path for reporting this to the Sharepoint team?
User | Count |
---|---|
197 | |
124 | |
85 | |
50 | |
42 |
User | Count |
---|---|
284 | |
160 | |
134 | |
73 | |
73 |