web

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

News and Announcements icon

Power Platform CommunityForums Power Apps Date format from Text ...

Power Apps

Answered

Date format from Text to Datetime

(0) Share

Report

Report

Posted on by pankaj2125

24

Hi All,

I have Gallery to filter rows by datepicker filter, but my date column type is "Single line of text" on SharePoint List.

I want to change it from text to datetime format in PowerApps directly to filter accordingly.

Please share your ideas to do it. Thanks

Categories:

Building Power Apps

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

Verified answer

Nogueira1306 7,390 Super User 2024 Season 1 on at

Like
a
(2)

Report
Copy link

Link copied!

Use the DateTimeValue function.

here

https://docs.microsoft.com/en-US/powerapps/maker/canvas-apps/functions/function-datevalue-timevalue

If you need additional help please tag me in your reply and please like my reply.
If my reply provided you with a solution, pleased mark it as a solution ✔️!

Best regards,
Gonçalo Nogueira

Check my LinkedIn!

Check my User Group (pt-PT)!

Last Post on Community

My website!
WarrenBelz 156,774 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @pankaj2125 ,

You need to change the Date Picker output to Text in whatever format your List column is in - for instance

Filter( SPListName, YourDateColumn = Text(DatePickerName.SelectedDate,"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.

Visit my blog Practical Power Apps

Join the conversation