web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Get Month Value from Text
Power Apps
Unanswered

Get Month Value from Text

(0) ShareShare
ReportReport
Posted on by 22

Hello, 

currently having an issue, where I have a Text Column Month ("January";"February" etc). 

I would like to add another Column using for the DateID with the corresponding Values "January" -> 1 and so on . 
This Column will have for example 20220101 as an Value. 

Is there a function in which i can retrieve the Month value? 

 

Thanks in advance. 

Categories:
I have the same question (0)
  • WarrenBelz Profile Picture
    153,733 Most Valuable Professional on at

    Hi @PhilippMer ,

    This should do it

    Text(
     DateValue(
     Mid(
     YourText,
     3,
     2
     ) & "-" & 
     Right(
     YourText,
     2
     ) & "-" & 
     Left(
     YourText,
     2
     )
     ),
     "mmmm"
    )

     

    Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

    Visit my blog Practical Power Apps

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 279 Most Valuable Professional

#2
Kalathiya Profile Picture

Kalathiya 229 Super User 2026 Season 1

#3
VASANTH KUMAR BALMADI Profile Picture

VASANTH KUMAR BALMADI 195

Last 30 days Overall leaderboard