I currently have a SharePoint list that is feeds into a PowerBi for data reporting. Editing this list is clunky and was wondering if there is way to modify the list rows by a form entry. The way this list is set up is a column for the employee's name and a bunch of Date columns of when they were certified for certain required certifications for their job.
Is there a way to create a form that will collect the employees name, which column to edit, and the new date to update the column? And what is the best way to do? Any example Power Automate scripts or anything to point me in the right direction would be greatly appreciated.
Attached is an example similar to how my list is set up.
I want the form to know which certification type and to update the date for that employee without creating a new row.
