Answered

Setting variable values

(0) Share

Report

Posted on by Rocko

Is there a way to set a variable to a value using a function or formula in PAD? For example, I want to create a variable named BeginDate that is set to the first day of the previous month and then another variable named EndDate to be the last day of the previous month. These would then be used to pass to a reporting application as the date range to run report with.

Thanks.

Categories:

Power Automate Desktop

I have the same question (0)

All responses (7)

Answers (1)

Sort by

Henrik_M 2,021 Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!
No. There are no functions or formulas. You need to do it with actions. Try pasting this code into your flow:

Display.SelectDate DateDialogFormat: Display.DateDialogFormat.DateOnly IsTopMost: True SelectedDate=> SelectedDate Text.ToDateTime Text: $'''01-%SelectedDate.Month%-%SelectedDate.Year%''' DateTime=> TextAsDateTime DateTime.Add DateTime: TextAsDateTime TimeToAdd: -1 TimeUnit: DateTime.TimeUnit.Days ResultedDate=> EndDate Text.ToDateTime Text: $'''01-%EndDate.Month%-%EndDate.Year%''' DateTime=> BeginDate

Was this reply helpful? Yes No
Rocko 8 on at

Like (0)

Report
Copy link

Link copied!

Thank you for the reply. I am new to Power Automate/PAD and struggling to try to get what I think are basic things to work. I am currently evaluating this tool as a cheaper option than my current RPA solution.

Where exactly would I paste this code? I am working entirely in the desktop app. All the searching I have done has shown using functions/expressions in the web interface. Am I even wrong in assuming that everything can be done in the desktop app? I am on the verge of giving up and just writing this off as being overly complex compared to my current tool. As an example, my current tool already has predefined date variables ("FirstDayPriorMonth", "LastDayPriorMonth",etc). All I have to do is send those as inputs to my SSRS report parameters and then have it click "View Report" and all is good.

Thanks again for the help!

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @Rocko , you can directly paste the @Henrik_M code in PAD development canvas.
It will convert the above code to PAD actions.

Hope this helps 🙂

Was this reply helpful? Yes No
Rocko 8 on at

Like (0)

Report
Copy link

Link copied!

Thanks again Henrick_M....this gets me half way there. The End Date (last day of prior month) is the same as the Begin Date. I have done my best to figure out how to manipulate the logic you provided but I am not having any luck.

Was this reply helpful? Yes No
GanCW 237 on at

Like (0)

Report
Copy link

Link copied!

@Anonymous ,
How to get to this development canvas ?

Was this reply helpful? Yes No
Verified answer

GanCW 237 on at

Like (0)

Report
Copy link

Link copied!

Rocko,
You can accomplish this in PAD.
1. Get current date
2. Last day of the prev month = current date - day number
3. New date = current date - 1 month
3. First day of the previous month = new date - day number + 1

Was this reply helpful? Yes No
Rocko 8 on at

Like (0)

Report
Copy link

Link copied!

Thank you GanCW! This got me what I was looking for.

Was this reply helpful? Yes No