I created a budget tracker APP via Microsoft template , then it generate a excel in my one drive . Then I edit the data via online,
changed the CategoryName column and don't touch the data in the _PowerAppsId_ column (attached the screenshot) , then I close the app and open again, found the data was removed successfully, but I can not add new data in it, will show below error.
Your colleauge linhtran shared this to me before , but can not work (https://powerusers.microsoft.com/t5/PowerApps-Forum/can-not-add-new-data-in-Powerapp-after-remvoe-th... , hope you can test it before reply this question, if make sure no problem, hope sometone can guide me step by step, as waste too much time on it, thanks.
Then show this error
I just followed the steps that Linhtran suggested in your another similar thread:
Following is my steps for a reference:
1.Create an App from template, save Excel file to OneDrive.
2.Open the Excel file in OneDrive, delete all rows in Budgets, Expenses, Receipts, ExpenseByCategory. In the Categories sheet, I just add “Hotel” the same with you. Please check the screenshot as bellow.
3.Then save the file and reopen the App. I can edit the App and save data to the Excel file with no error.
Please try again with this issue to see if it works for you now.
Just followed your instruction and tested again, still not work , firstly , the performance is bad, very slow when download the app and run the app,
Secondly, the new budget cannot show out after I add a new budget. Do you need me share desktop to you to show the problem?
I test it again with the same steps, it works, except the issue that the pie chart cannot be shown on the App.
Have you updated your PowerApps to the latest version? What’s your OS? After you add a new budget, can you check the record in the Excel file?
This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.
Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.
At the monthly call, connect with other leaders and find out how community makes your experience even better.