I have created a flow, which runs successfully, an which has the objective of transferring the data harvested through an MS Form into a SharePoint list.
Throughout the day, I have had all sorts of errors, including the 'string date/time' error.
The latest, and the one that keeps recurring, is that the flow runs successfully and yet my list in SharePoint is empty, with only the Title field being populated.
I have rebuilt that list 4 times (at some point today it would not let me import it from Excel, despite having worked ok all morning) and I am at the end of my rope.
Can anyone help?
Solved! Go to Solution.
i followed your logic and created test. i have created two date question in my MS form 1. DOB (required) 2. Visa Expiry (Not required).
and in SharePoint list made same column type.
Use this expression in each create item column for which date is optional-
This (outputs('Get_response_details')?['body/r6ff84fef86f6418eba18cee1bba15ec9']) is my dynamic value of Visa expiry date from dynamic content.
So sorry @Hardesh15 , I tried but this doesn't work.
I have now updated the MS Form and deleted the date/time questions, and rebuilt them as single line text so that I can move on with the process.
Thank you SO much for trying to help me!
Actually i pasted wrong screen. So i edit my last post. this will definitely work. i tested it.
use this kind of expression in your create item date column-
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Join us on June 28 for our monthly User Group leader call!
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
Are you new to designing flows? What is your biggest struggle with Power Automate Designer? Help us make it more user friendly!