web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Date List Failed Serve...

Power Apps

Unanswered

Date List Failed Server Response expected a string

(0) Share

Report

Report

Posted on by Community Power Pla... Microsoft Employee

Hi,

I have just finished creating an app, and now is facing only an issue while users are submitting the details.

I have an excel sheet in One Drive Business Folder, and the app when entered with details by other users receive an error, which I feel is something related to the date. I too tried it and is facing the same issue.

I tried to change the format of the particular cell in the excel sheet - and changed its format to Date - English UK - Is it because of this, I am not able to figure it out.

Categories:

Building Power Apps

All responses Img

All responses (2)

Answers Img

Answers (0)

Sort by

WarrenBelz 156,576 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Anonymous ,

You did not include your code, but the Update of the Data Card would need to be

Text(YourDatePickerName.SelectedDate,"dd/mm/yyyy")

Excel and dates are problematic at the best of times - you might take a moment to watch this video from Shane Young.

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.
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks Warren - I will look into the video.

Join the conversation