Answered

Get Week Number from Item Created

(0) Share

Report

Posted on by deepaks1

Hello

Please, I'm looking for some help. I have sharepoint list with a calculated column to get week number (calculate week number from Created date). When I use that column in flow, it generates 13 decimal places. Suppose the week number is 43 in the flow it generate as 43.0000000000000. How to fix this issue. I see couple of previous post, but it was not helpful. Below is my flow.

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (0)

Suggested answer

David_MA 12,982 Super User 2025 Season 2 on at

Like (0)

Report

The image of your flow isn't too helpful since it doesn't show where you are using the expression. However, just wrap the value in an int expression and the decimal and zeros will go away.

Was this reply helpful? Yes No
deepaks1 63 on at

Like (1)

Report

@David MA, Thanks. it worked exactly. I used in my expression and all decimals are removed in my output.

int(item()?['columnname'])

Was this reply helpful? Yes No