Thank you for the wonderful video. In July 2022, I relocated from Pakistan to Canada(Calgary) and secured my first job as a Power Platform developer. Your videos have been instrumental in my learning journey, and despite transitioning to the role of a Project Specialist last month due to certain circumstances, I continue to watch your videos and develop flows and apps. These resources are invaluable as I strive to enhance my skills and prepare for future opportunities in the job market. Your videos have been a tremendous help in my ongoing quest to learn and grow.
This is what I needed. I'm an attorney (was an information systems guy before becoming a lawyer) and I've got folders and folders of documents sitting in my Sharepoint. Until I can figure out AI large language model summarization, I need to iterate through and have a flow summarize what's in each folder ("here are all the decisions, here's medical evidence, here's forms"). I have been absolutely bashing my head against a brick wall fighting with Python and Sharepoint (because I don't do this every day). This video was a lifesaver though and it is letting me get closer to my goal. Like and subscribed in appreciation! :)
You are a great, great teacher. I laughed, I learned, (I didn't cry, but that's a good thing). Thank you for teaching us. I was able to follow along and feel like I actually learned more about how things work instead of just learning what bandaids to slap on at the appropriate time, not understanding why or how they work. This is great. I have a long way to go, but this gave me some hope and vision for the future (and a little more confidence too)!
very helpful tutorial. I have additional follow up. I have a manual trigger - next i have a list row present in a table that is saved in sharepoint in an xls file. Next i get file properties only. i did the steps select filter array and compose. What need to happen next is to compare the xls file and what is in sharepoint. In the xls file there is a column with STOP File Name. The naming convention is the same as the PDF file saved in Sharepoint. For eg. in the xls file you can find a STOP File Name; "337v9 2022 STOP.pdf". In Sharepoint, you can also find the same file name "337v9 2022 STOP.pdf". if there is a matching name, create an email and attached the PDF file. If not, do not send email. I am thing a condition and Yes/No and Get File Content. When i create that step and using the dynamic array, the loop is taking too long. Please help!
HI, Excellent demonstrate I need a flow when a file is deleted it will send an approval email to the approval user to approve / reject the deletion. When rejects it should put back the file into the document library
Thank you so much for this tutorial. Explanation is commendable!! Is there a way that I can filter all .pdf and .docx files instead of giving whole file names in the query filter. I have over 600K docs (in a sharepoint library which includes folders too) which includes .png, .pdf, .docs files. I only want to filter .pdf and .docx. I want to extract authors and file names for these documents. Any help would be highly appreciated! Many thanks in advance.
Hello, I really need the other video that you mentioned that you made with get file content. Can you provide the link? The is almost no clear information about this on the internet. I have spend weeks looking for this.
Hi, you mentioned at the start of your video, you have made another video how to handle content of the file, I've tried to search for your vids but cannot find it, please help me with a link?
Can you please explain what available operators there are for this filter? I am trying to do a "FileLeafRef contains 'value'" search and not getting any luck
Hi Have been to your Udemy course of power automate to webapi. Can you help me undersstanding how the custom connector to webapi works as HTTP connector generally go over the web to call API, but we need to call API via on-prem gateways. Is there any video already there?
Thank you, very impressed with your video and presentation style Alireza. Question, is there a limitation on the Filter Query? I have a large library just over 30k items. If I use pagination without Filter Query and set it to 10k I can get ALL the items. If I add a Filter Query it ONLY fetches the first 100 again?! (Top count has no effect or any other permutation). I thought I would just ignore the Filter Query and grab them all but somewhere10k-30k I reach some kind of data/memory limit in SharePoint for the query too. So I am really stuck!
Great Alireza; as usual, I want to filter a list that contains ~200,000 items, based on FileName (contains duplicates). Based on this filter, i want to update the field (validity), so the latest one is "Latest" and all others are "old". When i put in pagination 100,000, it returns error that the max is 5000 only Combination of FileName and revision columns are unique items Thanks....
This is a good one. First of all pagination has nothing to do with the number of the items in the list. It's the limit to the number of the items it returns. So most probably the default 100 is just good enough for you. Now it is all about how you right the OData filter. My suggestion is that 200K items is too much for SharePoint to handle. Transfer your list to something like Dataverse or SQL Server. There you have a lot less restrictions. By the way, I just checked pagination limits for both Get Items and Get Files and they are both at 100K. I really don't know where that 5K comes from.
@@AlirezaAliabadi Thanks for your reply you are right, 100,000 is the limit, but when i save it bring error telling the limit is 5000. The thing that is not clear to me, I set the filter by FileName and revision, so it will return very few items, but it returns empty [ ] while it item i wanted to get is available. Thanks and بارك الله فيك
How i can create a script Python, to rename a SharePoint files? I have an local excel file have a column for Files Names that exist in a Folder in Shared Document. i want to use this excel file to read the Files Name into it and search for the File in share point to rename it with the column "New File Name". can we do that using Python?
