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
Super User II
Super User II

@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
Super User II
Super User II

@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
PA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are Your Ready?

Test your skills now with the Cloud Skill Challenge.

secondImage

Demo Extravaganza is Back!

We are excited to announce that Demo Extravaganza for 2021 has started!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Top Solution Authors
Top Kudoed Authors
Users online (71,040)