cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Justin
Helper I
Helper I

can not add new data in Powerapp after remvoe the data via the excel online

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.

 

2016-11-03 09_58_26-BudgetTracker_66929ac1-2cd7-a3ff-d37e-25bc2514e5c3 - OneDrive.png2016-11-03 10_07_28-data.xlsx.png2016-11-03 10_08_08-data.xlsx.png2016-11-03 10_07_43-data.xlsx.png2016-11-03 10_08_16-data.xlsx.png2016-11-03 10_08_27-data.xlsx.png

 

Then show this error

 

2016-11-03 10_12_22-liangju-w10 - Remote Desktop Connection.png

 

2016-11-03 10_15_16-liangju-w10 - Remote Desktop Connection.png

 

3 REPLIES 3
v-yamao-msft
Community Support
Community Support

Hi Justin,

 

I just followed the steps that Linhtran suggested in your another similar thread:
https://powerusers.microsoft.com/t5/PowerApps-Forum/can-not-add-new-data-in-Powerapp-after-remvoe-th...


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.

Budgets.PNGCategories.PNG

3.Then save the file and reopen the App. I can edit the App and save data to the Excel file with no error.
Budget tracker.PNGAdd expense.PNG

 

Please try again with this issue to see if it works for you now.

 

Best regards,
Mabel Mao

Community Support Team _ Mabel Mao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

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?

 

Hi Justin,

 

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?

 

Best regards,
Mabel Mao

Community Support Team _ Mabel Mao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

365 EduCon 768x460.png

Microsoft 365 EduCon

Join us for two optional days of workshops and a 3-day conference, you can choose from over 130 sessions in multiple tracks and 25 workshops.

Users online (3,287)