Hi, I have multiple Excel spreadsheets that have wide tables with one row and 100-150 columns. I also have a Dataverse table with all possible (150+) column headers and one existing row. I want to create a Power Automate flow that grabs the singular row from each Excel table and adds the row to my existing Dataverse table, automatically mapping column names that are the same across the sources. In cases where a particular column in the Dataverse table does not exist in the Excel table, the particular column should be blank. Any cases where the column header names exist in both Dataverse/the Excel table, the column should populate.
I know I can ingest a row using List Rows Present in an Excel Table -> Add a New Row and manually specify which columns map, but needing to do this over a hundred times for each Excel table seems unnecessary. I'm looking for guidance on how to automatically map columns between my Excel table and my Dataverse table and ingest the row from each Excel table.
Appreciate any help!