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, it seem to be the perfect answer at my current problem but for me that the "get files (properties only)" only get the folders and not what's inside (mostly pdf and .xlsx) is there something to toggle to extract folders AND what's inside? thanks a lot !
Hi Alireza, great video, Can you make a video where I can get items using "List excel rows action" where the excel file is saved in Documents Library. I want to pass the SharePoint site, documents library name/id, FileName and Table name dynamically. It worked just by using variables but when I promote the solution to Prod env, it failed saying either the get table failed or invalid drive id. Many thanks
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?
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!
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?
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
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?
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 بارك الله فيك
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! :)
This is one of the best, most complete demonstrations of any Power Automate function that I've seen - thank you!
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)!
Excellent presentation and explanation. Thank you very much for sharing your knowlege.
Superb explanation of the different fields available for this step. I had never considered using the Order By filter before. Great job on this video.
Excellent! After four years, I am still learning from you 😊!
Your video is awesome! I've been looking for this for couple weeks. Thank you so much!
This was a beautiful tutorial!! Every question that popped into my head, you answered in real time. I also learned a lot of tricks. Thank you!
This is a high quality top notch power automate class. Bravo!
Love your videos, Alireza! This was a particularly great one. Thanks for your fine work.
Awesome content, definitely I will take your courses on Udemy, thanks for sharing!
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!
Great Video!!, i will love to move PDF to one folder and XLS files to another, any suggestion on the optimal way?
Forget about power automate and use SharePoint "content organizer"
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
thanks for the free code about Udemy course. many many thanks to you.
You nailed it I learned a lot thanks
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, it seem to be the perfect answer at my current problem but for me that the "get files (properties only)" only get the folders and not what's inside (mostly pdf and .xlsx) is there something to toggle to extract folders AND what's inside? thanks a lot !
loved that rolling R....
Hi Alireza, great video, Can you make a video where I can get items using "List excel rows action" where the excel file is saved in Documents Library. I want to pass the SharePoint site, documents library name/id, FileName and Table name dynamically. It worked just by using variables but when I promote the solution to Prod env, it failed saying either the get table failed or invalid drive id. Many thanks
How could I bring the size of the items?
Tks for your help!
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.
You show how to get properties, but wow can we update folder properties (SharePoint columns) after we get some values ?
Excelente era lo que buscaba
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?
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!
Scratch that it was working all along, just a coincidence it was finding exactly 100 matches!
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?
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
Super!!! Thank you so much!
Can I make filter query dynamic based on text input
Yes. That's the whole purpose.
Excellent
How do you do this but have the library point to the site page/page library instead of the document library?
I don't know. Let me look into it. If I find an answer, I get back to you.
Thanks you so much. @@AlirezaAliabadi
Got the same issue, only "Document" available in Library Name..
thanks a million .
How to get the CheckinComment property of files using this method ?
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?
I think i can help in this...
hey can you help me with how to convert text property to person type
How can I copy the most recent file from a SharePoint folder?
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 بارك الله فيك
thank you
i get issue with sharept online client browser. it says "Title" not requested? and i dont get the multiple dropdowns as per the video here.
You must be the site collection administrator for the site to use SharePoint Client Browser. Without that permission you are out of luck!
@@AlirezaAliabadi appreciate the reply:) sigh... So much more citizen developer friendliness 😂😂😂😂😂
From get files(property only) how can I get the file content
You cannot. There is another action in Power Automate called "Get file content".