You’re offline. This is a read only version of the page.
Announcements
Hello,
I am writing flow to migrate data from SharePoint to Dataverse. The existing SP list is having implementation date as 'String' and since it is free text, users have entered date value in wrong format. Below are few examples.
So i need to validate this string if it is valid date format or not. If it is valid date format, then copy value to Data verse date field, else copy to string field.
How to validate the if the string is date or not ?
@grantjenkins : Could you please help me on this?
Hi @Anonymous ,
I think you could use regular expressions( [0-3][0-9]\/[0-1][0-9](\/\d\d\d\d)? ) to match the data sting,
I think this link will help you a lot:
Solved: Automatically identify date in string - Power Platform Community (microsoft.com)
Best Regards,
Bof
Share
Report
All responses (
Answers (
522
