Conditional - if data in column a (excel) already exists in corresponding column on a sharepoint do not create item on that sharepoint

(0) Share

Report

Posted on by Meatabear

Hi all,

Have a flow that uploads data from an excel table to a sharepoint.

Relatively new user, and could really use some help with how to check if a list of variable numbers exist (in excel) exist in sharepoint. If they do dont create a row in the sharepoint for each row in excel, if they don't exist already - create row.

I've looked at check if item exists but can't seem to make it work and unable to use the simple route of enforcing unique data at the sharepoint level (as the data is split and before it branches off with a condition it uploads a type with matching info in the same column - where we wouldn't then want to upload the version of the data in the later branch.)

I'd be very grateful for any help, thanks.

Categories:

Building flows

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

v-alzhan-msft on at

Like (0)

Report
Hi @Meatabear ,

How would you trigger the flow?

Could you please share a screenshot of the excel table and the sharepoint list?

Does the excel table has a column that have corresponding column in the sharepoint list?

Please share more details so we could better understand your issue and provided the proper solution.

And you could also take a try to refer to my screenshot below to create the flow:

Expression in the Condition:

length(body('Filter_array'))

Best regards,

Alice

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No