PowerApps ersonalized gallery with distinct/groupby values

[rutgerverhaar]

Hi everyone,

I'm trying to create a gallery that is both personalized using 

Filter(Table1, PersonResponsible = varUser.FullName)

and that shows the distinct title values that belong to the personalized view. I've seen people use Distinct and GroupBy to get the unique values.  Right now I've been using GroupBy to get the unique values with the following code:

GroupBy(Table1, "SalesDoc","DATA")

Separately they do the job, but I need to combine both formulas to get the required view. I keep on getting errors when I stack both formulas with ;. 

Does anyone know what I'm doing wrong here? 

Kind regards,

Rutger

[v-jefferni]

Hi @rutgerverhaar,

GroupBy() or Distinct would change the structure of a table, so actually you will be using a temporary table as the data source of both the Gallery and the Form.

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.

[rutgerverhaar]

Hi Jefferni,

Would you know of another way that would meet my requirements but that would be feasible within powerapps?

In short the requirements:

- (Top left of screen) Personalized welcome which shows the total number orders assigned to the individual

- (Bottom left of screen) Something underneath the welcome that would list all orders. Have the ability to click on an order here that would then show the details of the order on gallery/form at the top right of the screen.

- (Top right of screen) As mentioned in the previous step. Here you can see the details of the clicked order from the bottom left of the screen. This section should show the order as 'title' and all related sub-orders as 'sub-titles.'

-(Bottom right of screen) Finally, I want the user to be able to click on an order or sub order from the top right of the screen and see all details related to this (sub)order. The screen at the bottom right should be an edit form. A user should be able to log certain tasks here.

Right now I have one table that holds both orders and sub-orders. Would it potentially be an idea to split the table into two where one would hold the orders and the other the sub-orders so that I can steer clear from groupby/distinct formulas?

My gratitude is huge!