cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
dalacarelia_196
Helper V
Helper V

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.

View solution in original post

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
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Solution Authors
Top Kudoed Authors
Users online (1,223)