How to Convert Text to Date in Power Apps? [3 Useful Examples]

I am currently building a business application that requires me to convert a text to a date in Power Apps. The app will have a text field. When a user enters any text [20240710] into the text box, the specific text will convert to a date format [10/07/2024].

In this tutorial, I will explain how to convert text to date in Power Apps with various examples like:

• Convert text to date in Power Apps and display the result using a Label
• Convert Text to Date in Power Apps and display the result using a Date picker
• Power Apps convert Text to Date using the SharePoint text field

Convert Text to Date in Power Apps

Power Apps provides one of the best functions named DateValue(), which helps to convert a date string to a date/time value.

So let’s start one by one example:

Example – 1: Convert Text to Date in Power Apps Label

In Power Apps, there is a Text input control [Provide a Date] and a Label control [Result].

When a user enters a date as a text [let’s say 20251108], it will convert to a ShortDate format, and the result will be displayed in the label control [08/11/2025].

Follow the steps below to achieve it:

• On the Power Apps screen, insert a Text input control as shown below:

• Add a Text label control below the text input and set its Text property to:

Text(
    DateValue(txt_DateValue.Text),
    "dd/mm/yyyy"
)

Where,

1. txt_DateValue = Text input control name
2. dd/mm/yyyy = Provide the date format that you want

Following the above steps, you can easily convert the text to date in Power Apps with date formats.

Example – 2: Convert Text to Date in a Power Apps Date Picker

Let’s see how to convert text to date in Power Apps and display the output in a date picker control.

Assume that, on your Power Apps screen, you have a Text-input control and a Date-picker control; when you provide a date in a text format, the date-picker should select a date based on it, as shown below:

Let’s follow the below steps to achieve this:

• On the Power Apps screen, insert a Text-input control as shown below:

• Insert a Date-picker control and set its DefaultDate property as:

DateValue(txt_Date.Text)

Where,

1. txt_Date = Text input control name

Note:

If we provide date format in “yyyy/mm/dd“, by default, the date-picker will select a date in this format “mm/dd/yyyy“.

This is another way to convert text to date in Power Apps.

Example – 3: Power Apps Convert Text to Date Using SharePoint Text Column

Here, I will explain how to convert the text to date using a SharePoint text field in Power Apps.

I have a SharePoint list [Loan Approval], where it has a text column as “Loan Start Date” with date values, as shown below:

On my Power Apps screen, I have added an Edit form connected to the above SharePoint list. Since the Loan Start Date is a text field, it displays as a Text-input control in the form.

When a user enters a date in text format in the “Loan Start Date” field and submits the form, the text will be converted to a date in the SharePoint list, as shown below:

Follow the below steps to achieve this:

• On the Power Apps screen, Insert an Edit form -> Set its DataSource property to:

'Loan Approval'

Where,

1. Loan Approval = SharePoint list name

• Select the Loan Date_DataCard and set its Update property as:

Text(DateValue(txt_LoanStartDate.Text))

Where,

1. txt_LoanStartDate = Text-input control name

• Insert a Button control and apply the code below on its OnSelect property:

SubmitForm(Form1);NewForm(Form1);

Where,

1. Form1 = Power Apps form control name

• Save, Publish, and Preview the app. The user will enter the form details, including the date, and click the SUBMIT button.

• Go to the specific SharePoint list and refresh it. You will view the new record where the text will be converted to a date, as shown below:

This is how we can convert the text to date using a SharePoint list in Power Apps.

Additionally, you may like some more Power Apps articles:

• Convert Text Box to Dropdown in Power Apps
• Change Power Apps Radio Button to Checkbox
• How to Validate Power Apps Combo Box Control

I hope this article helped you understand how to convert text to date in various ways in Power Apps.

Preeti Sahu

Preeti Sahu is an expert in Power Apps and has over six years of experience working with SharePoint Online and the Power Platform. She is the co-author of Microsoft Power Platform: A Deep Dive book. As a Power Platform developer, she has worked on developing various tools using Power Apps and Power Automate. She also makes Microsoft 365 videos and shares them on YouTube.