Showing results for 
Search instead for 
Did you mean: 
Super User
Super User

Get a column value depending on the selected Parent folder in the sub folder


Hope you're doing well!



I would like check if the value of a field from a Parent folder "A1 or A2 or A3" existing in SharePoint is null or not, in case the user uploaded a file on SharePoint in a sub-folder "a2".


Expected result:

I except when a user uploads a file in the sub-folder of any of the Parent folders, I would get the value its specific field.

For a clearer explanation you can find my SharePoint List Below,
My Parent Library
Parent folderProject Manager
A1Jhon Doe
A2Chris Jonson
A3Charlotte Kambel
My Sub Library:  


And finally the library where the user uploads his file and the flow is triggered.


What I used:



What's the best practice function to use to achieve the above result?
Any help will be highly appreciated.
Thank you!

Helpful resources

Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Difinity Conference 2022

Difinity Conference 2022

Register today for two amazing days of learning, featuring intensive learning sessions across multiple tracks, led by engaging and dynamic experts.

European SharePoint Conference

European SharePoint Conference

The European SharePoint Conference returns live and in-person November 28-December 1 with 4 Microsoft Keynotes, 9 Tutorials, and 120 Sessions.

Users online (4,434)