Hello
I appreciate that there is a heap of posts about date string manipulation, but I haven't found anything that work; hope someone has come up against a similar issue as the one below.
I have a google form which has a date picker, which populates a gSheet. The format of the date is (New Zealand) dd/MM/yyyy
I can retrieve those rows into a Flow without any issue.
When it comes to utilising that date value as a field in a New Sharepoint item, the process fails.
I can see that the date format to populate a Sharepoint item needs to be yyyy-MM-dd
The value from the gSheet is a string, not a date.
How does one go about manipulating the date (as a string) and convert to an acceptable date format that a new Sharepoint item flow will accept.
Currently, I'm going into the gSheet each day, and changing the formatting of the cells I need processing.
regards