How to use Power Automate Get Files (Properties only)
Vložit
- čas přidán 31. 07. 2024
- Get files action in Power Automate is used to get a list of files from SharePoint Libraries. In this video you will learn everything you need to know about Get Files and how to use it in your flows.
To enroll in my Udemy courses see below link for discount vouchers sslwsh008.securedata.net/dotn...
OData Cheat Sheet
help.nintex.com/en-US/analyti...
SharePoint Online Client Browser
github.com/bramdejager/spcb/r...
This video contains:
0:00 Introduction
1:00 SharePoint library setup and Power Automate Flow
2:05 Understanding Get Files basic function
3:10 Simplifying Get Files output using Select and Filter actions
9:00 Get files limitation of 100 files
11:42 Get files Filter Query OData
12:20 Introduction to SharePoint Online Client Browser
13:03 Using SharePoint online client browser to capture field internal names
14:54 Introduction to OData filter
15:15 Using OData filter inside Get Files action
17:54 Sorting the items that Get Files returns
19:52 Limit Columns by View
22:15 Conclusion
Contact me
- LinkedIn / alirezaaliabadi
- Twitter / aaliabadi1
- Instagram / alireza.aliabadi_ig
- Facebook / alireza.aliabadi.fb - Věda a technologie
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 a high quality top notch power automate class. Bravo!
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!
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.
Love your videos, Alireza! This was a particularly great one. Thanks for your fine work.
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)!
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! :)
Excellent! After four years, I am still learning from you 😊!
Awesome content, definitely I will take your courses on Udemy, thanks for sharing!
thanks for the free code about Udemy course. many many thanks to you.
Super!!! Thank you so much!
Excelente era lo que buscaba
loved that rolling R....
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!
thanks a million .
Excellent
thank you
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
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.
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
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.
hey can you help me with how to convert text property to person type
You show how to get properties, but wow can we update folder properties (SharePoint columns) after we get some values ?
How to get the CheckinComment property of files using this method ?
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"
How can I copy the most recent file from a SharePoint folder?
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?
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!
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..
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...
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 😂😂😂😂😂
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 بارك الله فيك