web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / How do I capture the c...
Power Automate
Answered

How do I capture the current quarter

(0) ShareShare
ReportReport
Posted on by 1,362

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

 

Categories:
  • Verified answer
    golfnutt82 Profile Picture
    1,362 on at

    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.

  • Verified answer
    jinivthakkar Profile Picture
    4,187 on at

    @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.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Leaderboard > Power Automate

#1
Mohsin Ali Profile Picture

Mohsin Ali 389

#2
11manish Profile Picture

11manish 345 Super User 2026 Season 2

#3
M Bilal Khan Profile Picture

M Bilal Khan 308

Last 30 days Overall leaderboard