web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Getting Dropdown list ...

Power Apps

Answered

Getting Dropdown list to display Folder Names using Filter Function on SharePoint Folder Data.

(0) Share

Report

Report

Posted on by Tamlerloveskant

21

Hi,

I currently have a dropdown list that i want to display all of my Project Folder Name

from a SharePoint list that I want the user to select from;

I Have used the following Filter Function to retrieve the right data (it seems):

Filter(Documents, 'Folder path'= "Shared Documents/Current Projects/");

Dropdown List Project.png

But my Dropdown Fields, whilst displaying the right number of dropdowns, are Blank Fields;

Projects Dropdown Field.png

The text i wish to Display is either 'Name' or 'filenamewithextension' for selection.

if anyone has any ideas on how i get this information into the dropdown fields it would be greatly appreciated.

Kind Regards,

James

Dropdown List Project.png

Projects Dropdown Field.png

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (4)

Answers Img

Answers (1)

Sort by

Verified answer

Pstork1 69,226 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!
Change the Value property to 'Name'.

Then use the following for your filter statement

Filter(Documents, 'Folder path'= "Shared Documents/Current Projects/" && IsFolder=true)

Was this reply helpful? Yes No
Tamlerloveskant 21 on at

Like (0)

Report
Copy link

Link copied!

Hi @Pstork1
Thankyou so much for your response,
For some reason, the 'Value' Field is locked to 'Compliance Asset ID' and cannot be changed. (see attached image).

is there any reason this is locked for me?

Kind regards,
James

Was this reply helpful? Yes No
Tamlerloveskant 21 on at

Like (0)

Report
Copy link

Link copied!

Hi @Pstork1

Apologies, i Resolved this,
for others who may read this,
My solution was as follows: (although im sure theres a more elegant way to do it)
1. I Deleted my Filter Formula From 'Item'
2. I selected 'Documents' Data Source in Item
3. I Chose 'Name' In Value.
4. I then Copied @Pstork1 above formula.

Thanks so much for your help again!

Was this reply helpful? Yes No
Pstork1 69,226 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

The value field is locked because you have a custom filter function in the Items property. You have to pick Name before you add the filter.

Was this reply helpful? Yes No

Join the conversation