I have a flow that initially uploads Excel Documents to a SharePoint Location. The SharePoint files are then to be loaded to the corresponding dataverse table. Example Employee Information.xlsx is loaded to Employee Information table.
The bit I need help with is passing the row item to the Add a new row action. Column names in the Excel and table match letter for letter. i am referencing the table name dynamically, currently I am passing the row items in the format:
{
"Column1": "xxx",
"Column2": "xxx",
"Column3": "xxxx"
}
The attached image shows the current flow.
I am reading the rows from the excel, removing some unwanted columns, then looping through each excel row to adding them dynamically to the table.
I need help with how the row input data is expected and any information known on the error above.
This gives me the error: Error identified in Payload provided by the user for Entity Invalid property 'ID' was found in entity>Does not support untyped value in non-open type.