Answered

Flow with 'List Rows Present in Table'. When mapped to either create Item or add row, values changing and not working.

(0) Share

Report

Posted on by JamFestival

113

Hi,
I have a manually-triggered flow to populate a SharePoint list from a Microsoft Forms excel export.
I have also tried this with adding a row to an Excel table and having the exact same issue.

The issue is, in my 'Apply to each', beneath a 'List rows present in a table', I add either 'Create Item' or 'Add a row into a table', and when I map the fields from the source Excel table from Forms, most of the fields work as expected but three of them, when the Flow is saved it changes three of the mapped to '1_x002e_2.....', '2_x002e_1.....' and '3_x002e_2...', and when run, omits those fields. The Flow thinks it's run successfully, but there's data missing.

Has anyone else encountered this?

Categories:

General topics

I have the same question (0)

All responses (4)

Answers (1)

RobElliott 10,325 Super User 2025 Season 2 on at

Like (0)

Report

The _x002e_ means there is a dot in the column name in your table. I would look at removing that. What is the data in those 3 columns?

Rob
Los Gallardos

Was this reply helpful? Yes No
JamFestival 113 on at

Like (0)

Report

It's just a text string.

Was this reply helpful? Yes No
JamFestival 113 on at

Like (0)

Report

I have checked, and ALL of the column names have a dot, but it's just three that don't work

Was this reply helpful? Yes No
Verified answer

JamFestival 113 on at

Like (0)

Report

I have ended up simplifying the target, which resolved the issue.
So, surmise that the underlying issue wasn't with the fields defined in the JSON, but PowerAutomate unable to match like-for-like the field names that contained punctuation. I suspect, in this case, it was forward slashes in the MS Form questions.

Was this reply helpful? Yes No