Importing Access Data into SharePoint 

Here is the link the the full playlist: ru-vid.com/group/PLMgWds5p226mbf427Tkm3F4RsLt-LyLHY

Any time!

I'll try to remember this when I circle back on this project. 😁😁👍👍

Thanks for that👍

Thanks for that 👍

Thanks so much. 😀👍

When Access exports relationships as lookup fields to SharePoint, it not only helps in maintaining the logical structure of the database but also simplifies the development of related applications like those built with PowerApps. This can lead to better data management practices and enhanced application functionality, leveraging the strengths of SharePoint and PowerApps together.

What are the errrors you're facing. Get more help with your issues on my FREE Community here: www.skool.com/power-apps-community

Try this method below: -Open your SharePoint list and navigate to the "List Settings" or "Settings" option. -In "List Settings," look for "Indexed columns" to ensure your desired primary key field is indexed. If not, create a new index for it. -Since SharePoint doesn't allow changing the "ID" primary key directly, make your desired field act as a primary key by enforcing uniqueness. Find your field under "List Settings," edit its settings, and set "Enforce unique values" to "Yes." - Modify your list's views and forms to utilize your unique field effectively, ensuring it serves as the primary key for business logic and data relations.

As a consultant working on Power Platform from afar, the key is to follow a step-by-step process. First, set up a special workspace for your work using tools like Visual Studio Code. Design your solutions with clear plans and security rules. Test everything well to make sure it works correctly. Pay attention to the licenses needed and document everything carefully. When your work is ready, move it to the client's system, fixing any issues along the way. Stay connected with the client through messaging tools, use version control for tracking changes, and create easy-to-understand guides. After your solution is in place, make sure data moves smoothly and double-check everything. Provide ongoing help and training for the people using your solution. This method ensures a smooth and successful process for your clients. 👍 I share alot of tips here in my free community: www.skool.com/power-apps-community

I would recommend Microsoft OneDrive for that type of task. 😊👍

But we have to sync list data as well..i believe one drive will not support that.. Could you please suggest something where we can sync documents as well as SP lists to local machine

If I had to do exactly what you need there, I would be writing code in Power Shell or C# to do it. It gives you most, if not all, of the flexibility you need.

Microsoft might not have a fix for this yet

It may not be dependant on an access version number. What version do you use, and have you tried it yet?

Access and SharePoint may have different data types for certain fields. For example, Access might use a "Date/Time" data type, while SharePoint uses "Date and Time" or "Text" data types. When migrating, you need to ensure that the data types in Access align with those in SharePoint to avoid errors. ☺️

What is a wall of chat? 😲 ...thanks for watching!