cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
dalacarelia_196
Post Patron
Post Patron

Losing the recordset

Hello out there

I am using search in my gallery , it works fine , and i can go to my edit page and edit 

SortByColumns(Search(CRMAktiv;TextInput2_1.Text;"Title";"Handledare";"Stad";"Program";"Notering";"Epost";"Tel";"OData__x00c5_rskurs_Elev");"aterkopplas";Ascending)

 

But then i using filter also the data i gallery is visible , but when i go to my edit page , it cant find the recordset , page is white .
Is it the filter making the trouble och the combo of search and filter . 

//SortByColumns(Search(Filter(CRMAktiv;Intresse in //ComboBox2.SelectedItems.Value);TextInput2_1.Text;"Title";"Handledare";"Stad";//"Program";"Notering";"Epost";"Tel";"OData__x00c//5_rskurs_Elev");"aterkopplas";Ascending)

1 ACCEPTED SOLUTION

Accepted Solutions
WarrenBelz
Super User
Super User

Hi @dalacarelia_196 ,

Not sure how all the comment marks fit in, but this is valid code providing your values are valid, although you should add the possibility of the combo box not having a selection. 

SortByColumns(
   Search(
      Filter(
         CRMAktiv;
         (
            IsBlank(ComboBox2.Selected.Value) ||
            Intresse in ComboBox2.SelectedItems.Value
         )
      );
      TextInput2_1.Text;
      "Title";
      "Handledare";
      "Stad";
      "Program";
      "Notering";
      "Epost";"
      "Tel";
      "OData__x00c//5_rskurs_Elev"
   );
   "aterkopplas";
)

 Also if it is a single selection, you only need

(
   IsBlank(ComboBox2.Selected.Value) ||
   Intresse = ComboBox2.Selected.Value
)

What is the Item of your Edit form?

 

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.

View solution in original post

2 REPLIES 2
WarrenBelz
Super User
Super User

Hi @dalacarelia_196 ,

Not sure how all the comment marks fit in, but this is valid code providing your values are valid, although you should add the possibility of the combo box not having a selection. 

SortByColumns(
   Search(
      Filter(
         CRMAktiv;
         (
            IsBlank(ComboBox2.Selected.Value) ||
            Intresse in ComboBox2.SelectedItems.Value
         )
      );
      TextInput2_1.Text;
      "Title";
      "Handledare";
      "Stad";
      "Program";
      "Notering";
      "Epost";"
      "Tel";
      "OData__x00c//5_rskurs_Elev"
   );
   "aterkopplas";
)

 Also if it is a single selection, you only need

(
   IsBlank(ComboBox2.Selected.Value) ||
   Intresse = ComboBox2.Selected.Value
)

What is the Item of your Edit form?

 

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.

Hello there i find my bad code
In Onselect , i reset nex pages form in that gallery 🙂

//;;Set(TjResForm; true );;Set(TjResForm; false )
now its working 🙂

 

Helpful resources

Announcements
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Community Call Conversations

Introducing the Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (4,162)