Unanswered

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

(0) Share

Report

Posted on 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!

Categories:

General topics

I have the same question (0)

All responses (25)

Answers (2)

Hardesh15 7,087 Super User 2024 Season 1 on at

Like (0)

Report

@Mila

Pls expand your create item action and share screen. It will help me to see if you are passing correct value in it.

Thanks

Hardesh

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Hi Hardesh,
Thank you.

Here is a screenshot:

The list either remains blank:
or sometimes is blank but with this symbol:

I have had erratic results all day which makes it very difficult to troubleshoot, in particular for a novice.

Thanks
Mila

Was this reply helpful? Yes No
Hardesh15 7,087 Super User 2024 Season 1 on at

Like (0)

Report

@Mila

You are passing response id incorrect. Please select response id from dynamic content.

Take help from here

https://flow.microsoft.com/en-us/blog/building-scratch-forms-responses/#:~:text=Getting%20the%20response%20data&text=To%20find%20the%20action%2C%20select,you%20used%20in%20the%20trigger.

Thanks

Hardesh

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Hi Hardesh,

Having done that, now the Flow fails and this is what I get:

Thanks
Mila

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

I should also point out that I have just built a much smaller form with 3 questions (one of which 'Date') and that works ok and transfers data into a sharepoint list with no errors.

I read lots of community articles, microsoft online tutorials, watched YouTube videos, but I just cant get this to work 😞

Mila

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

@Hardesh15 will you be able to help?

Was this reply helpful? Yes No
CFernandes 8,402 Most Valuable Professional on at

Like (0)

Report
Hi @Anonymous

I had a look at your Power Automate(Flow) and it seems that you are not Hard-coding the value in 'Get Form response' action which is not the best practice.

For the “Response Id” add the output from the “When a new response is Submitted” trigger action.(screenshot below).

In your latest update, I see the error . The runtime value '""' to be converted doesn't have the expected format 'String/date'.
Add a new formula for the 'Date of Birth' Field in Create action.

formatDate(<YourDateField>,'dd/MM/yyyy')

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Hi @CFernandes

What you suggested I use below I cannot find in Dynamic Content:

With regards to 'Add a new formula for the 'Date of Birth' Field in Create action", do you mean typing the formula string you shared right beside the dynamic content tag in the Date of Birth field on the Create Item action?

Thanks
MIla

Was this reply helpful? Yes No
Hardesh15 7,087 Super User 2024 Season 1 on at

Like (0)

Report

@Mila

Pls add compose action before create item and pass your date of birth input in it and show me output.

Thanks

Hardesh

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Hi @Hardesh15

Is this what you are asking me to do? Struggling to follow with no visuals. Newbie here.

I do not know where to add the formula @CFernandes gave me, and when I look for it in 'expressions', it does not come up.

Was this reply helpful? Yes No