Unanswered

How to use batch create item in sharepoint list ?

(0) Share

Report

Posted on by Yi66

I'm using paul's template for batch create item in sp list from excel file, download the replace with my data. But there is not item generated even if flow run succssfully.

Link of the template: https://tachytelic.net/2021/06/power-automate-flow-batch-create-sharepoint-list-items/#comment-319390

My flow run through too fast in just couple secs, but I have more than 20K data

An screenshot of my flow below:

Any help?

Categories:

Building flows

I have the same question (0)

All responses (20)

Answers (0)

takolota1 4,974 Moderator on at

Like (0)

Report

@Yi66

Could you please send pictures of run results from one of the bottom 2 actions. The SendBatch or Results action outputs.

Was this reply helpful? Yes No
Yi66 58 on at

Like (0)

Report

this one on the right is for send batch result when i hit download , the one below is the result's result when I hit download.

Was this reply helpful? Yes No
takolota1 4,974 Moderator on at

Like (0)

Report

@Yi66

Yes, it’s giving a bad request error for every line there.

What columns in the SP list are you trying to send to? (Preferably you can also mention their datatypes if it isn’t obvious)

And what do your inputs look like in the GenerateSPData action?

Was this reply helpful? Yes No
Yi66 58 on at

Like (0)

Report

there are the columns then I try to send from input to output. And I do not see where (which step) you can edit their datatypes ?

Was this reply helpful? Yes No
Yi66 58 on at

Like (0)

Report

Director, PM, Department are all single line string value in SP line within my input.

Was this reply helpful? Yes No
takolota1 4,974 Moderator on at

Like (1)

Report

@Yi66

At any point did you change the column names in SP?
SharePoint will keep the 1st name you give a column on the back-end, so if you change it, you still have to use the 1st name given to the column in these actions.

Was this reply helpful? Yes No
Yi66 58 on at

Like (0)

Report

no, i don't think so. is something wrong in the flow as my parameters, which step is most likely cost the problem?

Was this reply helpful? Yes No
Yi66 58 on at

Like (0)

Report

I might changed other column's name, but not those three columns, those are the most straight forward string value column I have

Was this reply helpful? Yes No
takolota1 4,974 Moderator on at

Like (0)

Report

@Yi66

Why does the note on the settings say “List to batch delete items from”

Is that a typo in the batch create template, or did you copy the batch delete template & rename stuff?

Was this reply helpful? Yes No
Yi66 58 on at

Like (0)

Report

where it is that notes? I did not see that notes ? And why this matter to us?

Was this reply helpful? Yes No