Sep 18 2019 01:55 PM
Sep 18 2019 01:55 PM
I have a SP document library with files and folders. I can setup a dropdown menu in PowerApps that will display all files in document library. Unfortunately it also includes folder names. How do I filter out the folder names so only file names will appear?
Sep 19 2019 12:13 PM
Sep 19 2019 12:13 PM
Any ideas will be greatly appreciated.
Sep 20 2019 06:18 AM
Hi @Deleted
I have not tested this in PowerApps (sorry, I don't have time just now), but in other applications (such as content rollup) when I need to filter out folder names, I apply a filter where Content Type is NOT Folder.
Are you able to do that in this scenario?
Sandy
Sep 20 2019 06:58 AM - edited Sep 20 2019 07:00 AM
@Sandy Ussia Thanks for the response Sandy! In the dropdown menu's "Items" property, I had just the name of the SPO List. To filter out folder names from appearing, I used the following code:
Filter('SPO LIST NAME', !IsFolder)
This worked! I do get a yellow warning icon indicating "Delegation warning. The highlighted part of this formula might not work correctly with "IsFolder" on large data sets."
One other question - How do I add a "Please Select a File" as the default item in my dropdown menu?