Skip to main content

Notifications

Power Automate - Building Flows
Answered

Accounting Period 202309 instead of 20239

(0) ShareShare
ReportReport
Posted on by 5

I have two columns in sharepoint that I am pulling from (with example):

Year = 2023

Month =  9

 

In my flow I am combining them with this: 

concat(items('Apply_to_each')?['Fiscal Year'], items('Apply_to_each')?['Period'])
 
How do I fix this equation so that I get the following:
 
YearMonthAccounting Period Result
20231202301
20239202309
202310202310
202311202311
  • Verified answer
    ManishSolanki Profile Picture
    ManishSolanki 15,075 on at
    Re: Accounting Period 202309 instead of 20239

    Hi @tdanna 

     

    Pls use the below expression to format month value:

    concat(items('Apply_to_each')?['Fiscal Year'], formatNumber(int(items('Apply_to_each')?['Period']),'00'))

     

    If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.

     

    Thanks

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

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,422

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,711

Leaderboard