Forum Discussion
Combining rows based on unique id, and combining information
Sorry, forgot to mention that you need to turn the aggregation off: last step: Advanced Opions: Don't aggregate bofore hitting the last OK.
This is due to the fact that the column you've checked (where you say: "Unpivot others") would have duplicates after the operation / there would be more than 1 value in a cell.
I need to see a sample of your data to tell you how to overcome this.
Hi,
I may need to create a new post as this is quite a bit outdated but I am trying something similiar and need some assistance.
Here is my data:
| UserName | UserEmail | Office | LoginDate | LoginTime | ViewedScreen | Type | Location | Shareholder | LetterDate | UniqueID |
| Smith, John | [email protected] | 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 and I need to track that data. (Type, Location, Shareholder & LetterDate)
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.
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, but mash together the viewscreen columns since I don't care about the duplicate Ys so long as I have one Y, but I do need the specific selections from the dropdowns to report on.