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!!
Napolean. Thanks for the warm wishes. I hope I can produce some more video content in the future. It will be a process of slowly learning the craft. And how to produce high-quality videos.
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.
I have also searched person fields, lookups and choice columns. www.matthewdevaney.com/power-apps-filter-multiple-person-column-no-delegation-warning/#Filter-A-SharePoint-Multiple-Person-Type-Column-With-No-Delegation-Warning
I'm trying to work this out myself but this is way over my head. Do I just put this in my Filter: @or( contains(coalesce(item()?['Title'], ''), triggerBody()['text']), contains(coalesce(item()?['Description'], ''), triggerBody()['text']), contains(coalesce(item()?['ActionsTaken'], ''), triggerBody()['text']) )
No firm plans yet. But I'm considering a "model" where I create videos for my most viewed/commented webpages. I think that's a firm strategy for success. I don't see myself posting weekly at this point. It would be cool to do "seasons" of content. Think 6-10 episodes with one released each week. Then pause. Then do another batch. Again, these are all just ideas right now.
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 🐱
I really wanted to give video a try because no one else had recorded this solution. It might be fun to do more in the future. Yes, I suppose we do need some cats in the video.
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!!
Neither would I. But I was writing a delegation cheat sheet for SharePoint and started to wonder if I could find a Search function workaround. Then I did this video instead :D
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 ....
I am flattered that you would ask me to do this Akash. Thank you for the compliment :) Right now I will focus on shorter videos. This is my first time making a full-length UA-cam video. Over time, the videos can get longer. Practice makes perfect
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 ?
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?
Yes, that’s true. If you go back and look at Shane, Reza and April in the beginning their videos were rough too. Now they are professional video makers!
Zabi, I think that would be nice to-do. UA-cam is something I would like to do more of. But I also love my written blogs. I wish I could be paid simply to make content!
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.
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
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.
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?
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.
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?
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!!
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 ?
No, you cannot search over 100,000 items in a SharePoint list for the reason I have stated. The flow action will not allow beyond that amount due to limits with its pagination.
Parsing a JSON without the experiment feature is possible. But it’s not the technique I wanted to reach here. I try to reach as few concepts as I can in the same video so people can focus on learning the core topic.
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!!
welcome to this platform Matt! this is long overdue. goodluck and more power!
Napolean. Thanks for the warm wishes. I hope I can produce some more video content in the future. It will be a process of slowly learning the craft. And how to produce high-quality videos.
Thank you very much. This solution still work well until now.
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.
I have also searched person fields, lookups and choice columns. www.matthewdevaney.com/power-apps-filter-multiple-person-column-no-delegation-warning/#Filter-A-SharePoint-Multiple-Person-Type-Column-With-No-Delegation-Warning
I'm trying to work this out myself but this is way over my head. Do I just put this in my Filter:
@or(
contains(coalesce(item()?['Title'], ''), triggerBody()['text']),
contains(coalesce(item()?['Description'], ''), triggerBody()['text']),
contains(coalesce(item()?['ActionsTaken'], ''), triggerBody()['text'])
)
Great video! Keep 'em coming! Your blog is required reading for my team and now we get videos too?!?!? Thanks Matthew!
No firm plans yet. But I'm considering a "model" where I create videos for my most viewed/commented webpages. I think that's a firm strategy for success.
I don't see myself posting weekly at this point. It would be cool to do "seasons" of content. Think 6-10 episodes with one released each week. Then pause. Then do another batch. Again, these are all just ideas right now.
So glad to see you on UA-cam ❤
It’s nice to see you in my comments Lisa. I always recommend your videos to my clients ;)
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 🐱
I really wanted to give video a try because no one else had recorded this solution. It might be fun to do more in the future. Yes, I suppose we do need some cats in the video.
Great clear explanation, i like the way everything becomes simple when you explain it. Thank you Mathew
It helps that I wrote a blog on this topic. I feel like I had a general script in front of me. And that made things easier
😀 Oh my gosh I'm so glad I found your channel! You are awesome at this!!!
Thank you. Thank you.
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!!
Many thanks Julie. I believe this is a total unique video and approach.
Just what I needed this week. Very well explained. Subscribed. Thank you.
I'm glad my first attempt to record a full-length Power Apps video was helpful to you HKRC.
Brother you work is appreciated this is practical work what any big hiring firm wants appreciated
hatts off qudus
Why do you make Power Automate look so easy? My flows hardly ever work 1st time! Didn't know ODAtA search allowed that! Nice!
AssassinUK, I make it look easy because I simply followed my own written tutorial ;)
Thank you Matthew awsome video and super helpfull!!
I would have never thought of that, fascinating Thanks Matt
Neither would I. But I was writing a delegation cheat sheet for SharePoint and started to wonder if I could find a Search function workaround. Then I did this video instead :D
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 ....
I am flattered that you would ask me to do this Akash. Thank you for the compliment :)
Right now I will focus on shorter videos. This is my first time making a full-length UA-cam video. Over time, the videos can get longer. Practice makes perfect
hi, there is no parseJSON in my setting, does it mean it no longer experimental and dissolve in the system?
You're a life saver, thank you so much Matthew!!
Great compliment Steph. Thanks.
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 ?
What an awesome tip! Thank you, Matthew.
You’re welcome David.
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?
Nice implementation! tx for sharing Mat. Seem like over time content goes better and better. Tx
Yes, that’s true. If you go back and look at Shane, Reza and April in the beginning their videos were rough too. Now they are professional video makers!
Thank you, sir, amazing stuff I managed to get it working perfectly just got rid of the ID
Awesome!
Hi Matthew, awesome video!! Appreciate your knowledge sharing! 👍
Thank you Matthew. Definitely leveraging this in a project
Olu, do I know you from Twitter? I know there is an Olu retweeting all of my posts ❤
@@matthewdevaney3912, Yes, you do. I am Oluwatobi Yusuf. My third name is Paul
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.
Zabi, I think that would be nice to-do. UA-cam is something I would like to do more of. But I also love my written blogs. I wish I could be paid simply to make content!
Brilliant, and generous, as always. Thank you, Matthew.
I've never received a finer compliment. Thank you.
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.
Ah, that's so good to hear Helen. Providing just the right amount of details is and art, not a science. And I think about it deeply.
Great video! Super helpful. I really enjoyed how well it explained the topic, and the practical tips it provided were excellent.
Please do all the videos on the article you have written, this is great
That is the natural step forward here. Record my most popular articles.
Thank you for Video very helpful content to deal with larger data 🙏🙏
Thank you for sharing Matthew!
My pleasure!
omg. U are the best. Love your blog! big thanks! (blog is the best!)
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 very much Mathew 😊
Hi Matthew, good to see you here in addition to Wordpress
I think it would be a smart idea for me to make more videos about my most popular articles. Maybe I will give that a try.
Awesome solution. Great work, Matthew.
I appreciate the words of encouragement. I’ll continue to work at the production quality of these videos. Friendly comments like this motivate me.
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.
Great demonstration Matthew, happilly surprised how fast is the power automate execution
I was also surprised at the speed of Power Automate Jean-Remy. The user would never know its connecting to Power Automate because it works so fast!!!
Wonderful as usual, thank you Matthew!
My pleasure!
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?
I am unable to look into it at this moment but I'm quite certain it is possible.
Get stuff man! Keep it up :)
Thank you for the words of encouragement.
I have the data in the SQL data table i need to search 2 or more items a time with single search input box.Thanks
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.
That is just awesome Matthew - THX 🙏🙏
Nice video! Very helpful, thanks for putting this together!
Thanks dude!
Brilliant! Thanks so much!
Glad it was helpful 🐱
@@matthewdevaney3912 You have no idea...it was a total game changer for me. Thanks again!!
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?
Does this also work on other Templates than form?
Nice matt like ur blogs and please do more videos on dataverse
It would be a good idea to do an entire month on Dataverse + Canvas Apps content. I agree
Brilliant
Thank you. More delegation workarounds on my blog this week for multiple person columns.
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!!
Thank you for calling it premium content Bekesam! The best part is, this particular tutorial does not require premium licensing. Only standard.
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 ?
No, you cannot search over 100,000 items in a SharePoint list for the reason I have stated. The flow action will not allow beyond that amount due to limits with its pagination.
@@matthewdevaney3912 great stuff thank you remember bright purple background
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
You cannot Search a number data type. Not possible :(
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!
Parsing a JSON without the experiment feature is possible. But it’s not the technique I wanted to reach here. I try to reach as few concepts as I can in the same video so people can focus on learning the core topic.
Do you mean to use the Parse JSON in power Automate instead of in the Power App ?
Thank you very much for the video!
You are welcome!
🔥Awesome solution 🔥
Thank you
Nice one Matthew
My first full-length :)
Cool but very very slow, would not recommend at all
Nope. Bad Gateway.