Importing CSV files from Sharepoint to data lake.

Cancelled Posted 1 year ago Paid on delivery
Cancelled Paid on delivery

There are different csv file that should be stored in data lake. I'm looking for a solution to whenever we added a csv file to the sharepoint folder, based on this solution is stored in data lake.

One of the solution is using Power app to save the csv file into the dataverse via Power Automate and then connect dataverse to the data lake.

This solution should be considered for any new csv file that will be add to the folder.

When a csv fill is added

[login to view URL] file already has a related table in dataverse?

[login to view URL] yes, should data be updated or inserted?

[login to view URL] update, so is updated otherwise inserted.

[login to view URL] no, creat a new table in dataverse and inserted to the table.

5. When dataverse is updated data lake will be updated.

I need a low level architecture diagram, as well.

If you have any other ideas, more than welcome!

Cheers,

Sharepoint PowerApps Power Automate Python Microsoft Azure Excel

Project ID: #35332146

About the project

16 proposals Remote project Active 1 year ago

Awarded to:

kmelendezdipre

Hello, Im a professional with more than 6 years of experience working with automations,data integration and RPA using python as a main language. I can handle problems based on web apps, desktop apps and APIs. Librarie More

$130 AUD in 8 days
(6 Reviews)
3.1

16 freelancers are bidding on average $179 for this job

schoudhary1553

Hi, Greetings! ✅checked your project details: ✅Completed Time: In project deadline We have worked on 850 + Projects. I have 6 + years of the experience in same kind of projects. If you are looking for a true Fr More

$220 AUD in 4 days
(577 Reviews)
8.5
ashikmohann

HI I am a python expert and machine learning engineer. i can do the task for you with all the requirements specified. contact me

$200 AUD in 2 days
(28 Reviews)
7.3
AmazingEngr76386

I have worked on a similar project in the past and I am confident that I can complete this one as well. I would need access to the Sharepoint site in order to get started. Once I have access, I can start working on imp More

$140 AUD in 7 days
(6 Reviews)
5.6
diachukoleksand1

Hi there, Nice to meet you. I am very interested in your project. And I want to do your project with my own ability. I will do my best for you. I have experienced for that and have many skills in that area. I have don More

$140 AUD in 7 days
(3 Reviews)
5.2
Osama141

Hello ! I've worked on a number of projects similar to this one. I have a lot of experience and knowledge in this field. My knowledge of business also gives me an advantage in this situation. Looking forward for the o More

$300 AUD in 3 days
(20 Reviews)
5.0
arshad8c8

✔ Expert Here || Available Now.! Hello.! Zahra F. I’ve already understood the project because it requires the expertise in Microsoft Azure, Sharepoint, PowerApps, Python and Power Automate. I've expertise in 400+ Tec More

$30 AUD in 1 day
(21 Reviews)
1.4
bitnetservices

Happy to do it as I am based in Sydney and Data Architect with Microsoft partner here. Thanks Jag

$550 AUD in 7 days
(1 Review)
1.2
vladyslavpiddub9

Hey, Zahra F. I checked your post with title "Importing CSV files from Sharepoint to data lake.". I am familiar to Python, Sharepoint, Microsoft Azure, PowerApps and Power Automate. I want to discuss your project in More

$150 AUD in 5 days
(1 Review)
1.0
ahmedwa533m

Hello, How Are You? I have read your job description completely I have experience in Python and I am confident that I can produce quality content for you that will be of interest to your readers. I am available for a More

$130 AUD in 5 days
(0 Reviews)
0.0
Hated100

I have been working as Virtual Assistant for my clients and do their excel data entry, internet research, typing and any kind of work related to data entry. I will do my best to provide the quality of work to my client More

$70 AUD in 5 days
(0 Reviews)
0.0