To resolve this, close the file and try saving again: Server response: Cannot write file to filesource. Note you should not have the Excel workbook open in OneDrive when you are trying to update it, or you will receive the error “The requested resource is locked. In your OneDrive Excel file, you will see the update has been made: Make an update, set the Annual Revenue to 5000001 and click to submit: Sign into the PowerApps mobile app and select the Customer Excel app we created: That’s it! Now let’s use the app on our mobile device. You can also create a new record by clicking the + sign:Īnd delete records by selecting them and clicking the Delete icon: We can see the change has been reflected: Let’s look at our Excel workbook in OneDrive.
We will change the annual revenue to 5000000: We can see individual details of the customer:Ĭlick the top right to Edit. You can see the app automatically has created a page that lists all the customers: Click Play to see what the app looks like: Select OneDrive for Business Phone Layout: Note if you do not do this, you will receive an error message “There are no tables in this file” when trying to connect from PowerApps. Note do not use spaces in the header labels or it will be replaced by x0020 in PowerApps.įrom the Design tab, set the name of the table to Customers: Select the range of your data, and then Home->Format as Table: I have one that has a list of Customers (fake numbers, of course!): Here we will go through just how to do that.įirst, let’s create an Excel workbook. PowerApps are powerful! One of the great features is to be able to connect to an Excel spreadsheet and literally turn it into an app that you can use on your phone.
0 kommentar(er)
