Search SharePoint In Power Apps With No Delegation Warning 

welcome to this platform Matt! this is long overdue. goodluck and more power!

This is fantastic!!!! I'm so excited to have found this video, as I like to keep things cost-effective for my clients by only building apps with standard connectors and SharePoint. You are an absolute genius💡- thank you!!

Thank you very much. This solution still work well until now.

😀 Oh my gosh I'm so glad I found your channel! You are awesome at this!!!

Exactly what I needed. Your walk through was clear and easy to follow and I was able to apply this to a project I'm working on. Thank you, so Amazing!!

Just what I needed this week. Very well explained. Subscribed. Thank you.

Great video! Keep 'em coming! Your blog is required reading for my team and now we get videos too?!?!? Thanks Matthew!

Awesome solution!!! Your blog has helped me so many times in the past and so glad I subscribed last week as now I see you are doing videos!! Needs more cats, maybe on grey wall behind 🐱

So glad to see you on RU-vid ❤

Brilliant, and generous, as always. Thank you, Matthew.

Fabulous content and quality. Love it. Very engaging. Love your emails and blogs too. Your explanations are very clear and provide the right level of detail. I'm looking forward to learning more from you.

Great clear explanation, i like the way everything becomes simple when you explain it. Thank you Mathew

Great video! Super helpful. I really enjoyed how well it explained the topic, and the practical tips it provided were excellent.

What an awesome tip! Thank you, Matthew.

Nice implementation! tx for sharing Mat. Seem like over time content goes better and better. Tx

Brother you work is appreciated this is practical work what any big hiring firm wants appreciated hatts off qudus

I would have never thought of that, fascinating Thanks Matt

You're a life saver, thank you so much Matthew!!

Thank you very much Mathew 😊

Hi Matthew, awesome video!! Appreciate your knowledge sharing! 👍

Wonderful as usual, thank you Matthew!

omg. U are the best. Love your blog! big thanks! (blog is the best!)

That is just awesome Matthew - THX 🙏🙏

Awesome solution. Great work, Matthew.

Thank you Matthew awsome video and super helpfull!!

Thank you for sharing Matthew!

Get stuff man! Keep it up :)

hey mathew You are one of the best teachers I have ever seen. can you make power apps step by step tutorials playslist it would be really helpful.

Thank you Matthew. Definitely leveraging this in a project

Why do you make Power Automate look so easy? My flows hardly ever work 1st time! Didn't know ODAtA search allowed that! Nice!

Hi Matthew, good to see you here in addition to Wordpress

Nice video! Very helpful, thanks for putting this together!

Love your videos. Great job. To work with large sharepoint list what is the best approach? What you use in this video or grpah api? Consodering standard license

Thank you for Video very helpful content to deal with larger data 🙏🙏

Thank you, sir, amazing stuff I managed to get it working perfectly just got rid of the ID

Please do all the videos on the article you have written, this is great

This was awesome Matt. But I ran into a couple of challenges, that I found the solution for. Using "substringof" in the filter query property ONLY WORKS on single line text fields. I needed to search three different fields, two of which are multi-line or note columns. So... I decided to try and use "Filter array" to perform the query. The condition statement I used is... @or( contains(item()?['Title'], triggerBody()['text']), contains(item()?['Description'], triggerBody()['text']), contains(item()?['ActionsTaken'], triggerBody()['text']) ) (NOTE: This will error out if any of the fields is null - if you have the possibility of null fields, you'll need to add "coalesce" into the statement) I haven't tested with "coalesce" but here is that statement for reference... @or( contains(coalesce(item()?['Title'], ''), triggerBody()['text']), contains(coalesce(item()?['Description'], ''), triggerBody()['text']), contains(coalesce(item()?['ActionsTaken'], ''), triggerBody()['text']) ) (NOTE: Using "Fitler array" this way DOES make the search case-sensitive) The trick though, is taking the output of "Filter array" and using "Apply to each" to "Select" only the columns I want ---> Into a "Compose" action where I use the "union" function to load each output from "Select" into a variable called "varSearch" (initialized in my first step of my flow) - the formula I used is union(variables('varSearch'),body('Select')) Then after that, added a "Set variable" action where I load the output from my Compose/Union action into "varSearch". I had to use another "Compose" after that to grab "varSearch", then passed its output to my "Respond to PowerApp" final action. *** Your instruction on the PowerApp side using "ParseJSON" worked perfectly.

Great demonstration Matthew, happilly surprised how fast is the power automate execution

Great video, really helped me! But how can I combine this o an If(Filter and Sort(Filter function I already have that works by filtering more dropdowns ?

Brilliant! Thanks so much!

Thanks Matthew, this is fascinating but yes a bit gnarly as you say. Don't get me wrong but I think it is kind of ironic that for a low-code/nocode experience, this is pretty complex if you have not done it before. As a SQL Dba, I am so tempted to use a Dataverser Table and or a SQL Server Table with a select query instead....? I would love you hear your thoughts on that (pro/cons). Thanks for sharing.

Greetings Mr. Devaney, Thank you for the video. Would this work with an excel doc as the connecting source instead of SP list? If so, where would the changes be?

Great work, Matthew! Thank you very much for the content! I have a question: What if, by an example, I change the column CarMake from a single-line text to a choice? The clearcollect formula or power automate work flow will change?

super helpful. thanks. now i'm gonna see if i can make this work for a document library w/a dynamic # of buttons based on the tags in a multiple-section (something like what you see when you add various filters in Amazon.

Thank you very much for the video!

Sir you are great. Please make a video basic to advance in depth video in power apps nobody covering up.........and who are beginner in power app platform what they have to know before this learn platform that is power apps ....

Nice matt like ur blogs and please do more videos on dataverse

Hey,thanks a lot for the video. I have a question, can you make this work and search in multi-line columns? In the "Get Items" action, when i try the "Substringof" with a multi-line text column, the flow pops an error. is there a work-around?

🔥Awesome solution 🔥

Thank you Matt! I have been thoroughly enjoying the emails and blog. The solutions and education in Powerapps and Flow is premium content. Thanks again!!

Nice one Matthew

Brilliant

Great video Matt , can I just confirm at 6:00 you mentioned the 100,000 pagination and then said if you’re using over 100,000 items in a Sharepoint list then you’d want to use another datasource but is pagination not the amount of items that load a page at a time so you actually could have more than 100,000 items ?

Great video, although I thought it'd cover how to parse the json without using the unsupported experimental feature. But still thanks for the info!

Does this also work on other Templates than form?

Hi Sir, May I know what will be the query if I'll be searching for a number. I believe substringof is working only for Text? Thanks

Cool but very very slow, would not recommend at all

Nope. Bad Gateway.