Answered

Filtering a document library gallery based on title in a collection

(0) Share

Report

Posted on by caitlink

I've figured out how to get results from the Sharepoint's Search REST API into my powerapp. To do so I create a collection for the returned document titles from the search. What I can't figure out is how to filter my gallery based on the Title column in the collection.

In the Items for the gallery I have Filter(DocLibrary, Title in _apiResults.Title)

Then in onChange for the text input search box, I have ClearCollect(_apiResults,SPSearchAPI.Run(tbSearchInput.Text))

SPSearchAPI is the Flow that does the http get request, then parses the data and returns just the titles that returned in the search.

When I type in a search term, I do get results, but they don't match all of the results in the collection. Some do, but some don't. For instance, for one search the collection has two results, but only one is displayed in the gallery. Can anybody help?

Thank you!

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (1)

StalinPonnusamy Super User 2024 Season 1 on at

Like (0)

Report
Hi @caitlink

Does the search through Power Automate is accurate? It means is it searches Startswith or contains?
Filter the gallery based on the search results
I suggest verifying the SharePoint API search? Can you Share your search term on the search?

Thanks,
Stalin - Learn To Illuminate

Was this reply helpful? Yes No
caitlink 58 on at

Like (0)

Report

Thanks for your reply! Here's the Flow I'm using.

It passes the Titles back to the Collection just fine. So for example, if two items are passed back through the Flow, the collection contains those two titles. However, only one of the two items displays in the gallery. I'm wondering if maybe it has to do with the actual naming - some of the titles contain spaces, and others don't. Maybe it would be better to pass back something else, like the UniqueID or DocID.

Was this reply helpful? Yes No
StalinPonnusamy Super User 2024 Season 1 on at

Like (0)

Report
Hi @caitlink

To further troubleshoot, Insert another gallery and set the Items property to
_apiResults

to compare the titles.

With({Item:DocLibrary}, Filter(Item, Title in _apiResults.Title) )

Was this reply helpful? Yes No
Verified answer

StalinPonnusamy Super User 2024 Season 1 on at

Like (0)

Report

Hi @caitlink

I tested with mockup collection and works

Note: With my Datasource, I used Name.

Thanks,
Stalin - Learn To Illuminate

Was this reply helpful? Yes No
caitlink 58 on at

Like (0)

Report

Thanks for your help. It doesn't work. The items showing in the gallery are not the same as the items returned to the collection. In some cases it's just missing some items, in other cases it shows nothing at all, and in still other cases it shows some items that are in the collection and items that aren't in the collection.

Was this reply helpful? Yes No
caitlink 58 on at

Like (0)

Report

I figured out the issue! It had to do with having a Title value in addition to a Name value. When I removed all the titles (leaving only Name), it works fine. Your comment helped, thanks!

Was this reply helpful? Yes No