Unanswered

Create Table, then add row items into SharePoint List

(1) Share

Report

Posted on by nealkal

Hello Power Automate Pros

I'm looking to have Power Automate create a Table (from a new Master File that gets auto generated from a separate weekly process), then take that table and populate my SharePoint list. Column names will always be the same, but the data will change.

My original effort was Create Table > List rows present in Table > Apply to each > Create Item

This completed successfully but created empty rows in my SharePoint List.

I'm wondering if I first need to Parse JSON the Table values and then apply to SharePoint but I'm not sure how that would look or what formula's I'd need. Looking for direction. Thank you!

Categories:

AI Builder

2024-08-02_13-52-...

I have the same question (0)

All responses (4)

Answers (0)

Nived_Nambiar 18,129 Super User 2025 Season 2 on at

Like (1)

Report

Hi,

i could not view the screenshot attached with this post ?

could you make it enabled ?

Was this reply helpful? Yes No
nealkal 8 on at

Like (1)

Report

Was this reply helpful? Yes No
Nived_Nambiar on at

Like (1)

Report
Hi,

Few things to ask

Did you checked whether the list rows in table 's output has some value after flow runs ?- to verify use compose action to check any column values for each row before adding SP List ?

There is no need to apply parse json for value dynamic content.

Was this reply helpful? Yes No
nealkal 8 on at

Like (2)

Report

Nived

Thank you for the tip. It does have output, but it seemed to have renamed the Column headings. For example, I had 'Company:' for the one of the headings and the output shows as 'Company_x003a_'. When I took that output and added it to the Apply to Each, Create Item, it is now populating the list.

items('Apply_to_each_row')?['Company_x003a_']

I will do this for the other columns.

Was this reply helpful? Yes No