cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Powerapps ID not generated on Sharepoint List

Hi,

 

I was using an excel file as my database for an app that I am building. However, I decided to migrate the database to Sharepoint list as my users will also have file attachments when they are updating this data via the app. 

 

But when I am using the sharepoint list as my datasource and when I am saving a new form, all the fields are getting updated except the automatic PowerApps field. Is this something to worry about? If yes, how can I fix it?

 

Regards,

Aakash

1 ACCEPTED SOLUTION

Accepted Solutions
poweractivate
Super User
Super User

@Anonymous 

 

You should not need to worry about it. That PowerApps automatic field of the Excel file row is something specific to that Excel File data source. Also whether you need attachment or not, you made a wise move to use SharePoint List. If possible you should almost always avoid Excel File as data source. We almost never use it - not even for testing or development.

 

We recommend, if possible, that you try not to use the Excel File data source again, for almost any use case - not even if you find out that you don't need file attachments later.

 

If you can, try to use Common Data Service. A SharePoint list is also acceptable as a data source as well, especially if you are already using this list outside of PowerApps as well.

View solution in original post

2 REPLIES 2
poweractivate
Super User
Super User

@Anonymous 

 

You should not need to worry about it. That PowerApps automatic field of the Excel file row is something specific to that Excel File data source. Also whether you need attachment or not, you made a wise move to use SharePoint List. If possible you should almost always avoid Excel File as data source. We almost never use it - not even for testing or development.

 

We recommend, if possible, that you try not to use the Excel File data source again, for almost any use case - not even if you find out that you don't need file attachments later.

 

If you can, try to use Common Data Service. A SharePoint list is also acceptable as a data source as well, especially if you are already using this list outside of PowerApps as well.

Anonymous
Not applicable

Thanks for the elaborated explanation. Point noted.

 

Regards,

Aakash

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.

May UG Leader Call Carousel 768x460.png

June User Group Leader Call

Join us on June 28 for our monthly User Group leader call!

PA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.

PA.JPG

New Release Planning Portal (Preview)

Check out our new release planning portal, an interactive way to plan and prepare for upcoming features in Power Platform.

Top Solution Authors
Users online (1,313)