cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
SANJURK
Helper II
Helper II

Date List Failed Server Response expected a string

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.

 

 

 

Screenshot_20210131-132528.jpg

2 REPLIES 2
WarrenBelz
Super User III
Super User III

Hi @SANJURK ,

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.

 

SANJURK
Helper II
Helper II

Thanks Warren - I will look into the video.

Helpful resources

Announcements
User Groups Public Preview

Join us for our User Group Public Preview!

Power Apps User Groups are coming! Make sure you’re among the first to know when user groups go live for public preview.

Power Apps Community Call

Monthly Power Apps Community Call

Did you miss the call?? Check out the Power Apps Community Call here!

Power Platform ISV STudio

Power Platform ISV Studio

ISV Studio is the go-to Power Platform destination for ISV’s to monitor & manage applications post-AppSource publish.

Top Solution Authors
Top Kudoed Authors
Users online (64,309)