PowerApps Text - Sharepoint Time Issue

[ericonline]

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:

• PowerApp:
  • Form Control
    • DataCard: 
    • 
    • TextBox: "DataCardValue5"

    • Text(
          DateTimeValue(
                  Concatenate(
                      Text(dt_eventDate.SelectedDate),
                      " ",
                      Text(dd_startDateHour.Selected.Value),
                      ":",
                      Text(dd_startDateMin.Selected.Value)
                  )
        
          ), DateTimeFormat.UTC
      )

    • DataCard Update Property: "DataCardValue5.Text"

• Sharepoint List:
  • Column Name and Data Type:
  • 
  • Sharepoint column format (PROBLEM):
  • 

How do I get Sharepoint to honor the text and not try to convert it!
Thank you

[v-xida-msft · Accepted 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,

[ericonline]

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?