Error DetailForm with BrowseGallery Sort

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hello;

I have a error when i use this code for sort my BrowseGallery :

My DetailForm display => invalid formula. A value compatible with "datasource" is expected

My list BrowseGallery ('Home Working Test') is a datasource from a SharePoint List

If(
UserEmail in UserAdmin.Value;
SortByColumns(
   AddColumns(
      Filter(
         'Home Working Test';
         StartsWith(
            Requester.DisplayName;
           TextSearchBox1.Text
       )
      );
      "itemchoice";
      If(
         Status_Request.Value = "Requested";
         "A"
      )
   );
  "itemchoice";
   "Ascending";
   "Title";
   If(
     SortDescending1;
      Descending;
      Ascending
  )
);
SortByColumns(
   AddColumns(
    Filter(
      'Home Working Test';
         Requester.Email = UserEmail;
      StartsWith(
            Requester.DisplayName;
            TextSearchBox1.Text
         )
     );
      "itemchoice";
     If(
        Status_Request.Value = "Requested";
        "A"
      )
  );
   "itemchoice";
  "Ascending";
   "Title";
  If(
      SortDescending1;
      Descending;
      Ascending
   )
)
)

Sans titre2.PNG

Thanks for help ! 🙂

Categories:

Building Power Apps

All responses (2)

Answers (1)

Sort by

Jeff_Thorpe 6,085 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

The AddColumns() is causing the issue. It creates a temporary table that is used in the gallery. So gallery.Selected points to a row on the temporary table and not a record in the 'Home Working Test' data source. In your case you may not need AddColumns() because you could just add a label to the gallery that displays "A" if thisitem.Status_Request.Value = "Requested".
Verified answer

v-xida-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
HI @Anonymous ,

Based on the issue that you mentioned, I think this issue is related is related to AddColumns function. The BrowseGallery1.Selected formula returns an record from the AddColumns formula result, but the Item property of the Display form is required to provide an record value from your 'Home Working Test' data source.

As an fixed solution, please consider take a try with the following workaround:

Set the Item property of the Display form to following:

LookUp('Home Working Test', ID = BrowseGallery1.Selected.ID)

Please consider take a try with above solution, check if the issue is solved.

Best regards,