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 Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Power Query PA Forum 768x460.png

Check it out!

Did you know that you can visit the Power Query Forum in Power BI and now Power Apps

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

R2 (Green) 768 x 460px.png

Microsoft Dynamics 365 & Power Platform User Professionals

DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.

Users online (1,397)