Formula Issue when using collection

[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

[timl · Accepted solution]

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?

[BenGillard · Accepted solution]

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

---

---