Flow not filling in all information from a excel spreadsheet to SharePoint List

[eric142]

Hi,

I am using Microsoft forms to file out a Pass/Fail questioner after the questioner is submitted a flow fills in the answers to a spreadsheet.  This flow is working correctly.  As you can see question number 4 has an entry of "Pass"

    

When I trigger the flow to up date the SharePoint list it does not fill in question number 4. Question number 4 is missing on the list?

Here is the part of the flow that is creating the new entry on the SharePoint list for some reason it leaves out column number 4?  Any Ideas?  Thank you

Eric

[abm]

Hi @eric142 

First of all two things to verify.

1. Check the dynamic mapping is correct?

2. Check the run history of the flow and check what value is returned for the missing update column 4?

Generally run history reveals whether user has entered any value or not? Is this field is mandatory in Form? Can form return a blank value if not mandatory and not filled by the user?

Thanks

Thanks

[eric142]

Thank you for the reply.

Here is a screen shot of the history and it looks like column 4 is not even included.  It jumps from 3 to 5.

Here is a peek at the code for creating the new list item.  It looks the same as the code for other columns, but I don't real understand what I am looking at. Here is the code for 3,4,5 &6.

The information is not required put I will test it with it being required.  But the fact that it shows up in the spreadsheet and not the list is curious.  An automated flow first adds it to the excel spreadsheet then I manual trigger the flow to update the list if that is helpful.  Making it required did not help.

Thank you,

Eric

[eric142]

I just noticed something, there are more then one column that is not getting filed in and each one that does not get filled in has a "/" in the name of the column.  Is it possible this is a no-no when writing to a list??  But appears to be okay when writhing to a excel spreadsheet.  I will try and test it out, but what a mess this might be.  😞

Eric

[eric142 · Accepted solution]

@abm 

That was the issue, you can't have a / in the name of a column on a list or it will skip over it.  After removing it now populates those columns on my list.

Thank you,

Eric

[abm]

Hi @eric142 

Thanks for the sample data. So the issue is its not returning column 4 values. Thats the reason its is not mapping. It could be the response numbering is not quite right from Forms. Check each question and answer? It could be the response 5 is the fourth one. 

Thanks

[abm]

Hi @eric142 

I am not sure what you meant by? Here is my list which contains '/' in the name.

[eric142]

@abm

The column header contained a /   in your example it would be  Sports/Team  Name/Sex as header names. Once I removed the / from the column header the data would populate correctly.  Did that help?