Hi,
I model my data in a three-column table like the one below. The three columns are [Month], [ProductionType] and [Production]. [Day] and [ProductionType] together are the primary key.
Table
I would like to input data in an Excel like grid control like the one below. Note that this is not a pivot table because there is only one record at the intersection of a production type and a month (it's a matrix).
Did some form control exist in Power Apps to input data in this way. If not, what’s the best way to input this kind of data considering that I have more than 12 months and more than 2 Production type ? Also, my users would copie-paste the values from Excel sometime.
User | Count |
---|---|
246 | |
105 | |
82 | |
50 | |
43 |