cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
HassanWahab
Regular Visitor

Convert date to Month number and week number via flow

Hi All, 

 

I have created ms form and now for reporting purpose i need to convert the completion time to Month and week number via automated flow. 

I tried to do it in excel but the formulas are not capturing new responses data. 

 

Below is my flow but its not working. Can anyone please help?

HassanWahab_0-1634808204437.pngHassanWahab_1-1634808326768.png

 

 

They data should look like below after the flow. 

 

HassanWahab_2-1634808376994.png

 

Thanks

Hassan

 

1 ACCEPTED SOLUTION

Accepted Solutions
Hardesh15
Super User
Super User

@HassanWahab 

To get month- utcNow('MM')

To Get Week- add(div(dayOfYear(convertFromUtc(utcNow(),'India Standard Time','U')),7),1)

Please 'Thumbs Up' the posts that helped you and 'Mark as Solution' if my post answered your question.

@Hardesh /Gopenly.in

View solution in original post

2 REPLIES 2
Hardesh15
Super User
Super User

@HassanWahab 

To get month- utcNow('MM')

To Get Week- add(div(dayOfYear(convertFromUtc(utcNow(),'India Standard Time','U')),7),1)

Please 'Thumbs Up' the posts that helped you and 'Mark as Solution' if my post answered your question.

@Hardesh /Gopenly.in

View solution in original post

HassanWahab
Regular Visitor

Thanks Hardesh. It worked

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Users online (2,821)