Populating Dropdown With Files From Doc Library AND Filter Per a SharePoint List?

[Anonymous]

I have a working Power App that I am looking to add functionality.  One screen features a dropdown menu populated from a SP document library that filters out folder names. That is working. I want to further filter the files in the dropdown to be limited to the files assigned to logged in user per a SP list. So the goal is to limit the dropdown menu files to match the number of files assigned to the logged in user as shown in the image below. Is this possible? Any additional information will be appreciated.

Power App GUI With Overlays Explaining Data Sources and FilteringSP List Columns (File & Email relevant to discussion)

[Anonymous]

Does anyone know if this is possible? Please advise.

[v-xida-msft]

Hi @Anonymous ,

Could you please share a bit more about your scenario?

Could you please show more more details about the "File" column in your 'Red-Team-Reviewer' List? Do you use it to store the file name assigned to specific user?

If you use the "File" column in your 'Red-Team-Reviewer' List to store the file name assigned to specific use, please consider take a try with the following workaround:

Please set the Items property of the "File Name" Dropdown box to following:

Filter(
       'Finalized Files', 
        IsFolder = false,
       'File name with extension' in Filter('Red-Team-Reviewers', Email = User().Email).File
)

Please consider take a try with above solution, then check if the issue is solved.

Best regards,

[Anonymous]

@v-xida-msft - Thank you for your response!  The "File" column in my 'Red-Team-Reviewer' List stores the file name and email address to associate a file with a specific user.  The files dropdown menu is simply populated from a document library. 

Regarding your workaround to the the Items property of the "File Name" Dropdown box, the goal is to limit the files to match the number of files assigned to the logged in user so in my example, the user has three files assigned per the SP list. Therefore, the dropdown menu should only contain three files (those listed in the SP list assigned to the logged in user).

So I am confused why you have: 'File name with extension' in your formula. There is no specific file name with extension, it should just be the files in the SP list assigned to the logged in user per the SP List (3 files in this example). How would that modify your formula? 

Filter(
       'Finalized Files', 
        IsFolder = false,
       'File name with extension' in Filter('Red-Team-Reviewers', Email = User().Email).File
)

 
Any recommendations are greatly appreciated!

[v-xida-msft · Accepted solution]

Hi @Anonymous ,

Based on the issue that you mentioned, I think you have some misunderstanding with the 'File name with extension' column. The 'File name with extension' column is actually a System column from a SP Library rather than SP List.

In other words, the 'File name with extension' column is from your 'Finalized Files' SP Library rather than your 'Red-Team-Reviewers' SP List. When you store the files in your SP Library, you could display the file name (including file extension) via the 'File name with extension' column as below:

Note: The  'File name with extension' column is a System column in SP Library.

The 'File name with extension' column would be acted as a filter column in above formula, which is used to filter these files has been assigned to current user. 

Based on the needs that you mentioned, I think the solution I provided above could achieve your needs. Please consider take a try with it, then check if the issue is solved.

Best regards,

[Anonymous]

@v-xida-msft - That was the solution! Thanks again for taking the time to detail the fix!

[Anonymous]

@v-xida-msft - One last question. I though the files would sort ascending by default, but they didn't. Therefore, I added a Sort function:

Sort(
 Filter(
    'Finalized Files', 
    IsFolder = false,
    'File name with extension' in Filter('Red-Team-Reviewers', Email = User().Email).File
 ), "File", Ascending
)

The file names still did not sort in ascending file name order like I expected when using the code shown above. Any recommendations?