web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate Is hour integer or str...

Power Automate

Unanswered

Is hour integer or string? how to display hour from date as a number only?

(0) Share

Report

Report

Posted on by Sebey

127

I have an hour number column in my sharepoint list. the value of column hour is any single number from [0,1,2,3,4,5,6,7....22,23,24]

ID	Hour	title
1	7

Now i want my flow to run based on my condition which is :

run if hour value in sharepoint is equal to the current hour

I tried the following:

this one works fine but I should put manually 7

I tried to make it better by using expression in the value of 7 so that it will always compare with current hour of the day:

but this one fails, it doesnot work.

hour field in my sharepoint list is number data type.

your suggestions and solutions are welcomed

Categories:

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (2)

Verified answer

Matthy79 4,180 Super User 2024 Season 1 on at

Like (0)

Report

Hello @Sebey

If you use formatDateTime the result is a string and that can't be compared to a number. Use "int" to convert it.

Was this reply helpful? Yes No
Verified answer

Mitanshu 1,650 Moderator on at

Like (0)

Report
Try the following expression:

int(formatDateTime(utcNow(),'HH'))

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If this post or my previous reply was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No

Join the conversation