Power App ISO 8601 Error

Question

Power App ISO 8601 Error

Anonymous

Hi All!

I am a brand new user of the Microsoft Power platform, but have semi-successfully completed my goal, with the exception of these errors I was receiving:

JSON parsing error, expected 'string' but got 'object'. Expected value '2024-01-19' to be a valid RFC 3339 'date-time' format. Allowed ISO 8601 format(s): 'YYYY-MM-DDThh:mm:ssZ', 'YYYY-MM-DDThh:mm:ss±hh:mm', 'YYYY-MM-DDThh:mm:ss'.

I have a Canvas Power App (form) that is populated from a SharePoint list. And, I am using power automate to send me an email when a date in one column matches the date in a different column. The Power Automate side of things is working smoothly, but now I am getting the errors and the date in the Power App form does not match the date in the SharePoint List.

Any and all help is appreciated!

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

3 answers

Answer 1

Dear Jenna,

Thanks for your updates and kindness.

We may need some further information for confirmation.

From the screenshots, the date control seems to be set correctly.

As you mentioned that the flow is ran successfully previously, may I know what is the trigger of the flow? Do you add the PowerApps connector in the flow?

Regarding "I am not certain if I run the flow from a button. Typically, I hit the edit icon in the app, make changes, then save.", do you add a Save button to submit the edited data to the site list in the edit form? If yes, does the error message occurs after you click on the Save button? If yes, what formula do you use in OnSelect on the button?

If you add a new item in the new form, do you encounter some issues?

Based on the error message, it may also occurs when importing the data from Excel in PowerApps. Could you confirm whether you get the data from an Excel table?

Your effort and time are greatly appreciated!

Sincerely

Cliff | Microsoft Community Moderator

Answer 2

Dear Jenna,

We are glad to help you and we may need further information for confirmation.

Do you run the flow from a button in the PowerApps form?

Do you encounter the error message when you use the Patch formula to add the new entry to the SharePoint Online list from PowerApps?

If yes, could you provide the formula you are using and upload some screenshots showing the control type for the Date column you are using in the form for our reference?

Note: Remove any private information before uploading the screenshots.

If you click on Integrate>PowerApps>Customize forms, you should see the control type of the date column like the following in PowerApps.

Welcome to share any updates when you have time.

Thank you for your time and effort.

Sincerely

Cliff | Microsoft Community Moderator

Answer 3

Hi Cliff,

Thanks so much for your quick reply.

I am not certain if I run the flow from a button. Typically, I hit the edit icon in the app, make changes, then save.

Here is the code for the Date field:

DateValue1: Control: Classic/DatePicker Properties:

DefaultDate: =Parent.Default 

EndYear: =Year(Today())+100 

StartYear: =1899 

Tooltip: =Parent.DisplayName 

BorderColor: =If(IsBlank(Parent.Error), Parent.BorderColor, Color.Red) 

DisplayMode: =Parent.DisplayMode 

Height: =36 

IsEditable: =true 

PaddingBottom: =0 

PaddingLeft: =If(Self.DisplayMode = DisplayMode.Edit, 5, 0) 

Width: =131 

X: =177 

Y: =10

Please see screenshots as well. Let me know if there is any other info you need.

![Image](https://learn-attachment.microsoft.com/api/attachments/12688757-188f-454a-a4b5-12e29d5290b4?platform=QnA"https://learn-attachment.microsoft.com/api/attachments/dcedf376-115c-4f7d-9f6f-5253042fbaa6?platform=QnA" title="filestore.community.support.microsoft.com" rel="ugc nofollow"> ![](https://learn-attachment.microsoft.com/api/attachments/67080db5-13a1-4da5-b8aa-ff57d90658dc?platform=QnA

Share via

Power App ISO 8601 Error

3 answers