what about if your target sharepoint needs to be dynamic and based on an input everytime the flow is run? How can this be done using variables etc?

Thank you this help!! Your Office365 series is also helpful!!

@I am Lu - I lied on my job application and said I have 1 year experience with SQL to get my foot in the door... (and it actually worked lol, I know I shouldn't be doing this but I couldn't help it because I really want to work at this company), this company largely deals with Datasets. I made it to the 2nd stage of the interview where they will test me on my knowledge in SQL, do you think taking the 5 hour course on Codeacedmy will be good enough to learn it?

Can you show how to password protect a csv file?

Good day Lu, I become your fan after watching your videos and it's very helpful to learn Python, I have SharePoint 2019 on-premises, after watching your video for SP19 on-premise I tried and I am getting SSL verification error please assist me how to solve it.

Thanks!

You made my day! Now this list I wanna upload in Excel?

very nice , can you please share the complete automated process upload and download

Hey great video. Is it possible to grant permissions within a procedure? I need to grant select on lot of schemas and doing it with a for loop in a procedure would be very helpful.

Hi, is there a way to download a report with a SP Site document inventory without downloading the files? thanks I have been looking for that a Lot but still don't find it.

Yow Lu vera level ya nee.!!!

very underrated channel

Great. For anyone else following along, you should consider wrapping the lockStructure part in a try/catch, to prevent failing for excel files without locked structure

100 thumbs up ! Edit: PS. for anone else following along, the "quit()" statement should be "break" instead.

Perfect video! I don't know if you will see my question. Did you create a "Connection" in AWS Glue, or is the on-premises database IP exposed on the internet? In this case, should I use something like a VPN from AWS to create a secure way to connect to it? Thanks a lot!

Thank you very much, I had been trying for almost 9 hours to use a library that could be uploaded to lambda, since the others are extremely heavy and the one you used was perfect and served 10 times, thank you very much.

Where we can find your code?

ValueError: An error occurred while retrieving token from XML response: AADSTS53003: Access has been blocked by Conditional Access policies. The access policy does not allow token issuance.

very nice!

where I will get sharepoint id password AND what does I will do if I get authentication error?

Is it possible to do the opposite? Can Power Automate read an S3 bucket and transform it into a file in SharePoint?

Is it possible to do the opposite? Can Power Automate read an S3 bucket and transform it into a file in SharePoint?

I like to watch these videos just for the background music vibe

Hi Sir, How can i include folder as well it only copies files . I need to copy exact same so file structure is maintaind.

HI there, Your videos are excellent, but I was left with a doubt. If I create another document library, called Invoices for example, it would be at the same level of Documents,Home, Pages. How could I access this library? thank you

Is there a way to do this without downloading locally in-between. I have large files which makes the process of downloading and uploading slow.

looks like this does not work in 2024 anymore. I ran your program, executes without error, but the workbook is still protected ... :(

Hi Lu, very interesting video. Do I need admin rights to access lists on Sharepoint on Prem or is a user with specific rights enough? Thanks a lot :D

thanks! you are doing a great job! but i have a question i want to edit documents (pdfs) and images that are stored in a sharepoint to remove sensitive data using a python code can you tell me how to access those documents and create a modified copy of them

Is there any other method without using Office365 Rest Package on python?

Excellent tutorial, but in my case it didn't work because the authentication in Sharepoint of the company I work for is done with a token in the Microsoft Authenticator application on the smartphone, do you know if there would be any alternative for these cases? Would the SharePoint administrator be able to make an exception to double-factor authentication for a service user? Thank you very much for the tutorial and a big hug from your new follower here in Brazil.

Does anyone know how to get the same output than the one we get with connect_to_list but for folders that are within documents ?

✔️ Promo`SM

Good info. Thanks Lu.

Can any body help here, I am stuck with the SSH error key

thanks a lot bro was building a project this really helped me :)

Did you get a chance to upload this to Github?

Hi Lu, great video. I was wondering if there is any chance to do this process, but instead of just moving the files, can you move the folders too, along with the files, so you can keep the original folder structure from SharePoint?

Hi Lu, great video. I was wondering if there is any chance to do this process, but instead of just moving the files, can you move the folders too, along with the files, so you can keep the original folder structure from SharePoint?

Hi Lu, great video. I was wondering if there is any chance to do this process, but instead of just moving the files, can you move the folders too, along with the files, so you can keep the original folder structure from SharePoint?

Hi lu, Thanks for the video. This tutorial was great! please create a another video on how to create folder on sharepoint sites

You literally saved me dude. The hours I spent trying to find a good example. You are a hero.

what about using coalesce to make sure the data stays in 1 partition?

Tysm this was extremely helpful.

Hi, Thank you for these videos! I am getting stuck when I am creating the Flow and establishing connection to the SFTP. I get a "Server HMAC algorithm not found..." error. I followed your steps exactly from both videos and am able to successfully connect to my S3 bucket using WinSCP, but get this error on the Power Automate connection. My private key starts with the -----BEGIN RSA PRIVATE KEY----- header. Any thoughts on what I may be doing wrong here?

Very precise and simple explanation! Thank you!

Awesome. It works for me. Thanks!

In which timezone is the TimeLastUpdated property? UTC? Or site timezone?

postgress was looking great, then i saw they are using || to concatenate? What unholy nonsense is this!

I am downloading a xlsm file and it gets corrupted. Any Ideas? Someone that has faced the same issue?