Re: Trigger a flow from a date within a SharePoint list
Hi @v-LilyW-msft ,
Thanks for your update, I gave your tips a try.
I first updated the function with addDays(utcNow(),30,'yyyy-MM-dd'). Getting successful runs still, but still no Planner Task.
I also added your 2 Compose steps and when I go back to check them, I'm getting slightly different results then you are:
I also noticed the date format in our SharePoint list appears as such ('Date and Time' attribute column in SharePoint).
I'm wondering if the MM portion of how the date format is causing a problem? Single digit months don't have a 0 in front of them.
I tried editing the way the date is formatted to try and matching what's in SharePoint.
I've attempted:
addDays(utcNow(),30,'MM-dd-yyyy')
addDays(utcNow(),30,'MM-DD-YYYY')
addDays(utcNow(),30,'mm-dd-yyyy')
addDays(utcNow(),30,'MM/DD/YYYY')
addDays(utcNow(),30,'mm/dd/yyyy')
Still getting successful runs, still no Planner Task. What format should I use to match what's in the SharePoint list? Should I change the column's attribute in the list?
Thanks again!