Power Platform Community Forum Thread Details

Que debo agregar o modificar en mi formula para que solo me aparezcan los datos por ID de cada usuario del mas reciente al mas antiguo

Anteriormente tenia esta pero me mostraba los datos mas antiguos a los mas recientes (Solamente por ID)

Filter(Tickets; ID_Usuarios.Value=User().Email)

ahora tengo esta otra formula pero no me la muestra por ID de cada usaurio (me aparecen todos los campos)

SortByColumns(Tickets; "field_2"; SortOrder.Descending)

Pero si las uno me marca error en Filter

SortByColumns(Tickets; "field_2";

Filter(Tickets; ID_Usuarios.Value=User().Email);

SortOrder.Descending)

Categories:

Building Power Apps

Microsoft Dataverse with Power Apps

Power Apps Pro Dev & ISV

Power Query

Hi @IS-12031616-0,

Almost correct - try this

SortByColumns(
   Filter(
      Tickets;
      ID_Usarios.Value = User().Email
   );
   "field_2";
   SortOrder.Descending
)

I also notice your field name - I assume here that you have created a SharePoint List directly from an Excel table. If you have not gone far into the exercise, I encourage you to re-create the SP List with the field names you want and then paste all the Excel data using Edit in grid view. You will have a lot less problems with field name references in the future.

Please ✅ Does this answer your question 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 answering Yes to Was this reply helpful? or give it a Like ♥
Visit my blog Practical Power Apps LinkedIn