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
Community Support Team
Community Support Team

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.
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

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

Power Platform 2019 Release Wave 2 Plan

Power Platform 2019 Release Wave 2 Plan

Features releasing from October 2019 through March 2020.

thirdimage

Flow Community User Group Member Badge

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

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Flow Community Video Gallery!

Top Kudoed Authors
Users Online
Currently online: 319 members 4,258 guests
Recent signins:
Please welcome our newest community members: