Power Apps Import Data from Excel vs. Excel Online Business

Topics include:

• Import from Excel
• Connect to Excel Online (Business)
• How to deal with the error this file is in use when connecting to Excel

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

• The data source is either read-only or has no primary key so the function Patch can't write to it.