
Announcements
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
Hi!
I think you're looking for something like this? (To autopopulate today's month/year into a SharePoint text field)
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 :
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,