web

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

News and Announcements icon

Power Platform CommunityForums Power Apps datepicker to text col...

Power Apps

Answered

datepicker to text column in sharepoint

(0) Share

Report

Report

Posted on by dennisb88

603

Hi All,

I've a question about the datepicker option.

In my app I've two datepickers, and I want to patch them (and some other fields) to a SharePoint list.

The SharePoint list columns are all text columns.

I want to patch the selected date as text to my SharePoint column, for this I use the code below:

Patch(SharePointListName,Defaults(SharePointListName),{textcolumn:datepicker1.SelectedDate})

But I got an error when I patch this that says:

Object must implement IConvertible

Anyone know what I need to do?

Thanks in advance.

Categories:

Building Power Apps

All responses Img

All responses (3)

Answers Img

Answers (1)

Sort by

WarrenBelz 156,566 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @dennisb88 ,

I don't know your date format, but adjust this to suit

Patch( SharePointListName, Defaults(SharePointListName), { textcolumn: Text(datepicker1.SelectedDate,"[$-en]dd/mm/yyyy") } )

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.
dennisb88 603 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @WarrenBelz ,

Thank you for your reply.
The date time format is correct for me.

I just give it a try, but I get the same issue. It still give me the "Object must implement IConvertible" issue when I tried to add it.
Verified answer

WarrenBelz 156,566 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

@dennisb88 ,

I assume you picked up the missing bracket (now fixed).

This has to work if you are writing to a text field. Save and exit the app and come back in again.

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.

Join the conversation