Power Automate - How to search files from a SharePoint document library?
Vložit
- čas přidán 28. 08. 2024
- This video explains how to search files from a SharePoint document library using Power Automate.
Expressions I used in this video is as follows:
substringof('Portal',FileLeafRef)
FileLeafRef eq 'PortalPowerPagesDevProcess-1.png'
FileLeafRef eq 'PortalPowerPagesDevProcess-1.png' or FileLeafRef eq 'PortalPowerPagesDevProcess-2.png' or FileLeafRef eq 'ErrorDetails.txt'
thx a million bro... im gonna get a raise for this help of yours 😊
Thanks a lot for the support.
Thanks that helped me a lot! :)
Glad it helped!
How can I add to this flow to email the file I just searched for? I know how to send the email. I just can't get the attachment to work.
Use the Get File content and pass the id from the previous step which is Get File properties.
Have you tried to fetch the files from between folders like from the test folder from your example? Your example shows the folder at start and end. As per my requirement, I was not able to get the files from between folders. Please advise.
This is so useful! Thank you. Also I would like to ask what is the name of this query language?
Hi
Thanks for the support. Its Microsoft Power Automate. Is that you asking for?
Thanks
can you obtain multiple results? like a search box? for example i look for a document with the word "manual" in it name, so i want to obtain all the files with the word manual in it name
Hi
This should give you more than one.
Is there a way to update a SharePoint list when any file in a Document Library is updated?
I have 14 files in Document Library all named INFORMATION LOG - [LastName] and need to update my SP list when any of those files is modified.
Hi
You could use 'When an item or file is modified' action step?
Thanks
Hi great video, But is it possible to search for a number sequence ? like '####' where #### is a number from 0 to 9999?
Try using the contains? That might work. I haven't tried this from my end.
why is it so hard to know what properties are available to do the filter
like where does FileLeafRef listed in the library, heck where is the documentation for that, certainly there are people like you that posts solution, but just to look for the solution, I really really struggle to get the correct keywords to reach this
if only automate really really can't do stuff, it would be easier for me to say "please stop using it", sadly it works, yet to make it work takes too much effort if you are starting from 0.
Hi
I understand your frustrations. Some where we all need to start. I been working with SharePoint, SQL, Dataverse, C#, etc. pretty much all the Microsoft stack for more than 30 years. Without a doubt that does makes a massive difference. All I could say is don't gave up. Started my first job as COBOL programmer and continued the journey. Learning is the way to go. Put some time and it will reward you in great benefits. Wishing the very best.
Here is the doc
learn.microsoft.com/en-us/sharepoint/dev/schema/row-dsqueryresponse
Thanks
Hi, do you provide course in power automate. Please let me know how can contact you?
Hi Subhro
Please see my channel about contact section.
Thanks
Say you wanted to search all files in the 1234 folder - how do you do that?
Hi
You still need help in this?
Thanks
If google was this complicated to search for files they would have gone out of business years ago! We use sharepoint, No 1 complaint is nobody can find anything. Back in the day before computers it is was a simple matter to go to your local library and look up the location of your book with a card system using the Dewey Decimal system. If only sharepoint was that simple to use.
Thanks for your comments.