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

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Date field in (MMM/YYY...
Power Apps
Unanswered

Date field in (MMM/YYYY) format

(0) ShareShare
ReportReport
Posted on by 274

Hi PowerApp Users,

I have a requirement in my SharePoint list field to capture only the month and year without the day (E.g.-Aug/2019).

Is it possible with PowerApps.

If not with a date field, I can go ahead and use a single line of text field and tell user to populate in the format- MMM/YY. But how can i validate it.

Any help appreciated.

Thanks,

Kevin

Categories:
I have the same question (0)
  • Verified answer
    iAm_ManCat Profile Picture
    18,228 Most Valuable Professional on at

    Hi!

     

    I think you're looking for something like this? (To autopopulate today's month/year into a SharePoint text field)

     

    image.png

     

    And if it's not going to be Today's date and you just want it to match a regex field, you could use this formula and Regular Expressions (regex) to determine if the text in the textbox matches mmm/yyyy :


    image.png

    That's
    If(IsMatch(TextInput1.Text, "^\w{3}\/\d{4}"), "Date is in correct format", "Date format must be mmm/yyyy")

     

     

    If neither of these options works for you then let me know a little more detail around what you're trying to achieve,

     

    Cheers,

    @iAm_ManCat

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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 796 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 327 Super User 2025 Season 2

#3
Power Platform 1919 Profile Picture

Power Platform 1919 268

Last 30 days Overall leaderboard