Power Platform Community Forum Thread Details

My company has a simple Access database that has some tables regarding motor parts (manufacturer, location, status, part type, etc). I'm looking to transfer needed data to sharepoint lists to make a powerapp for users to search, add, and view parts. What is the best practice for building sharepoint lists to build a PowerApp with? Can all data be in one sharepoint list or does each table from access have to be in separate sharepoint lists? Any tip is greatly appreciated!

Categories:

Building Power Apps

Hi @sygc601 ,

When transitioning from an Access database to SharePoint for building a PowerApp, you'll need to consider the structure of your data and the requirements of your app. SharePoint Lists can be a good replacement for tables in Access, but the design may differ. Here are some guidelines:

- If your Access database has multiple tables, you might consider having separate SharePoint lists for each table. This is more aligned with the relational structure.
- If your tables are related, you can create lookup columns in one list to reference data from another list.

- In SharePoint, you can establish relationships between lists using lookup columns. This helps maintain the relationships between different tables in Access. Consider combining data that is frequently used together.

- Consider the security and permissions needed for different data. If certain data should be accessible to specific users, you might need to create separate lists.

- Plan how users will search and filter data in your PowerApps. SharePoint lists support various column types, impacting how users can filter and search for items.

Remember that the best approach may vary based on the specific requirements of your application. Take the time to plan and design your SharePoint lists to ensure they meet the needs of your PowerApps and its users.

Thanks!!!

Please consider marking my response as the accepted solution if it successfully resolves your concern. If you found the information beneficial in other aspects, kindly express your appreciation by giving it a thumbs-up.