cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
golfnutt82
Super User
Super User

How do I capture the current quarter

Hello and good morning,


I have a situation where I need to update a SharePoint list on a quarterly basis.

My first thought was to get the current quarter, easy enough - 

golfnutt82_0-1641907175793.png

I have a SharePoint column called "CurrQuarter"

So when an item is added to the list and my workflow runs, I want to add the current quarter to that item.
So what I attempted to do was create four conditions to update a variable that would hold the current quarter number value

golfnutt82_1-1641907349550.png

golfnutt82_2-1641907408610.png

golfnutt82_3-1641907472413.png

If the first condition isnt met then do the next condition

golfnutt82_4-1641907534642.png

golfnutt82_5-1641907575380.png

And if the second condition isnt met then evaluate the third condition and so on.

The issue is that this doesnt work.
Some direction from the experts here would definately help this noobie greatly!

Thanks

 

2 ACCEPTED SOLUTIONS

Accepted Solutions
golfnutt82
Super User
Super User

Figured this out.
The data returned by the ForrmatDateTime function returns a zero in front of the value.
My conditions were not correct because I was evaluating the variable as a single digit versus 01.

View solution in original post

jinivthakkar
Dual Super User
Dual Super User

@golfnutt82 this can be done using parallel branch

jinivthakkar_0-1641913403715.png

jinivthakkar_1-1641913456724.png

Condition - for Q1, numeric value equals to less than or equals to 3

jinivthakkar_2-1641913491268.png

Condition 1 - for Q2, numeric value greater than 3 but less than or equals to 6 

jinivthakkar_3-1641913555086.png

and so on...

you need to add 2 more conditions for Q3, Q4

 

--------------------------------------------------------------------------------

If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.

View solution in original post

2 REPLIES 2
golfnutt82
Super User
Super User

Figured this out.
The data returned by the ForrmatDateTime function returns a zero in front of the value.
My conditions were not correct because I was evaluating the variable as a single digit versus 01.

jinivthakkar
Dual Super User
Dual Super User

@golfnutt82 this can be done using parallel branch

jinivthakkar_0-1641913403715.png

jinivthakkar_1-1641913456724.png

Condition - for Q1, numeric value equals to less than or equals to 3

jinivthakkar_2-1641913491268.png

Condition 1 - for Q2, numeric value greater than 3 but less than or equals to 6 

jinivthakkar_3-1641913555086.png

and so on...

you need to add 2 more conditions for Q3, Q4

 

--------------------------------------------------------------------------------

If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.

Helpful resources

Announcements
MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

New Process Advisor Capabilities carousel.png

Read the blog for the latest news

Read the latest about new experiences and capabilities in the Power Automate product blog.

PA Survey Carousel Image.png

We want to hear from you!

If you are a small business ISV/Reseller, share your thoughts with our research team.

Users online (2,190)