How to Apply a PowerApps Filter to Display JSON Files From a SharePoint Document Library

Learn how to filter out JSON file names from a SharePoint Document Library in PowerApps using effective techniques.
---
This video is based on the question https://stackoverflow.com/q/68662378/ asked by the user 'psobhan' ( https://stackoverflow.com/u/662198/ ) and on the answer https://stackoverflow.com/a/68679735/ provided by the user 'psobhan' ( https://stackoverflow.com/u/662198/ ) at 'Stack Overflow' website. Thanks to these great users and Stackexchange community for their contributions.

Visit these links for original content and any more details, such as alternate solutions, latest updates/developments on topic, comments, revision history etc. For example, the original title of the Question was: I need to apply a filter in powerapps to display json files (name) as lookup in other list from document library in Sharepoint

Also, Content (except music) licensed under CC BY-SA https://meta.stackexchange.com/help/licensing
The original Question post is licensed under the 'CC BY-SA 4.0' ( https://creativecommons.org/licenses/by-sa/4.0/ ) license, and the original Answer post is licensed under the 'CC BY-SA 4.0' ( https://creativecommons.org/licenses/by-sa/4.0/ ) license.

If anything seems off to you, please feel free to write me at vlogize [AT] gmail [DOT] com.
---
How to Apply a PowerApps Filter to Display JSON Files From a SharePoint Document Library

Managing files in a SharePoint document library can sometimes feel like navigating a labyrinth, especially when you are only interested in specific file types, such as JSON files. If you're trying to create a PowerApps application that displays only JSON file names from a document library, you might have run into some challenges. This guide will guide you through the steps to effectively filter out folders and irrelevant file types, ensuring you only get the JSON file names you need.

Understanding the Challenge

You have a document library set up in SharePoint with multiple folders containing various files. Your goal is to display only the names of JSON files (A1Json, A2Json, A3Json, etc.) in another list, filtering out any files located specifically within a "Files Folder" subdirectory.

Example Structure

To clarify the context, here’s how your document library is structured:

Folder1

A1Json

Files Folder

F1Json

Folder2

A2Json

Files Folder

F2Json

Folder3

A3Json

Files Folder

F3Json

You only want to include the above files (A1Json, A2Json, A3Json) in your PowerApps dropdown or lookup without the clutter of other files.

Solution: Utilizing PowerApps Filter Functions

To achieve your goal, you'll need to apply a filter within PowerApps that identifies the JSON files while excluding folders and specific unnecessary paths.

Step-by-Step Instructions

Set Up Your Data Connection:
Before applying filters, ensure you have connected your PowerApps application to the SharePoint document library containing your files.

Consider the Filter Logic:
The filtering approach aims to:

Exclude folders by checking if IsFolder is false.

Exclude any files under the "Files Folder".

Filter specifically for .json file extensions.

Implement the Filtering Expression:
You can use the following PowerApps formula to apply the necessary filters:

[[See Video to Reveal this Text or Code Snippet]]

Breaking Down the Formula

Filter('Documents', ...): This part specifies the data source you want to filter.

IsFolder = false: Ensures that only files (not folders) are included in the results.

Not("Files/" in 'Full Path'): Excludes any files that belong to folders with the name "Files".

EndsWith('File name with extension', "json"): Filters the remaining files to include only those that end with .json, which effectively selects your desired file types.

.Name: This retrieves the names of the files that meet all of the filter conditions.

Conclusion

By following the instructions above, you should be able to successfully filter and display only the JSON file names from your SharePoint document library in PowerApps. This approach not only cleans up your data display but also enhances the user experience by eliminating unwanted distractions.

If you have any further questions or need additional assistance, feel free to drop a comment below. Happy PowerApping!

Видео How to Apply a PowerApps Filter to Display JSON Files From a SharePoint Document Library канала vlogize