A bug where the date format is automatically changed

(0) Share

Report

Posted on by 勇金-18030020-0

Hi all - Please forgive my clumsy expressions as I am not a native English speaker.

Since updating the version of PowerApps from 3.25024.7 to 3.25031.10,

the date format has been automatically changed as shown in the attached image.

※The values from 3/25 to 31, which have not been updated, are normal, while the format of the updated values from 3/7 to 17 has been changed.

As an internal process, executing a button within the PowerApps app linked to Teams registers the execution date in the table.

This process has not been changed during version updates, and the cause of the issue is unknown.

Even a small piece of advice would be appreciated, so please lend me your help.

Categories:

Error handling

Date_Format.png

Internal_processi...

I have the same question (0)

All responses (8)

Answers (1)

ronaldwalcott 3,847 Super User 2025 Season 2 on at

Like (1)

Report

Check the documentation for your language. There may be an addendum which may point you to a solution,

Was this reply helpful? Yes No
勇金-18030020-0 21 on at

Like (0)

Report
@ronaldwalcott

Thank you for the advice, ronaldwalcott.

When I checked the Teams settings, it was in Japanese format.

After changing it to US, the date changed to US format.

However, I have never changed the settings in this section since registering my Microsoft account.

Additionally, the internal process for registering in the table converts the registration date and time using the formula below.

DateValue(Text(Now(),"yyyy/mm/dd hh:mm:ss"))

I hope this information helps to resolve the issue that has been troubling me.

ENGLISH_US.png

JAPANESE.png

Was this reply helpful? Yes No
Suggested answer

venturemavenwill 1,189 Super User 2025 Season 2 on at

Like (0)

Report
If I understand you correctly, you are using a patch function to create a date text string when creating the label, is that correct?

If so, try the following formula instead

Text(Now(), "yyyy年mm月dd日")

Unfortunately the language setting does not appear to work for Japanese at the moment.

Was this reply helpful? Yes No
勇金-18030020-0 21 on at

Like (0)

Report

@venturemavenwil

Thank you for the advice, venturemavenwil.

As you are aware, I am using the patch function to create a date text string when registering new records in the table.

I apologize for the lack of explanation.

What I want to do is use the Japanese format for the language settings in Teams,

and convert the current time in PowerApps processing to the format "Text(Now(),"yyyy/mm/dd")"

using the Text function and register it in a table.

What troubles me is that even though I set the format as "Text(Now(),"yyyy/mm/dd")" during the conversion

with the Text function, it gets converted to the format "Text(Now(),"yyyy年mm月dd日")".

I sincerely want to resolve this part.

>Unfortunately the language setting does not appear to work for Japanese at the moment.
If this is true, I am very sad... I hope it gets fixed soon.

Was this reply helpful? Yes No
venturemavenwill 1,189 Super User 2025 Season 2 on at

Like (0)

Report

I am a little confused, based on your screenshot

This is a text field, and it appears that it is already displaying dates in the format "yyyy/mm/dd". This has nothing to do with the Teams language setting. Do you want to convert your previous dates from the Japanese format to yyyy/mm/dd?

Was this reply helpful? Yes No
勇金-18030020-0 21 on at

Like (0)

Report

@venturemavenwil

I'm sorry for confusing you, venturemavenwil.

The data for March was registered in the date format "yyyy/mm/dd" when the version of PowerApps was 3.25024.7.

After updating the version to 3.25031.10 and using the patch function to update the data from 3/7 to 17 that needed changes,

the date format changed to "yyyy年mm月dd日".

The process of updating the date during the version update has not been changed,

and the date format from 3/7 to 17 should have been updated in the format "yyyy/mm/dd" like from 3/25 to 31

Was this reply helpful? Yes No
Verified answer

venturemavenwill 1,189 Super User 2025 Season 2 on at

Like (0)

Report
Hi @勇金-18030020-0,

I see, so the problem is that PowerApps is automatically using your local language zone, even though you don't want it to.

In that case, you can forcibly set the language zone of the Date string

Text(Now(), "yyyy/mm/dd", "en-US")

Let me know if this helps

Was this reply helpful? Yes No
勇金-18030020-0 21 on at

Like (0)

Report

@venturemavenwil

Thank you for the advice, venturemavenwil.

When you implemented your process, the display format changed to "yyyy/mm/dd".

My doubts have been resolved. Thank you for sincerely addressing this topic.

Was this reply helpful? Yes No