Please Follow these steps:
1. Create a properly formatted Excel table with your Data covering the columns you have in table, ID, Name etc.
2. Import the excel File:
3. Create a collection with the Table inside the Excel file:
ClearCollect(MyCollection,TableNameInExcel) With this the data would be in powerapps ready to be used.
4. The next step is to Push the data to SQL:
ForAll(TableNameInExcel,
Patch('[dbo].[SQLTable]', Defaults('[dbo].[SQLTable]'),
{FieldInSql: field1InTableNameInExcel,FieldInSql: field2InTableNameInExcel} ) )
If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.
