You essentially need to convert it to a date time variable first. When you use Convert text to datetime, and provide a custom format without a day, it will by default convert it to the 1st of the month. You then need to use Add to date time twice - once to add one month, and once do deduct the current day, so you end up with the end of the month.
See this sample flow:
And note the custom format I used in the Convert text to datetime action:
Finally, note that this will only work if the language of the name of the month matches the regional settings for your machine. If your machine is set up in a different language, it won't work, and you'll need to implement some sort of a dictionary functionality, or use a Python script.
Here's a code snippet you can copy and paste into your designer to have the actions created for you automatically:
SET DateAsString TO $'''Feb, 2023'''
Text.ConvertTextToDateTime.ToDateTimeCustomFormat Text: DateAsString CustomFormat: $'''MMM, yyyy''' DateTime=> TextAsDateTime
DateTime.Add DateTime: TextAsDateTime TimeToAdd: 1 TimeUnit: DateTime.TimeUnit.Months ResultedDate=> ResultedDate
DateTime.Add DateTime: ResultedDate TimeToAdd: $'''-%ResultedDate.Day%''' TimeUnit: DateTime.TimeUnit.Days ResultedDate=> EndOfMonth
-------------------------------------------------------------------------
If I have answered your question, please mark it as the preferred solution. If you like my response, please give it a Thumbs Up.
I also provide paid consultancy and development services using Power Automate. If you're interested, DM me and we can discuss it.
