
Hi, I am trying to create a table form that gets pre- populated when choices are made from a few drop down menus. They would click a button to create a form and is prompted to select a category and specify the month and year and when submitted a editable table that auto populates the fields along with the month and year field based on the previous step. So if the category selected has 5 things linked to it, it will create a table with 5 rows with those 5 things and the month and year gets filled down in their respective column. Hw can I approach this? Will I need two datasource, 1 for lookup and one to store the entries?
Example:
Chosen Category: A
Chosen Month: Dec
Chosen Year: 2020
then after submitting the editable table is navigated to.
| Category | Items | Month | Year | Qty |
| A | Pen | Dec | 2020 | |
| A | Pencil | Dec | 2020 | |
| A | Marker | Dec | 2020 | |
| A | Crayon | Dec | 2020 |
then a empty column for user to enter data.
Check out these videos by @RezaDorrani https://www.bing.com/videos/search?q=powerapps+repeating+table+reza+dorani&&view=detail&mid=1B789BB1BEC5268EFD8B1B789BB1BEC5268EFD8B&&FORM=VRDGAR&ru=%2Fvideos%2Fsearch%3Fq%3Dpowerapps%2Brepeating%2Btable%2Breza%2Bdorani%26FORM%3DHDRSC4 and @aprildunnam here https://www.bing.com/videos/search?q=powerapps+repeating+table+reza+dorani&ru=%2fvideos%2fsearch%3fq%3dpowerapps%2brepeating%2btable%2breza%2bdorani%26FORM%3dHDRSC4&view=detail&mid=58A726BE2D33405FFD6E58A726BE2D33405FFD6E&&FORM=VDRVRV