Power Platform Community Forum Thread Details

For example:

(1) Today is 2025.4.7, I need to obtain 2025.3.1 and 2025.3.31

(2) If it is a day in March, I need to obtain 2025.2.1 and 2025.2.28

Is there an expert who can help guide the method of implementing with PAD，Thank you.

Categories:

Power Automate Desktop

Hi @LZ-27040911-0

Please refer the below flow for reference:

You can copy paste this to your flow as well

SET CurrentDateTime TO D'2025/04/25 00:00:00'
DateTime.Add DateTime: CurrentDateTime TimeToAdd: -1 TimeUnit: DateTime.TimeUnit.Months ResultedDate=> ResultedDate
DateTime.Add DateTime: ResultedDate TimeToAdd: $'''-%ResultedDate.Day - 1%''' TimeUnit: DateTime.TimeUnit.Days ResultedDate=> StartDate
DateTime.Add DateTime: StartDate TimeToAdd: 1 TimeUnit: DateTime.TimeUnit.Months ResultedDate=> EndDate
DateTime.Add DateTime: EndDate TimeToAdd: -1 TimeUnit: DateTime.TimeUnit.Days ResultedDate=> EndDate
Text.ConvertDateTimeToText.FromCustomDateTime DateTime: StartDate CustomFormat: $'''yyyy.MM.dd''' Result=> StartDate
Text.ConvertDateTimeToText.FromCustomDateTime DateTime: EndDate CustomFormat: $'''yyyy.MM.dd''' Result=> EndDate

Thanks & Regards,
Nived N

Stay connected:
LinkedIn | YouTube | Blogs

Was this answer helpful?
If yes, please mark it as the solution by selecting the checkbox in the discussion thread.
Your feedback motivates me to keep contributing. Thank you!