Unanswered

TImeValue in edit mode

(0) Share

Report

Posted on by ShaikSayyad

111

If(Activity_Form.Mode = FormMode.Edit, Value(Text(TimeValue(Parent.Default),"[$-en-GB]HH")))

I can able to show the HH,mm AM/PM in edit mode in my local using above Function at Default to the Drop down but HH, mm are not working in other regions

did I missed something here

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Sort by

v-albai-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @ShaikSayyad ,
You can try to add "en-GB" as last parameter to Text function.
Check if below formula can work:
If(Activity_Form.Mode = FormMode.Edit, Value(Text(TimeValue(Parent.Default),"[$-en-GB]HH","en-GB")))
Best regards,
Allen

Was this reply helpful? Yes No
ShaikSayyad 111 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi,
Not worked above suggestion.

I have a Text field in SharePoint which has time value like format (02:45 AM ), How do I show this Time value in edit form in three dropdwons like below screen

I can able to see AM/PM with Default Function - If(Activity_Form.Mode = FormMode.Edit, Text(TimeValue(Parent.Default),"[$-en-GB]AM/PM"))

but for HH dropdown -
If(Activity_Form.Mode = FormMode.Edit, Value(Text(TimeValue(Parent.Default),"[$-en-GB]HH"))) - Not working and
For mm dropdown -
If(Activity_Form.Mode = FormMode.Edit, Value(Text(TimeValue(Parent.Default),"[$-en-GB]mm")))

How do I solve this

Was this reply helpful? Yes No
v-albai-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @ShaikSayyad ,
You can use Hour() and Minute() function to get the exact number.
So for HH dropdown, try this:

If(Activity_Form.Mode = FormMode.Edit, Hour(TimeValue(Parent.Default)))

For mm dropdown:

If(Activity_Form.Mode = FormMode.Edit, Minute(TimeValue(Parent.Default)))

Note: The result of "Hour(TimeValue(Parent.Default))" and "Minute(TimeValue(Parent.Default))" are both Number, so you can directly use them, do not need to convert the format again.
Best regards,
Allen

Was this reply helpful? Yes No