In PowerApps you can use ForEach to loop through a collection and pass each row to your data source - this is a great option, but does have a performance hit with large data sources.
An alternative approach is to use Collect - you can use collect if your data source matches the columns in your data source - but if it doesnt you can use PowerApps commands such as AddColumns or RemoveColumns to clean up your data before collecting to your data source.