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:
Year | Month | Accounting Period Result |
2023 | 1 | 202301 |
2023 | 9 | 202309 |
2023 | 10 | 202310 |
2023 | 11 | 202311 |
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