cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Roberto_el_Hajj
Helper II
Helper II

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

Hello,

 
Hope you're doing well!

 

Problem:

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:  
 
Inputs 
Commands 
Tenants 
 

 

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

 

What I used:

Roberto_el_Hajj_0-1634564600416.png

 

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

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Solution Authors
Top Kudoed Authors
Users online (1,214)