Uploading only unique rows from Excel to SharePoint list

(0) Share

Report

Posted on by Egemeny

Hi everyone,

I have a flow used to work properly, however I'm having challenges recently and i need your help.

This flow helps HR Team to upload new starters within the business from excel table to SharePoint as a list item.

Here expectation is for flow to look for only unique names and upload them to the SharePoint. (in order to avoid multiple list items).

This use to work but now everyday we can see same people created as a SharePoint list item. You can see the flow structure below, what is the problem?

Really appreciate your help.

Categories:

General topics

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

efialttes 14,756 on at

Like (1)

Report
Copy link

Link copied!

@Egemeny

How many elements do you currently store on your sharepoint list? Something similar happened to me some time ago, it seems action 'get ítems' by default gets the first 100 elements, and it took me sometime to realize I surpassed the limit. If this is your problema you can increase it by setting a higher Value in 'Top Count' input

Hope this helps

Was this reply helpful? Yes No
Egemeny 15 on at

Like (0)

Report
Copy link

Link copied!

Hi @efialttes ,

Fantastic! Thank you very much!
I have more than 100 and it seems that was the problem.

Was this reply helpful? Yes No