web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate Set variable for previ...

Power Automate

Answered

Set variable for previous month number

(1) Share

Report

Report

Posted on by VM-28111506-0

9

Hi everyone,

I’m new to Power Automate, and trying to create a variable in Power Automate Desktop that returns the number of the previous month, in order to fill a SAP field.

However, after testing multiple approaches, the variable always ends up not returning nothing.

Expressions that I tried:

Month(AddMonths(Today(), -1))

Month(AddToDate(Today(), 0, -1, 0))

I tested this by inserting this variable in the SAP field and it didn't fill nothing. I thought that it could be some problem related to SAP, so insted I tested using the "Get clipboard text" and opening a Word document, and then copying, but it also doesn't return nothing, so I think the problem must be with the variable.

Any help? Thanks in advance!

Categories:

Power Automate Desktop

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

Expiscornovus 33,851 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hi @VM-28111506-0,

Edit: my bad. I see this is about Power Automate Desktop. Ignore the below approach (which is for cloud flows, not desktop flows) 😅

You can use the addToTime & utcNow functions for this. Use the Month interval and use the MM format (which returns only the month).

Try the below:

addToTime(utcNow(), -1, 'Month', 'MM')

Happy to help out 😁

I share more #PowerAutomate and #SharePointOnline content on my Blog, LinkedIn, Bluesky profile or Youtube Channel

Was this reply helpful? Yes No
Verified answer

Expiscornovus 33,851 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

Hi @VM-28111506-0,

For Power Automate desktop try the below approach with the Add to datetime & Convert datetime to text actions.

https://learn.microsoft.com/en-us/power-automate/desktop-flows/actions-reference/datetime

Happy to help out 😁

I share more #PowerAutomate and #SharePointOnline content on my Blog, LinkedIn, Bluesky profile or Youtube Channel

Was this reply helpful? Yes No

Join the conversation