Combining rows based on unique ID, but need to combine/concatenate specific columns

[EricC]

Hi all -

Here is my data:

UserName	UserEmail	Office	LoginDate	LoginTime	ViewedScreen	Type	Location	Shareholder	LetterDate	UniqueID
Smith, John	name@company.com	2	5/8/2018 0:00	15:35:51	Y					19523C53
					Y	1	FL	Williams, Gary	5/8/2018 4:00	19523C53
					Y	1	GA	Smith, John	5/8/2018 4:00	19523C53

I am using the patch/collect function in powerapps to spit this data to an excel workbook. It informs me if a user has viewed a screen, what selections they made in a dropdown etc. 

My issue is as follows: A user may make multiple selections in the dropdowns(make selections, browse back to screen and make more selections) and I need to track that data. (Type, Location, Shareholder & LetterDate) so I can later report on it. The uniqueID column is specific to that session of them using the App so it is the unique key identifier.

As you can see in the data table above, it will collect Y for they viewed the screen, what drop down selections were made and a uniqueID for that specific session of them using the app, however, when they make new selections it creates a new row via the Collect function and then any subsequent screens they view will be on this new row along with their drop down selections

I'm wondering what the best way is for me to link that data to the UniqueID but still individually be able to track the different drop-down selections and get a count of the Ys for how many times they viewed each screen per session, but I do need the specific selections from the dropdowns to report on.

[v-yuezhe-msft · Accepted solution]

@EricC,

Create two seperate tables based on your table in Query Editor as follows, then create relationship using UniqueID field between the two tables.


Regards,
Lydia