cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
AakashJaiswal
Helper V
Helper V

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
Community Champion
Community Champion

@AakashJaiswal 

 

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
Community Champion
Community Champion

@AakashJaiswal 

 

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

Thanks for the elaborated explanation. Point noted.

 

Regards,

Aakash

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Solution Authors
Top Kudoed Authors
Users online (1,619)