In my work area they follow the SharePoint files like(previous month and present month) so the problem is if present month files is jan 2023 it will pick fine but previous month file is dec 2022 insted the logic app will pick dec 2023 If present month is Feb then previous month is jan it fine because both are in same years Can you please provide the solution for this case

@Vijay-2791 Thanks for reaching out. You can leverage the below function expression. You can refer to Date and Time function . formatDateTime(addDays(startOfMonth(utcNow()),-1),'MMMyyyy') As today date is 4th Jan 2023 the output of the above expression is Dec2022 Please 'Accept as answer' and ‘Upvote’ if it helped so that it can help others in the community looking for help on similar topics.

How to pass previous year in the expression

Accepted answer

MayankBargali-MSFT 70,796 Reputation points

2023-01-04T09:22:56.853+00:00
@Vijay-2791 Thanks for reaching out. You can leverage the below function expression. You can refer to Date and Time function .

formatDateTime(addDays(startOfMonth(utcNow()),-1),'MMMyyyy')

As today date is 4th Jan 2023 the output of the above expression is Dec2022

Please 'Accept as answer' and ‘Upvote’ if it helped so that it can help others in the community looking for help on similar topics.
Please sign in to rate this answer.
Vijay-2791 151 Reputation points

2023-01-04T10:19:20.137+00:00

Can we change again after present month is Feb and previous month is jan then this two months are in 2023 is that condition is applicable to this one

MayankBargali-MSFT 70,796 Reputation points

2023-01-04T10:30:31.623+00:00

@Vijay-2791 You don't have to change. It will always give you the previous month along with year of today's date.

utcNow() --> Today's date i.e. the logic app run date.
startOfMonth(utcNow()) --> gives the start date of the current month.
addDays(startOfMonth(utcNow()),-1) --> gives you the last date of the previous month as we are adding -1.
formatDateTime(addDays(startOfMonth(utcNow()),-1),'MMMyyyy') -->returns the last month with the year

Vijay-2791 151 Reputation points

2023-01-04T10:38:32.437+00:00

Thank you so much

Vijay-2791 151 Reputation points

2023-01-04T10:40:32.123+00:00

Is it applicable to this scenario year 2023 present month Feb previous month Jan

MayankBargali-MSFT 70,796 Reputation points

2023-01-05T11:02:46.34+00:00

@Vijay-2791 Thanks for your response. Feel free to 'Accept as answer' and ‘Upvote’ so that it can help others in the community looking for help on similar topics.
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Share via

How to pass previous year in the expression

0 additional answers

Your answer