Text not displayed in dropdown (sharepoint data is record)

(0) Share

Report

Posted on by JoeG1

Pulling from a Sharepoint that is setup with subfolders (not setup by me).

'Component' column in Sharepoint db is a single choice selection.

Dropdown1 Items: Distinct(Filter('OEM','Folder path' = Dropdown21.Selected.Result).'Component','Component').Result

I can use the Filter function and it does populate the dropdown with the correct numbers of options but they are all blank. If I setup a Label to display the item selected in Dropdown1, the result it displays in the Label for whatever i select in the dropdown. I can select the any of the blank 'data' and it displays the text in the label but they are blank in the dropdown. Tried combobox too and the same.

One workaround I did for another part was to setup a data table and 'Concat' the columns that wouldn't display that were both single choice selection and multi choice selection in the Sharepoint db.

The Choices function would more ideal, but can't get it to filter based on a folder path as all the subfolders contain the same column name.

Parent is: Manu

2 subfolder: BWM and MB

In the BWM, column 'Series' data is

In BMW, column 'Series' data is

So if I use the Choices(Manu.Series) it displays all the data in the 'Series' column for both BWM and MB. I just want it to display BWM or MB (depending on the user selection of DropdownManu)

DropdownManu item: Filter(Manu, isfolder = true).Title

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

WarrenBelz 154,447 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hi @JoeG1 ,

I just did a test on this end on a small document library using your syntax in a second dropdown

Distinct( Filter( 'OEM', 'Folder path' = Dropdown21.Selected.Result ).'Component', 'Component' ).Result

and got the expected list in it however 'Folder Path' is not Delegable and on larger lists, you will either get an incomplete result, or it may possibly not work.

My general workaround (I have some very large libraries) is to put the folder structure (you can do multiple levels) in fields in the Library metadata and it all becomes not only Delegable in Power Apps, but you can do some effective Grouped views in SharePoint.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No
JoeG1 13 on at

Like (0)

Report
Copy link

Link copied!

Unfortunately, I am not the owner of the sharepoint DBs but might be able to do that.
The other DB that is large has about 300 rows. The other one's are 100 rows or less and it doesn't work on them as well.

I kind of got a partial workaround that is not ideal but can make it work.
dropdown to select first filter value.
dropdown2 to select second filter value.
load SP into a data table and filter the table using the above filter options. Note that I have to use the Concat(ThisItem.dataincolumn,Value,", ") to display the data.
then user can select from the data table.

Was this reply helpful? Yes No