Answered

Make float variable value to be displayed in hours and minutes // Power Automate

(0) Share

Report

Posted on by P3tar

Hi everyone!

I'm creating a flowchart in Power Automate which will populate a planner task
I want my float value to be converted to hours and minutes
For an example i would like to make my float value which is 25.86 be displayed as 25h 51m

i've tried couple of codes but im getting an error message that the expression is invalid

1.int(variables('Result')) & 'h ' & int((variables('Result')-int(variables('Result')))*60) & 'm'
2.concat(int(variables('Result')), 'h ', int((variables('Result')-int(variables('Result')))*60), 'm'

Does anyone have an idea on what else could i try?

Thanks in advance!

I have the same question (0)

All responses (3)

Answers (2)

Verified answer

v-qiaqi@microsoft.com on at

Like (1)

Report
Re: Make float variable value to be displayed in hours and minutes // Power Automate

Hi @P3tar,

Here is thing, int() can only be used for an integer and float() can only be used with a float, which means you could not use the int() if the variable('Result') is a float.

Here is a simple demo for reference:

int(first(split(string(variables('Float')),'.')))
int(first(split(string(mul(div(float(last(split(string(variables('Float')),'.'))),100),60)),'.')))
concat(outputs('extract_int_from_the_float_25'),'h ', outputs('extract_float_from_the_float_0.86'),'m')

Was this reply helpful? Yes No
Verified answer

grantjenkins 11,059 Moderator on at

Like (1)

Report
Re: Make float variable value to be displayed in hours and minutes // Power Automate

Hopefully this is what you're looking for.

See full flow below. I'll go into each of the actions.

Initialize variable contains your original value.

Hours is a Compose that uses the following expression to get the hours.
first(split(string(variables('Result')), '.'))

Minutes is a Compose that uses the following expression to get the minutes rounded to the nearest minute.
formatNumber(mul(div(float(last(split(string(variables('Result')), '.'))), 100), 60), 'N0')

Hours and Minutes is a Compose that builds up your hours and minutes.
concat(outputs('Hours'), 'h ', outputs('Minutes'), 'm')

The final output after running the flow would be:

----------------------------------------------------------------------
If I've answered your question, please mark the post as Solved.
If you like my response, please consider giving it a Thumbs Up.

Was this reply helpful? Yes No
P3tar 13 on at

Like (0)

Report

Re: Make float variable value to be displayed in hours and minutes // Power Automate

@grantjenkins @v-qiaqi-msft

Thanks a lot guys!!

This is perfect 🙂

Was this reply helpful? Yes No