Answered

Edit a item from a Gallery, problem with sort and search

(0) Share

Report

Posted on by RoberthCB

I have a gallery that reads data from a Sharepoint list named Company, if in Items I only put Company, it allows me to edit in the respective form, but when I include a statement that has sort and search like this in Item:

Sort(Search(AddColumns(Company,"City",City,"Count",Country),ScrCompaySearch.Text,"NameCompany","City","Count"),NameCompany,SortOrder.Ascending)

I can't edit the item and it even gives me an error in the editing form in item: alCompanys.Selected

How can you correct it so that it allows sort and search and can it allow editing of the selected record?

Tahks for the help

Categories:

Using Apps Using Formulas

All responses (2)

Answers (1)

Verified answer

RoberthCB on at

Like (1)

Report

Re: Edit a item from a Gallery, problem with sort and search

Thanks a lot by the help, i fund the answer in this link: Edit a item from a Gallery, problem with sort and ... - Power Platform Community (microsoft.com)
OdinDelToro 407 on at

Like (0)

Report

Re: Edit a item from a Gallery, problem with sort and search

Hello RobertCB,

You can try using SortByColumns instead of Sort.

SortByColumns(Search(AddColumns(Company,"City",City,"Count",Country),ScrCompaySearch.Text,"NameCompany","City","Count"),"NameCompany",SortOrder.Ascending)

Hope this helps clarify the doubt, let me know in case you're still facing an issue within it.
Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.