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
Solved! Go to Solution.
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,
@iAm_ManCat |
Please 'Mark as Solution' if someone's post answered your question and always 'Thumbs Up' the posts you like or that helped you! |
Thanks! |
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,
@iAm_ManCat |
Please 'Mark as Solution' if someone's post answered your question and always 'Thumbs Up' the posts you like or that helped you! |
Thanks! |