Hello there,
I need some help building my PowerApp, I'm doing an attendance App and I have a list of employees in a SharePoint List, I need to set their status every day and keep track of that status in PowerBI, so I need the historical data. What I want is to select multiples employees and set their status to "Attended" for example, using one Submit button. And avoid going
| Name | Status | Date |
| Employee 1 | Attended | 7/5/2022 |
| Employee 2 | Unattended | 7/5/2022 |
| Employee 3 | Attended | 7/5/2022 |
I already have a screen to fill the attendance, but I have to click each employee in my gallery, set it status and click submit, then go and click to the next employee and repeat the process. I want to select multiple employees at a time, and set their status with one Submit
I already manage to update several rows in my SharePoint list with patch function, but that only change the values of the existing rows, what I need is to add new rows to my SP list in order to have the historical data on each date.
