Answered

How to recreate the PowerAppID column in Excel?

(0) Share

Report

Posted on by FUS

150

Hi

I'm fairly new to Powerapps and made the mistake of deleting the PowerAppsID Column... and haven't succeeded in restoring it.

I have disconnected and reconnected the data sources (two excel tabels)... without success.
I just created a new workbook, copied the data, created new tables and connected the App to those tables... but also now without any luck.
I even added a column manually with the title "__PowerAppsId__" and reconnected... but without any success ‌‌‌

I opened up my connections tab in PowerApps main view and the weird part is that it says I have no Apps connected to my Excel or Onedrive account.... but I know the App imports the data through a Excelconnector... I just can't get teh app to update the data without the PowerID. 😖

Anyone know how I could do to get the PowerAppID column back?
Would really appreciate some help...

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

eka24 20,923 on at

Like (0)

Report

Was this reply helpful? Yes No
eka24 20,923 on at

Like (0)

Report

As you have said, creating the PowerAppId is an automatic process. However I hope you didn't use excel import because it doesn't apply to that.
I also hope your Excel data in a properly formatted excel Table not just a work book.

Watch this video if you have not done so already;
https://youtu.be/-Z_13J02RPU

------------
If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Was this reply helpful? Yes No
Verified answer

FUS 150 on at

Like (0)

Report

I just solved it!!!

I removed my excel-connection... (which I had added by searching for "excel" and choosing the file & table).

And instead I choose to create a connection to my OneDrive... and through that way choose the excelfile & table... that made the "PowerID" column reappear.

So lesson is... don't connect to an excelfile straight off... go through the OneDrive connector... even if both connects to the same source... only one creates the PowerID column!!!

Was this reply helpful? Yes No