Hi @matheusscampos ,
Would you like to group the SP list items by a choices column?
If so, you could leverage the AddColumns function to add Choices column values into a new column then groupby.
On your end:
GroupBy(AddColumns(GroupBy(AddColumns(Filter(Nome;StartsWith(collaborator;txtColab_1.Text)); "FormulariosRH";Formul_x00e1_riosRH.Value);"Nome_CPF";"FormulariosRH"; ColItems);"collaborator";collaborator);"collaborator";"ColGroup")
Since the collaborator values of the grouped table are all the same, using the AddColumns function to add a column with its value to the table grouped, then in the next groupby, this column would be another column to be grouped, column value would be retained in the top level so you could find it the next step.
On the > button, create a variable to store the selected item:
Set(varSelected,{FormulariosRH2:ThisItem.FormulariosRH,collaborator2:ThisItem.collaborator})
Then in the Form, set DataSource to the list name, then set Item to:
LookUp(Nome,collaborator = varSelected.collaborator2 && Formul_x00e1_riosRH.Value = varSelected.FormulariosRH2)
Now you could add Attachments field into the Form as well, just like in simple Edit Form.
Hope this helps.
Best regards,
Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution to help the other members find it.
