Do you want to get your Excel data into PowerApps? Then this is your video. Learn how to Import Data from Excel as a static table and how that compares to hosting the file in OneDrive for Business and connecting to it as Excel Online (Business) data. You will learn how to structure the data as a table to import it, why you get the error this file is in use, what the error The data source is either read-only or has no primary key, so the function Patch can't write to it means, how to update the data, and plenty more. A must for Excel lovers who want to get the data into their Power Apps.

Worth noting that import from Excel doesn't work with Patch, Remove, Forms, or any other function or control that edits data.

Power Apps Consulting and training at [ Ссылка ]

0:00 It starts
2:09 PowerApps Import from Excel
7:57 Warning about pulling in too large of a table
8:35 Import a table with over 5000 rows of data
8:57 How to deal with the error this file is in use when connecting to Excel
10:27 Update the static Excel data by removing the table and adding the same table back with the same name
11:45 Connect to the data via Excel Online (Business)
12:55 Insert autogenerated id into Excel table or Use unique column from Excel table

свернуть