How to Convert Text to Date in Power Apps?

Handling dates is a common task for many Power Apps users.

Sometimes, we can come across dates that are formatted as text (or look like dates but are not in the acceptable date formats, so Power Apps treats them as text strings).

But, If a date is stored as a text string in Power Apps, you cannot utilize it as an actual date.

In this Power Apps tutorial, you will learn how to convert text to date in Power Apps.

How to Convert Text to Date in Power Apps

In this section, let us check how to convert text to date in three different simple scenarios:

  1. How to convert text to date in Power Apps and display results in a label
  2. Convert Text to Date in Power Apps and display the result in a Date-picker
  3. Power Apps convert Text to Date using SharePoint list

Example – 1: Convert text to date in Power Apps and display results in a Label

First, we’ll look at scenarios where you will convert the text to ShortDate format in Power Apps.

Example:

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].

Power Apps convert text to date

Follow the steps below to achieve it:

  • On the Power Apps screen, insert a Text input control as shown below:
Convert text to date in Power Apps
  • 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
How to convert Text to Date in Power Apps with Date formats
  • Save, Publish, and Preview the app. When you provide the date as a string in text-input control, the text label will convert the text to ShortDate as dd/mm/yyyy.
Convert Text to Date in Power Apps with Date formats

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 Power Apps and display results in a Date picker

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

Example:

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:

How to convert Text to Date in Power Apps

Let’s follow the below steps to achieve this:

  • On the Power Apps screen, insert a Text-input control as shown below:
Convert Text to Date in Power Apps using Date-picker
  • Insert a Date-picker control and set its DefaultDate property as:
DateValue(txt_Date.Text)

Where,

  1. txt_Date = Text input control name
How to convert Text to Date in Power Apps using Date-picker
  • Save, Publish, and Preview the app. When you provide the date as a string in the text input control, the date-picker will select a date based on the user-provided value.
Power Apps convert Text to Date using Date-picker

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.

Power Apps convert Text to Date using SharePoint list

Here, you will learn how to convert the text to date using a SharePoint list in Power Apps.

Example:

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

Convert Power Apps Text to Date

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:

Power Apps convert text to date using the SharePoint list

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
Convert Text to Date using SharePoint list in Power Apps
  • Select the Loan Date_DataCard and set its Update property as:
Text(DateValue(txt_LoanStartDate.Text))

Where,

  1. txt_LoanStartDate = Text-input control name
How to convert Text to Date using SharePoint list in Power Apps
  • Insert a Button control and apply the code below on it’s OnSelect property:
SubmitForm(Form1);NewForm(Form1);

Where,

  1. Form1 = Power Apps form control name
Convert Power Apps Text to Date using SharePoint list
  • SavePublish, and Preview the app. The user will enter the form details, including the date, and click the SUBMIT button.
How to convert Power Apps Text to Date
  • 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:
Power Apps convert Text to Date using SharePoint list

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

Some more Power Apps articles you may also like:

Conclusion

We can convert text to a date by utilizing formulas like the DateValue function, obtain the date’s serial number, and then format it to display as a short or long date.

In this Power Apps tutorial, you have learned how to convert text to date in Power Apps using different scenarios.

I hope you found this Power Apps tutorial useful.