Display doc library folder that matches name of list item

[sudosaurus]

Hello,

I have posted in another thread however had stopped getting responses and still need assistance with this if possible.

So the main SharePoint list has a column called "Contract Ref"

When an item is created, there is a Power Automate workflow that creates a folder in the "Contract Documents" document library named with the same value as the "Contract Ref" column in the list. The folder column is called "Name" (default).

Documents are manually added to this folder in the document library.

So when I open the list item named "LWCM-09-06-2020-10", I am expecting these documents to display in the Power Apps form.

I have therefore changed the 'Items' code to the below however I am not seeing any files displayed in the form 

[sudosaurus]

So the main SharePoint list has a column called "Contract Ref"

When an item is created, there is a Power Automate workflow that creates a folder in the "Contract Documents" document library named with the same value as the "Contract Ref" column in the list. The folder column is called "Name" (default).

Documents are manually added to this folder in the document library.

So when I open the list item named "LWCM-09-06-2020-10", I am expecting these documents to display in the Power Apps form.

I have therefore changed the 'Items' code to the below however I am not seeing any files displayed in the form 

[sudosaurus]

[sudosaurus]

@Mira_Ghaly tried both of these - can't seem to work out what I'm doing wrong.

Can you share screenshots of your setup to see if I can piece things together?

[Mira_Ghaly]

@sudosaurus 

Can you please show me your latest setup?

my library url :

my sharepoint list name:

Specific folder in this document library

Orange: Document Library Name

Red: library name as it exactly in URL

Green: Your folder Name

If this post helps you with your problem, please mark your as Accepted solution.

If you like my response, please give it a Thumbs Up.

MG (Naturally Curious)

[sudosaurus]

Hello @Mira_Ghaly 

my library url : /Contract%20Documents/Forms/AllItems.aspx

my sharepoint list name:

Specific folder in this document library:
This is tricky as I want a different folder to be displayed where the folder name matches the same as the title/contract ref column in my list.

[Mira_Ghaly]

@sudosaurus

TTo make sure I understand correct you have a list Register and Document library contract documents and these are 2 datasources, so your gallery connects to the Register List? I am not sure how you are structuring your app can you share some screenshots please

[sudosaurus]

Screenshots below - hope this makes sense?

This is my SharePoint list which is named "Register".

This is my "Contract Documents" document library.

This is the file structure inside the folder "LWCM-09-06-2020-10":

This is my PowerApp form (when clicked on an item in the list):
*Documents in the corresponding sub-folder of the document library should appear in the grey "Contract Documents" box on the right. This is when the "Contract Ref" field in the list matches the same name from the "Name" column in the "Contract Documents" document library.

[Mira_Ghaly]

@sudosaurus 

So on Select for the Register list 

Set(newVariable,ThisItem.ContractRef)

On the other Gallery where the folder structure needs to be displayed and i suppose this is another Gallery

Filter('Contract Documents','Folder path'="Contract%20Documents/"&myVariable&"/")

If this post helps you with your problem, please mark your as Accepted solution.

If you like my response, please give it a Thumbs Up.

MG (Naturally Curious)

[sudosaurus]

Hi @Mira_Ghaly 

I only have the one gallery which serves up the list of documents in the folder.

When you click on a list item in sharepoint it brings up the PowerApps form displaying the column data for that list item rather than browsing the list items in a gallery on PowerApps.

Therefore I cannot use "Set(newVariable,ThisItem.ContractRef)" in a gallery that doesnt exist and this command needs to somehow work in the gallery on the right of the form.

[Mira_Ghaly]

@sudosaurus 

Ok Great

Please try the below

Filter('Contract Documents','Folder path'="Contract%20Documents/"&SharePointIntegration.Selected.Contract Ref&"/")

If this post helps you with your problem, please mark your as Accepted solution.

If you like my response, please give it a Thumbs Up.

MG (Naturally Curious)

[sudosaurus]

@Mira_Ghaly 

Assuming this is on the "Items" selector? As I've changed this and no change after refreshing.

Also just to check, on the document library, the column for the folder name is named "Name" - is this OK and does this not need to be in the Filter info? 

[Mira_Ghaly]

@sudosaurus 

yes it is on the Items

Make sure your when you press SharepointIntegration.Selected. it shows the correct property