Answered

SharePoint list column not populated when creating items from Excel

(1) Share

Report

Posted on by FL-19021510-0

I'm trying to create a list from an Excel. I've used 'List items present in a table' and used 'Apply to each' and 'Create item' within to create the list. Now I have 6 columns.

5 out of the 6 columns have the data populated without issue. But one of the columns just remains blank no matter what I do. I've checked the inputs and outputs of the nodes and the data is getting passed through.

In the create item 'Output' even shows the correct data being passed through the right parameter. But that column in the list just remains blank. I've tried recreating the list from scratch, changing column names and everything but to no avail.

I have the same question (0)

All responses (4)

Answers (1)

Sort by

MS.Ragavendar 7,431 Super User 2026 Season 1 on at

Like
a
(3)

Report
Copy link

Link copied!

@FL-19021510-0,

Can you please specify the schema details in the backend and share the flow run history and create item screenshot.

We need the column mapping so that we can propose the solution please share the necessary insights.

✅If this helped, please Accept as Solution to help others ❤️ A Like is appreciated 🏷️ Tag @MS.Ragavendar for follow-ups.

Was this reply helpful? Yes No
FL-19021510-0 26 on at

Like
a
(1)

Report
Copy link

Link copied!

@MS.Ragavendar

Please let me know if this information is sufficient. I've had to block out some personal information, but its only item/TULCB thats having issues, the rest work fine.

Column Name: TULCB

Type of information: Single line of text

Required: No

Enforce unique values: No

Was this reply helpful? Yes No
Suggested answer

MS.Ragavendar 7,431 Super User 2026 Season 1 on at

Like
a
(3)

Report
Copy link

Link copied!
@FL-19021510-0,

I have never faced like this issue in the past when create item is green but values are not getting saved in the backend.

We check the below approaches.

Please check the backend schema / List Settings are we mapped the right columns and looking the right column?

If the version history is enabled check for only 1 items how the values are getting created.

You can also try with Send An Http Request to sharepoint, this will provide when Create item silently fails on a single column.

Sample Http : https://tomriha.com/create-item-with-lookup-column-in-a-dynamic-list-power-automate/

Delete the Create Item action and save the flow.

Now re-add the connector back and map the relevant columns accordingly and test it.

Please check and revert me.

✅If this helped, please Accept as Solution to help others ❤️ A Like is appreciated 🏷️ Tag @MS.Ragavendar for follow-ups.

Was this reply helpful? Yes No
Verified answer

Valantis 6,735 on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @FL-19021510-0,

Check this pelase: the internal column name might differ from the display name.

SharePoint stores columns with an internal name that gets set when the column is first created and can't be changed even if you rename the display name later. If the column was created with a different name and then renamed to TULCB, the Create item action might be mapping to a field that no longer matches the internal name, causing the value to silently be ignored.

To check: go to SharePoint List Settings > click on the TULCB column > look at the URL. The internal name is in the URL parameter Field=. Compare that to what the Create item action is actually calling.

If they don't match, the quickest fix is to delete the column, create a new one directly named TULCB from scratch (not renamed), delete the Create item action, re-add it, and remap all fields. This forces the connector to pick up the correct internal name.

Best regards,

Valantis

✅ If this helped solve your issue, please Accept as Solution so others can find it quickly.

❤️ If it didn’t fully solve it but was still useful, please click “Yes” on “Was this reply helpful?” or leave a Like :).

🏷️ For follow-ups @Valantis.

📝 https://valantisond365.com/

💼 LinkedIn

▶️ YouTube

Was this reply helpful? Yes No