How to use Power Automate Get Files (Properties only)

Рет қаралды 32,818

Күн бұрын

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

Пікірлер: 44

@desireesmith4754 7 ай бұрын

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!

@patrick2131 Жыл бұрын

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.

11 ай бұрын

This is a high quality top notch power automate class. Bravo!

@kumailnaqvi5 Жыл бұрын

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.

@IslandGuyTech 3 ай бұрын

Love your videos, Alireza! This was a particularly great one. Thanks for your fine work.

@learningeachday 4 ай бұрын

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)!

@mjmann2402 6 ай бұрын

Excellent! After four years, I am still learning from you 😊!

@goodluckfox Жыл бұрын

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! :)

@chipile 3 ай бұрын

Awesome content, definitely I will take your courses on Udemy, thanks for sharing!

@TechTicTre Жыл бұрын

Super!!! Thank you so much!

@CLINKER30 4 ай бұрын

Excelente era lo que buscaba

@lxz86 Жыл бұрын

thanks for the free code about Udemy course. many many thanks to you.

@narendrakumar709 2 ай бұрын

loved that rolling R....

@issiewizzie 10 ай бұрын

thanks a million .

@rajeshlohana100 8 ай бұрын

Excellent

@Uli2000Ger 3 ай бұрын

thank you

@shathike4079 Ай бұрын

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

@sweecheong848 7 ай бұрын

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!

@jimcopeland4011 Жыл бұрын

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

@isumyfine1079 Ай бұрын

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.

@mariusz9374 Жыл бұрын

You show how to get properties, but wow can we update folder properties (SharePoint columns) after we get some values ?

@prateekjain4308 Жыл бұрын

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?

@AG-mm8un 6 ай бұрын

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?

@rojavarma5277 Ай бұрын

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.

@manudamodar3219 Жыл бұрын

hey can you help me with how to convert text property to person type

@sivashankaripandian1788 2 ай бұрын

How to get the CheckinComment property of files using this method ?

@fr4yaa533 Жыл бұрын

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!

@fr4yaa533 Жыл бұрын

Scratch that it was working all along, just a coincidence it was finding exactly 100 matches!

@sbergonzi 4 ай бұрын

Great Video!!, i will love to move PDF to one folder and XLS files to another, any suggestion on the optimal way?

@AlirezaAliabadi 4 ай бұрын

Forget about power automate and use SharePoint "content organizer"

@CLINKER30 4 ай бұрын

How can I copy the most recent file from a SharePoint folder?

@hasanradi93 11 ай бұрын

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?

@abdulrahmanbaamer8624 9 ай бұрын

I think i can help in this...

@abdulrahmanbaamer8624 9 ай бұрын

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....

@AlirezaAliabadi 9 ай бұрын

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.

@abdulrahmanbaamer8624 9 ай бұрын

@@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 بارك الله فيك