Answered

Formula Issue when using collection

(0) Share

Report

Posted on by BenGillard

Hi,

I am having issues with this formula below, this gives me and error and no results.

If(!IsBlank(SearchMain.Text),SortByColumns(Search(Collection3,SearchMain.Text,"Description","KeyWords","Title"),"{Name}",Ascending)) - Error

It works perfectly when i use the Sharepoint list directly instead of the collection but i wanted to overcome the delegation warning by using the collection.

If(!IsBlank(SearchMain.Text),SortByColumns(Search(All_Resources,SearchMain.Text,"Description","KeyWords","Title"),"{Name}",Ascending)) - Works

Please Help

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (2)

Sort by

Verified answer

timl 37,160 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hi @BenGillard

What error do you get when you run the formula against your collection? Do the column names in Collection3 match the column names in your All_Resources SharePoint list?

Was this reply helpful? Yes No
Verified answer

BenGillard on at

Like (1)

Report
Copy link

Link copied!

Thanks for your reply!
It seems all i needed to do was close the app and reopen it for the collection to work and appear.
Thanks

Was this reply helpful? Yes No