Hi @Anonymous ,
Would you like to transport data from a spreadsheet to Dataverse using Power Query?
Since the X and Y columns contain 7 decimal places numbers, but when using Power Query the Decimal format only supports 3 digits of number and Float format in Dataverse only supports 0-5 digits, you will need to use Text type column in Power Query to transport data.
If your spreadsheet includes not quite large datasets, you could consider connect to the spreadsheet as the data source in Power Apps and save the whole dataset into a newly created Dataverse table. For example:
Connected to spreadsheet data table, using a button with below formula to upload all items:
ForAll(SpreadsheetTable, Patch(DataverseTable, Defaults(DataverseTable),{X: ThisRecord.X, Y:ThisRecord.Y, OtherColumns:...}))
After checking the uploaded records using a Gallery set Items property to the Dataverse table, if all records have been uploaded successfully, you could delete the spreadsheet and remove the submit button from your App.
Hope this helps.
Best regards,
Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution to help the other members find it.
