Answered

SharePoint List Remains Blank When A New Form is Submitted, While Flow Runs Successfully

Like (0) Share

Report

Posted on 27 Aug 2020 19:43:06 by Community Power Pla...

Hi All,

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?

Thanks!

All responses (25)

Answers (2)

RodolfoIsturiz 24 on 24 Jun 2021 at 07:58:45

Like (0)

Report

Re: SharePoint List Remains Blank When A New Form is Submitted, While Flow Runs Successfully

Thank you a lot @Mila and @Hardesh15 ! You also helped me a lot. I had the same problem with my flow, but now it is working perfectly!

Regards,
Community Power Pla... on 28 Aug 2020 at 16:06:50

Like (2)

Report

Re: SharePoint List Remains Blank When A New Form is Submitted, While Flow Runs Successfully

THANK YOU!!

This has now worked for me!!

Thanks so much for your help @Hardesh15 - you're a legend!
Verified answer

Hardesh15 7,087 Super User 2024 Season 1 on 28 Aug 2020 at 16:05:05

Like (2)

Report

Re: SharePoint List Remains Blank When A New Form is Submitted, While Flow Runs Successfully

@Anonymous

Its simplified version of the same-

Thanks

Hardesh
Verified answer

Hardesh15 7,087 Super User 2024 Season 1 on 28 Aug 2020 at 15:57:05

Like (2)

Report

Re: SharePoint List Remains Blank When A New Form is Submitted, While Flow Runs Successfully

@Mila

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-

if(empty(outputs('Get_response_details')?['body/r6ff84fef86f6418eba18cee1bba15ec9']),null,outputs('Get_response_details')?['body/r6ff84fef86f6418eba18cee1bba15ec9'])

Thanks

Hardesh
Community Power Pla... on 28 Aug 2020 at 15:51:34

Like (1)

Report

Re: SharePoint List Remains Blank When A New Form is Submitted, While Flow Runs Successfully

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!
Hardesh15 7,087 Super User 2024 Season 1 on 28 Aug 2020 at 15:26:07

Like (1)

Report

Re: SharePoint List Remains Blank When A New Form is Submitted, While Flow Runs Successfully

@Anonymous

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-

if(empty(outputs('Get_response_details')?['body/r6ff84fef86f6418eba18cee1bba15ec9']),null,outputs('Get_response_details')?['body/r6ff84fef86f6418eba18cee1bba15ec9'])

This (outputs('Get_response_details')?['body/r6ff84fef86f6418eba18cee1bba15ec9']) is my dynamic value of Visa expiry date from dynamic content.

Thanks

Hardesh
Community Power Pla... on 28 Aug 2020 at 14:15:14

Like (0)

Report

Re: SharePoint List Remains Blank When A New Form is Submitted, While Flow Runs Successfully

HI @Hardesh15

At the moment the only way it works is if i change the Question style in my form (i.e. changing from a date/time question to a text question - not ideal, but hey).
Community Power Pla... on 28 Aug 2020 at 13:16:53

Like (0)

Report

Re: SharePoint List Remains Blank When A New Form is Submitted, While Flow Runs Successfully

Hi @Hardesh15

I built a much simpler, 3-questions form for testing, and the same happens.

When the question that is set up as a 'date/time' question in the MS Form is not answered, the flow doesn't run and kicks up this error:
Community Power Pla... on 28 Aug 2020 at 13:04:15

Like (0)

Report

Re: SharePoint List Remains Blank When A New Form is Submitted, While Flow Runs Successfully

Hi @Hardesh15 ,

I do not know why they come up like that. I have used the following Question Option in Forms:

This is how ALL the fields that require a date (not just the date of birth) are set up in the SharePoint list:

The flow did not fail at the DOB stage (see green tick)
but at the stage when one of the questions that requires a date input (non-mandatory field in the form) is NOT populated:

The Questions (shortened below for GDPR) are not mandatory in the form and not mandatory in the sharepoint list:

Passport expiry date
Visa Expiry date
Hardesh15 7,087 Super User 2024 Season 1 on 28 Aug 2020 at 11:50:05

Like (0)

Report

Re: SharePoint List Remains Blank When A New Form is Submitted, While Flow Runs Successfully

@Mila

now understand the issue. In compose output you see "date1986-......" why date text is added before your DOB field. in SharePoint Date field you can only supply Date and time. you can not pass data like this. See my compose output there is no text prefix in date.

If you are making fields mandatory in SharePoint List then you must supply value to it. Can you give me field name from form and SharePoint List which are causing issue to you. Also please mention which are mandatory and which are optional fields. i need this to build expression so that you do not get such error.

Thanks

Hardesh