cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Anonymous
Not applicable

Get parents from Sharepoint list

Good morning, everybody Smiley Happy,

I have a list and a library.
My library contains the parents and my list contains the children.
Each parent can have several children, so I try to fill in a "parents" column in my list.

 

Here is the real example : 

FLOW.png

My flow :

flow2.png

Condition:

@contains(body('Get_file_2_properties')?['Action']?['Value'], items('foreach')?['Title']) 

2 REPLIES 2
Highlighted
Community Support
Community Support

Re: Get parents from Sharepoint list

Hi @BenjaminSTRIEBI,

 

Which date type is the ElementOfList column in your SharePoint library?

Could you please show a bit more about Action Value within your Condition box?

Further, have you tested your flow in Microsoft Flow already?

 

I don’t think your flow could achieve your needs, the “Update item” action would overwrite previous value in Parents column of your SharePoint list. I have created a SharePoint Library and a SharePoint list on my side:10.JPGNote: ElementOfList column is a Multiple line of text type.12.JPG

Note: Parents column is a Multiple line of text type.

 

I have made a test on my side and the flow works well. My flow’s configuration as below:7.JPG

 

8.JPG

Note: Within Parents field, we should type dynamic Name content of “Get file properties” action and type dynamic Parents content of “Get items” action in next line (Maybe this item has a parent item in Parents field already, avoid updating previous parent item ).

 

The flow works successfully as below:9.JPG

 

11.JPG

 

Best regards,

Kris

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
Anonymous
Not applicable

Re: Get parents from Sharepoint list

Hi @v-xida-msft,

Thanks for your help ! Smiley Happy

 

I use the "Look Up" type for "ElementOfList" column.

Your example works but has bugs. For me at least.

 

For example: if I use the SharePoint tool "Quick modification" the flow only takes into account the last line of modification:

flowalexander.png

 

Best regards,

Ben

Helpful resources

Announcements
firstImage

Super User Program Update

Three Super User rank tiers have been launched!

firstImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

Top Solution Authors
Top Kudoed Authors
Users online (6,290)