Unanswered

Datepicker going to a single line of text data source

(0) Share

Report

Posted on by Sharinah1

101

I've set my column type as "Single line of text". Purpose is so that I will be able to set "N/A" default value if date picker in PowerApps is empty.

Now, the problem is that I want the columns to show the date format as MM/DD/YYYY, similar with the date picker. But currently it shows YYYY-MM-DD.

Data source:

Input form powerapps:

Categories:

Building Power Apps

I have the same question (0)

All responses (8)

Answers (0)

v-bofeng-msft on at

Like (0)

Report
Hi @Sharinah1 ,

You could use this formula to convert the date value to "mm/dd/yyyy" fromat

Text(DatePicker1.SelectedDate,"mm/dd/yyyy")

Best Regards,

Bof

Was this reply helpful? Yes No
Sharinah1 101 on at

Like (0)

Report

Thank you. Sorry for this question but, may I know where do I put this? I'm assuming under Update option of the datepicker?

Was this reply helpful? Yes No
v-bofeng-msft on at

Like (0)

Report
Hi @Sharinah1 ,

If the data picker is in a form, you could set the datacard's Update property to

Text(DatePickerName.SelectedDate,"mm/dd/yyyy")

Best Regards,

Bof

Was this reply helpful? Yes No
Sharinah1 101 on at

Like (0)

Report

Thank you. Added it already but this shows in my SP List.

Was this reply helpful? Yes No
v-bofeng-msft on at

Like (0)

Report

Hi @Sharinah1 ,

Could you please show me more details about your canvas app?

How do you submit the record? Could you please show me the formula?

Best Regards,

Bof

Was this reply helpful? Yes No
Sharinah1 101 on at

Like (0)

Report

Hello thanks so much. Just a Submit button for Form3_2. OnSelect function is below syntax.
then here is when I applied the formula on Update property of datepicker datacard

Was this reply helpful? Yes No
v-bofeng-msft on at

Like (0)

Report

Hi @Sharinah1 ,

It looks fine. Is 'Close Out Date #1' a single-line-of-text column? Could you please refresh the data source and try again? If it not work, please consider re-add the form.

Best Regards,

Bof

Was this reply helpful? Yes No
Sharinah1 101 on at

Like (0)

Report

Yes, single line of text. I'll refresh and see.

Was this reply helpful? Yes No