Power Apps: 🔍 Search SharePoint Lists without Delegation Issues 💪

[@patelbhargav]

You weren't kidding when you said this video is at an advanced level. I'll have to watch it a couple times to completely understand it. But this is a game-changing technique. Reza does it again. 🙌🙌 Thanks a ton for sharing 😊

[@RezaDorrani]

This was the hardest video to record. Challenge was to explain it in a simple manner that everyone can understand. It would need repeat viewings for sure :)

[@patelbhargav]

@@RezaDorrani Wow! It even pulled up search text that matched the attachment content of an SP Lists item. Not just that, you can even search on text strings or multiple keywords separated by spaces. 🤯

[@RezaDorrani]

@@patelbhargav Yes! I have a lot of these planned in future videos 😊 You could also use * syntax for text search. Like *searchtext* and so much more

[@patelbhargav]

@@RezaDorraniVery clever how you applied Size and From to workaround query return of max 500 records. Does the From value start at 0 and then add or subtract the Size value from it when the Next or Previous button is selected?

[@RezaDorrani]

@@patelbhargav Yes!

[@nathaniel-.-]

My goodness, this video is pure gold! My organization has grown from 7 offices to over 50 in the last 18 months and all our data points have increased by a similar ratio, which has made all our power apps fail at one point or another due to delegation. I am no expert but with a teacher like you, I have full confidence in resolving many of our issues. Thank you!

[@RezaDorrani]

You are most welcome!

[@RobotRisingTech]

Congrats on the business growth!

[@even7horizon413]

Great work my man, well done in finding a way to make API calls inside Powerapps in a standard license. Thats an amazing find, the way I've been doing it is using flow to make all my http requests.

[@RezaDorrani]

Thank You! However, I dont believe the fact that Office365Groups connector supporting SharePoint will stand the test of time. I already have a workaround on that I am evaluating on. My next video will give you more insights into that technique.

[@RezaDorrani]

Technique I plan to showcase will include flow but it will have power to query search api. Key is getting to search api.

[@ylmazozturk06]

@@RezaDorrani When will you release the video? It's not working properly for me. :(

[@RezaDorrani]

@@ylmazozturk06 Best to hit the bell icon to get notified whenever my new video releases. I have finished my graph video series. Check playlist on graph api on my channel.

[@ManofFan011]

Thank you Reza. It’s seems with the api, I can look into multi column filters that’s is performant friendly!

[@RezaDorrani]

Yes, you are right and thanks for the appreciation

[@joelguay4452]

This technique, with some modifications enabled me to query a list with 5.7 million Rows ! Simple Filter was taking minutes to load with proper delegation, and Using Powerautomate couldn't query the whole list. Graph is truly something else !

[@RezaDorrani]

Awesome!!! Graph is the best option for searching in SharePoint specially with the batching options. I wish folks stop loading tons of data in collections and stop using get items in flow to send large data back to Power Apps.

[@RobotRisingTech]

This is incredible, when the video first started I was thinking "oh yeah, we can make an http request through power automate for the search" I had no idea I could access that directly in power apps with standard licensing. This is a GAME CHANGER

[@RezaDorrani]

Thanks. I don’t foresee the groups connector supporting SharePoint for long. So we would need options to call the SharePoint graph api by some means. I have another approach. I will be showcasing it next week.

[@RobotRisingTech]

@@RezaDorrani exactly what I was thinking. Microsoft is going to see this and remove it but they really need a solution here that doesn't involve combining multiple collections or pulling everything in from Power automate. Direct access to SharePoint search through http would be ideal. But for now, not hard for me to rewrite some apps using this to make them more efficient

[@RezaDorrani]

Backward compatibility should be supported so I don't foresee existing apps being impacted but new apps (in future - whenever the change comes in) will not be able to leverage the v1 endpoint.

[@ericmild4050]

Thanks! This is a game changer for me. I've got a lot of re-writing to do. Great stuff. Keep up the amazing effort and work.

[@RezaDorrani]

Great to hear! Let me know how it goes.

[@Saif_Ali_Khan_1301]

amazing, I was stuck in file in graph api query, now I learnt from you how to work with graph api, Many Thanks Reza. Jazak Allah Khair.

[@RezaDorrani]

You are most welcome

[@oluwatobipaul6171]

Thanks for this detailed video on using Graph API to avoid delegation issues. The search crawling schedule that takes 15 minutes is a huge limitation in applying this for my use-cases. Thanks Reza

[@RezaDorrani]

Search crawling schedule cannot be modified. If your scenario is real time then this is not an option and you would fall into delegation challenges. There is always a give and take.

[@sergii845]

I can't thank you sufficient for all your content which make me keep enhancing... Another gem..

[@RezaDorrani]

My pleasure!

[@pathimohanadurgasai7816]

Much needed and awaiting!!! It's much appreciated that you researched this hard to solve this. Great!!!!

[@RezaDorrani]

Thank You so much for the appreciation. It indeed was a lot of work on research.

[@simonball5602]

God mode. You’re a different level Reza! Thank you for sharing your talent.

[@RezaDorrani]

Wow, thank you for your kind words

[@ArijitDas-fr8ss]

This is a Game Changer, Reza. Thanks for teaching us.

[@RezaDorrani]

Glad to hear that!

[@Test-oc1fr]

Wow... Amazing... Even though we are getting the results, it sounds little difficult for a citizen developer like me. Big fan of yours Reza ❤. Since powerapps is low code development tool, it should bring something which will provide same results with minimal steps.

[@RezaDorrani]

Thanks so much. This was a find using a recent update on Untyped Objects. It was a lot of work to get the results. This is by no means a beginner or intermediate level video.

[@zohaibakhtar3628]

Thanks Reza sir for the insightful content. This Delegation in Power Apps was a big challenge, I would be implementing the entire graph api call on few of my apps to test it. Big thanks to you again, you have been doing great with these contents. Always a fan of your videos.

[@RezaDorrani]

Most welcome!

[@aescamilla]

Fantastic video, I am able to search for folders in our SharePoint library and return the webUrl for project storage thanks to this video... thank you so much Reza 😃

[@RezaDorrani]

Glad it helped!

[@imranpearl]

Oh my God bro, you are a rockstar. such a advanced insight in this video. it will take me several re-views of this video to grasp and apply this feature. Hats off to you.

[@RezaDorrani]

Thanks a ton! Yes, this would need repeat viewings

[@nuk3r139]

Great sample, thanks for sharing! Just a consideration: SharePoint Lists Connector for PowerApps (should) uses behind the scene the SharePoint APIs for Lists and these does not require indexing time (so you can get data in "real time"). Graph Search API needs that the data will be first indexed and processed and, despite this time should not take long, is actually not predictable 🙂

[@RezaDorrani]

Key point here is Searching. Lists connector does not support searching in large lists. All of this is explained at start of video.

[@mgopic]

Omg, watching this on mobile. Can’t wait to try on system. Great stuff

[@RezaDorrani]

Thanks for watching and let me know how it goes.

[@kiran_gawade]

This was very helpful when we work on large dataset. Always learn from your videos. Explained in basic language and easy to understand.

[@RezaDorrani]

Glad it was helpful!

[@AshleyWeller-vq8zn]

Thank you so much Reza. This video has opened up more opportunities in creating complex PowerApps solutions.

[@RezaDorrani]

Most welcome

[@vemurisrinivas5832]

As usual a gem of a video. Thanks a lot Reza.

[@RezaDorrani]

Many thanks!

[@PrasadJoshi-k5r]

The Post request example was not available anywhere. This video saved lots of efforts. Thanks Reza!!

[@RezaDorrani]

Glad it helped!

[@DNCubeVlogs]

Thanks a lot Reza, So far its once of the show stopper for few scenarios. Now we can play with it. Loved your presentation. Thanks again.

[@RezaDorrani]

Most welcome. Please be mindful that it uses Office365Groups connector that currently does support these Api’s. In my next video, I will show 2 approaches, that ways we also have multiple options.

[@DNCubeVlogs]

@@RezaDorrani Sure, waiting for your videos.

[@robgallagher2006]

Excellent video, thank you :) ... using this now and adding filtering on the gallery so the displayed results only come from one column. Daunting to begin with but now it is making perfect sense :) .. keep the great work up

[@RezaDorrani]

Glad it helped!

[@kanakarajunaiduthota2417]

Thanks for timely video, we were looking for this solution last two weeks and you gave the perfect solution Reza, tons of thanks for your efforts in making such a great solution and video 🎉🎉🎉

[@RezaDorrani]

Thanks. I have an option for searching with SharePoint APIs as well. I will plan a video around that in the coming weeks.

[@jatinsaini7773]

This is what we were expecting…. Amazing work ❤

[@RezaDorrani]

Thank you 🙌

[@sujisam5508]

Wow...Thank you so much Reza 😊 Very useful as usual

[@RezaDorrani]

Most welcome

[@dougydoe]

Well well, what can I say again. I just had to upgrade to Silver level to download the solution. 😁. Again, it needs a couple more times of watching for it to sink in but they way you take the time to break things down is highly commendable. Having configured Search in On-premise SharePoint, I quickly remembered the managed properties feature. The Graph API is certainly a place I need to research into more. Great video, great content. Thanks for sharing.

[@RezaDorrani]

Boom! Thanks so much and welcome to the Silver Club.

[@tbone536]

@@RezaDorrani I'm struggling to find the app download on the Community tab. Is it because this is from 8 months ago?

[@RezaDorrani]

@@tbone536 You will need to look for the post. No posts are deleted.

[@franknielsen3219]

Wow wow wow. That was a crazy great video Reza 👏👏👏👏👏

[@RezaDorrani]

Glad you enjoyed it

[@shubhamsatpathy6489]

You are helping a lot of us . I salute you .

[@RezaDorrani]

Thank You

[@shaikhfirdos2723]

Truelly amazing video once again...Thanks Reza for sharing brilliant trick..

[@RezaDorrani]

Thank you! Cheers!

[@HaiNguyenMD]

Perfect as always Reza. Thanks for all you do.

[@RezaDorrani]

Most most welcome

[@turisabela]

What a great video, Reza! It really helped me a lot! Thanks!

[@RezaDorrani]

Glad it helped!

[@ambarish360]

❤ Really a great work Rezza, i tried similar things 2 months back, no luck, i was struck in the "file" parameter, thanks a lot to You and Hiro for decoding the the way and exploring to new heights.🎉🎉

[@RezaDorrani]

You're most welcome! It was Hiro's find and he deserves all the kudos.

[@georgegualda4262]

Excellent video like the way you take the time to explain all the steps. Can't wait for the next one.😊

[@RezaDorrani]

Thanks so much! 😊

[@wrmbanks2260]

Holy Moly! Brilliant video!

[@RezaDorrani]

Thank you very much!

[@laszlokovacs7411]

Awesome! This solves a million issues!

[@RezaDorrani]

Yes it does!

[@林先生-e5d]

Man, you're really the game-changer! Could I make a wish for the next series about having no choice but to stick with Dataverse?

[@RezaDorrani]

Thank You! Here is my playlist on Dataverse Microsoft Dataverse kzbin.info/aero/PLTyFh-qDKAiHr7HwkvlHXpCNf73xNBqj_ Tell me what other ideas you have in mind? I make videos when multiple requests are made for a topic. I listen to the audience. When I hear a common voice, I plan for that video.

[@anilkumar-ml2sl]

well I watched it, but i know when i am going to do it myself, it will be like a mountain to climb,, appreciate your efforts Reza, awesome explanation as always :)

[@RezaDorrani]

Thanks so much. This surely is an advanced level video.

[@JasonRoberts-zk5ns]

Wow that's next-level stuff! Nice solution to a common pain point for us app makers who rely on SharePoint. (And looks like I need to study up on Graph APIl...) Thanks, Reza.

[@RezaDorrani]

Awesome! So happy to hear that. I would definitely recommend learning about the Graph API.

[@tomaschudik]

Thanks a lot for sharing this sample! One additional problem for me is how to sope query to a list within a second level subsite.

[@RezaDorrani]

Check documentation to see how that can be done. I have not tried it.

[@randylahey7933]

I've been getting around the 2,000 row limit using a combination Filter(LookUp()) function, and it has worked for years in large lists that are even over 10,000 items. But this method seems way more reliable and easy. Guess I'm going to need to go back and update all my apps.

[@RezaDorrani]

This is true Search in action. Filter and Lookup technique is not a performant option.

[@x12624]

​@@RezaDorrani In case of data verse, would you use Search too as opposed to Filter/Lookup? and why? I haven't used search function for data verse, filter function takes few seconds to retrieve the data even when the filter is on an indexed column.

[@RezaDorrani]

@@x12624 search is a delegable function in dataverse

[@Mario-jv2dc]

Amazing work. Thanks, Reza.

[@RezaDorrani]

Thanks

[@GuyBerthiaume-ScaleModels]

Great video and just what I needed! Unfortunately, I have an issue at 11:03 where my variable is boolean when it needs to be a UntypedObject. I did enable "ParseJSON function and untyped objects", saved my project, and reloaded it but the variable type remains boolean. Any ideas what might be causing this?

[@RezaDorrani]

Remove and re-add the office 365 groups connector.

[@GuyBerthiaume-ScaleModels]

@@RezaDorrani Thank you, that solved the issue! 🙂

[@RezaDorrani]

@@GuyBerthiaume-ScaleModels Please note- Office 365 groups connector http supports this api today. There is a v2 http which does not. In future videos, I plan to show other options with azure http as well to call graph api.

[@clausdev85]

@@RezaDorrani Looking forward to seeing this :)

[@vonis22]

@@RezaDorrani Had the same issue, I am so grateful that you even address these comments! Legend :)

[@zulnordin8041]

Thanks for another informative video Reza. My brain is overloaded now trying to digest all this. Hopefully I can fully understand this tomorrow when in office. 😂

[@RezaDorrani]

You can do it 😉

[@mahamkhan8314]

Super Interesting stuff Raza, I'm gonna use this in my next project. Really helpful and very thoroughly explained.

[@RezaDorrani]

Glad it was helpful!

[@szechan8958]

Reza, thank you for spending the time to put together this tutorial! I have a follow-up question about the tutorial. In order to use Microsoft Graph API, is there any prerequisite that I need follow or things I need to activate? I was able to use my work Enterprise license and test using Graph Explorer. After copy and pasted all the code for the "Bottom", I got an error that reads: Can you point me to the right direction on what to Google/search to resolve this error? {"error":{"code":"InvalidAuthenticationToken","message":"Access token is empty.","innerError":{"date":"2023-08-11T17:33:43","request-id":"XXXXXXXXXXX","client-request-id":"XXXXXXXXXXXX"}}}

[@RezaDorrani]

Most welcome! Video description has link to download sample app (members only) I have not come across the issue you are mentioning and hence not sure what the fix for your issue is. I recommend posting your issue with screenshots on the forums at powerusers.microsoft.com

[@AshutoshDubeyCivil]

Long awaited.. thanx Reza...

[@RezaDorrani]

Most welcome

[@Basjuh1984]

Really cool stuff! Perfectly explained and helpful!

[@RezaDorrani]

Glad you enjoyed it!

[@ajitsharma1377]

Thank U Reza, one of the must needed solution for SP connector and as always it is from you 😊

[@RezaDorrani]

Glad to hear that

[@suebrower2275]

Brilliant! This is a game changer!

[@RezaDorrani]

Yes, as long as office 365 groups connector supports search api.

[@mahasahytsilavorakotobe7515]

Thanks 👌and search with SharePoint Document Library no delegation, you can make a video please?

[@RezaDorrani]

Its already done kzbin.info/www/bejne/rqa1XqyXgtB5esksi=2l3tCmlzxGC-Y-cv

[@aaron6516]

Reza... you are a wizard 🧙‍♂️ how much would you charge for a week??? Just a week for mentoring 2 people!! You seriously do such a great job explaining in detail how to make things we really need like this!!!

[@RezaDorrani]

Thanks. Check about me tab on my channel for details about my email.

[@MAPinkard]

Amazing as usual, Sir!

[@RezaDorrani]

Thank You Sir

[@hamytube]

Thank you so much @reza for this amazing tutorial.

[@RezaDorrani]

Glad it was helpful!

[@patelbhargav]

To make things even more convenient, Hiro has updated his blog post to apply the fix you have demonstrated in the video.

[@RezaDorrani]

Hiro is a true Hero

[@Learning-Account]

It would be Great work around, excited 🎉

[@RezaDorrani]

Hope you like it

[@yenumulavenkatesh2372]

Thanks Reza for exploring new things

[@RezaDorrani]

Most welcome

[@dineshb]

Wow.. amazing video as usual

[@RezaDorrani]

Thanks so much

[@kursadkozelo889]

So many people in this comment section with the same feels about this video😂 We owe you big time, Reza!

[@RezaDorrani]

💗

[@apenn-nd9ke]

Thanks so much for this and all your video's they have been so helpful as I've started building power apps. This helped greatly implement a feature our users wanted. For any who are having that error in the base 64 code replace the double quotes from char and dec with single quotes or remove entirely. looks like the syntax has been updated since it's posting.

[@RezaDorrani]

That syntax was picked from a reference blog post.

[@M1A2-Tanker]

Reza, this is working for me up until 11:09 of your video. The searchResults is not coming up as UntypedObject. Any idea of what I'm doing wrong? Many thanks for your videos.

[@RezaDorrani]

Check video comments for step to fix. 2-3 folks asked similar question.

[@M1A2-Tanker]

@@RezaDorrani Will do. I cannot tell you enough how much your videos have helped me.

[@adirnagar6940]

Amazing ! works like magic ! One question : can you explain how the "next/prev" buttons work please ? didn't figure this out :)

[@RezaDorrani]

That was done using a bit of maths based on total results returned and results on page. I have shared entire App - link in video description (member only)

[@adirnagar6940]

@@RezaDorrani Thanks ! one thing i noticed is that you can't apply more filters on it ? only search ? and the columns must be site columns / refinables right ?

[@RezaDorrani]

@@adirnagar6940 You can search and filter. Check the documentation. Columns can be site and list columns. In my demo the custom columns are list columns but better option is site columns.

[@chap666ish]

This is a great video, Reza. Thank you! If only PowerApps could do this out-of-the-box instead of forcing people to do so much work...

[@RezaDorrani]

When selecting data sources like SharePoint, one has to come up with workarounds. Dataverse is the native database of the power platform and hence offers maximum flexibility and ease of use.

[@chap666ish]

@@RezaDorrani Ok, let me rephrase "if only PowerApps could do this out-of-the-box" to "if only Microsoft didn't charge extra for Dataverse". I work for a not-for-profit wildlife conservation charity. We either spend money on Dataverse or spend money on saving endangered species...

[@RezaDorrani]

@@chap666ish Ok

[@caraziegel7652]

@@chap666ish i know microsoft will give some allowances to non-profits, have you already taken advantage of that?

[@chap666ish]

@@caraziegel7652 Thanks, yes I'm aware of that and we do get a preferential rate, fortunately.

[@artwellnjanji]

thanks Reza great stuff✊. Just out of curiosity, is there a way to filter the query results based on 'Created by' so that the users can only see what they have created.

[@RezaDorrani]

I believe in the search api itself you can add filters. I have not tried it though. Check documentation on search api for details.

[@cloudhoang8360]

thanks Reza!! About search query, where can I learn to write the custom query? About flelds, do I need create those fileds in sharepoint admin and re-index it to use the query?

[@RezaDorrani]

Documentation would be the best resource. Managed properties is the key. You need to map crawled properties to managed properties. Indexing of search is automatically done in SharePoint Online. Admin does not control the crawl schedule.

[@benseaburg9608]

Wow this is fantastic, thank you so much Reza! If I would like the users to not see the search button and the gallery items to appear as the text is typed in the search box, could you please advise on this? Thanks!

[@RezaDorrani]

On change of search text box, use Select function to call the button. You can hide the button on screen.

[@benseaburg9608]

@@RezaDorrani perfect, thank you so much!!

[@nelsonedson]

Thanks for the excellent content Reza! I've been trying to figure out a way to use this search for other columns but the title (as your example) and not having success. Any ideas or help to point me to the right documentation to study/ refer to?

[@RezaDorrani]

Check documentation on graph api search endpoint.

[@philippbernhardt7286]

Amazing Reza, working like a charm! Do you think there is a way by chance to be able to sort the results from A-Z? Or to include a "contains()" to be able to search for parts of words? Anyways, great job!

[@RezaDorrani]

Most welcome! Graph api has plenty of options. Im not sure if these options are available.

[@Jgeethika]

Great video and just what I needed! Unfortunately, I have an issue at 11:03 where my variable is boolean when it needs to be a UntypedObject. I did enable "ParseJSON function and untyped objects", saved my project, and reloaded it but the variable type remains boolean. Any ideas what might be causing this? Please advise me

[@RezaDorrani]

save and publish app, edit app, remove the connection to office365groups or any other connector returning json, and then re-add it.

[@simplyd.6042]

Thank you very much Reza, your a Godsent! Question though, how long does it take yours to search an item? mine looks like its taking about 11 secs to search. Do you have any suggestion on how to optimize it?

[@RezaDorrani]

Mine was taking around 2-3 seconds. Data is returned in batches by the api so it should not take that long.

[@tgamradt]

I ran into a problem with special characters like ä ö ü. They don't get encoded into base64 properly. I still don't understand why, because they are part of the 256 character ASCII table, but it also doesn't work in online encoders unless you set them to UTF8. However, turns out I don't need to care because SharePoint search converts that to a o u and lowercase anyway as one can see in the API Explorer results. So all you need to do is replace the special characters by the their non-accented counterparts before conversion and everything is fine. Thought I'd leave this here if others run into the same problem. Thanks Reza!

[@RezaDorrani]

Thanks for sharing!

[@paragkeshardas8139]

only title is selecting ..if i am using diff name like SalesPerson which is a column ion my list it is not showing

[@RezaDorrani]

This is using search api. Your columns crawled property needs to be mapped to a managed property. Check documentation on SharePoint search properties.

[@Saf1-rv9by]

Hello Reza, Great video, very helpful. Tried to do this months ago using powerautomate and SharePoint search rest api but the results were mediocre.

[@RezaDorrani]

This is a lot faster and performant when compared with trying with power automate.

[@jimpowers7603]

Great video Reza. Even though I turned on the Untyped objects setting in my app, the SearchResults variable is still being returned as Boolean. I check the monitor and I can see the results being returned, with "responseType":"pabinary" in the JSON. Any thoughts? Thanks.

[@RezaDorrani]

Check video comments for steps. I have responded to others with the steps needed for existing apps.

[@jimpowers7603]

@@RezaDorrani Got it. Thanks.

[@nduagubadev]

This is great Reza. I wan to ask, Can we also do filtering and sorting the normal way or would there need to be some changes using this graph method?

[@RezaDorrani]

Filtering and sorting options are available. Check graph api documentation.

[@MarcRossmann]

WOW What big mission getting this method and code to work. Power Apps shows errors! No luck!

[@RezaDorrani]

I have not come across any issues, hence not sure. Video description has link to download the entire solution (members only - check description for details)

[@umamaheshwari7472]

Thanks for the perfect method to avoid delegation. I still have questions on the search schema because I'm not able to find the managed properties for the custom columns which I have created. Do you have any idea about it?

[@RezaDorrani]

You will need to map managed properties to crawled properties for your custom columns. Check documentation on managed properties in SPO.

[@natcongreso2763]

This is perfect! But this still consider the SP Permission right?

[@RezaDorrani]

It will respect security

[@HumanityFirst24]

This is great. Thx Reza.

[@RezaDorrani]

Most welcome

[@Rebecca_D_HW]

Hi Reza, thanks for a great tutorial video. This is a really useful topic for me as I am currently trying to implement a search myself. I have replicated what you have done and the search is working for me for all but one part. I have a custom column that is mapped to a managed property in the search schema, and I know the managed property has data as it works with the REST API, but when I try to return it in the search using the above method, it is not returned as part of the Fields property of the JSON. Is there anything you can think of that might cause the issue, or is there any documentation you can point me to to help?

[@RezaDorrani]

I am not aware of this issue and not sure what could be the cause of it. Best documentation would be on docs.microsoft.com

[@guillermorojas2000]

Same problem here, did you found a solution?

[@MrDezra]

Same Problem here. Did anyone figure out a solution

[@DeadLoon]

Was in the same position and ended up ditching a custom managed properties for the pre-made refinable properties. I'm using text so I started with RefinableString00, and mapped the crawled property of a column to it. Then I reindexed the site and the list (get more detail on how on google and don't know if it's necessary to reindex both) then after it was done reindexing in about 15 minutes, I started getting the results I wanted.

[@garimatewari2212]

Hi Reza, amazing video. Have you done any video to create custom layout for pnp search results webpart in SharePoint?

[@RezaDorrani]

I have done no work with PnP search.

[@RihabHamila]

Hi, Thank you for the content(pure Gold 🥇). I know the video is a bit old But I have a question: this method can work with a LookUp Column in a large SP List(More than 20 000 items)? Thak you

[@RezaDorrani]

Most welcome! It uses search api so should work

[@RihabHamila]

@@RezaDorrani Thank you for your response. 👍

[@anantchirmade600]

Great, will try to use Graph API to link with Sql server table

[@RezaDorrani]

I would like to know if that works. I have done no work with graph and sql.

[@mdshahrukh1034]

Hi Can You Help me With Managed Metadata Column. I have 5 cascading dropdown and I had create collection named as " CombineValues" which combine all 5 dropdown value into One and pass that collection name to a Combo BOX and get all the dropdown value in ComboBox. But I have to save that combo box value in My Share Point list colum of Managed Metdata How would I do that. HOW WOULD I Patch that.

[@RezaDorrani]

This is not something I have tried or come across this scenario hence I am not the best person to comment on this. I recommend posting your issue/query with screenshots on the forums in case someone has done something similar powerusers.microsoft.com

[@mdshahrukh1034]

Can you make a Video on this topic because I had not seen this video any where

[@RezaDorrani]

@@mdshahrukh1034 I make videos when I get multiple requests on a particular topic. Every quarter I ask subscribers for topic suggestions on the Community Tab of my KZbin channel. Subscribers vote for topics and the highest voted topics get added to my backlog. Make sure you post this in the next topic suggestion post. If it gets a lot of votes, I will add it to my backlog.

[@leshe5360]

Hi Reza, Thank you for sharing this, it will be very helpful for us. One question though, Which credentials are we using here? Is it the access of the account using the App?

[@RezaDorrani]

Its the user account running the App. Search API will respect SharePoint security

[@leshe5360]

@@RezaDorrani Will it be possible to set a specific Credential we are using to access the API? So that we wont need to share the Access of Sharepoint to users.

[@RezaDorrani]

@@leshe5360 Office365Groups connector only works with delegated permissions which is user permissions. This is not the solution to not giving users access to data. I have not ever done that or come across the scenario.

[@manuelluiscoelho6874]

I used this in some of my apps, very useful and indeed gamechanger! However, I only can call title and other few standard columns. How did you put your list columns in the Managed Property? I tried creating a site column but It doesn't appear in the Managed Properties... It was perfect if I could add my list columns. But it needs to be by site columns, do you have a video on that or something? Thank you very much, you have been helping me a lot!

[@RezaDorrani]

Most welcome! I do not have any video references on mapping managed properties. Check documentation for that one. I believe there are a standard set of managed properties that are available that you would need to map crawled properties to.

[@samiransamajpati6881]

It is really a game changer. But I am having a minor doubt is this Search API respects item level permissions for SharePoint lists?

[@RezaDorrani]

Yes, it will respect all permissions

[@ИванВеселиновић]

This is perfect! I was just wandering if this can be applied to Excel as a data source? We have some very specific Power App which is more like report, and the source for it is one quite complex calculation in Excel, so it would be to complicated to upload each time to SharePoint list. Since Power App is only reading data from it it seems like logical to keep using Excel as a data source. Of course, currently we have the delagation issue. What do you think, could this method be a good solution for this kind of scenario?

[@RezaDorrani]

The technique showcased in video uses the search api which only works with SharePoint and OneDrive. I do not have any workarounds for delegation with excel + excel is surely not a good data source of choice with power apps specially when dealing with large excel files.

[@Sunilprakashsabbithi]

Wow i think this is one of the highest level.. Thanks Reza... i think we need to watch it couple of times to understand it clearly...

[@RezaDorrani]

Thank You! This video would certainly need repeat viewing.

[@rob2d3]

Love it, game changing

[@RezaDorrani]

Thank You

[@santukondapally]

Awsome Reza you are always my powerapps Guru... One question is how to filter the gallery based on user enter text in the text box in this scenario. is it the same way or any other approach for it as we are using .. do we need to enter on change event of the text box. Can you please let us know

[@RezaDorrani]

Most welcome. I have done many videos on gallery filtering. I would recommend checking those.

[@santukondapally]

@@RezaDorrani this is a little bit tricky. however i tried this in gallery items property IT WORKS now .Filter(Table(Index(Table(Index(Table(Searchresults.value),1).Value.hitsContainers),1).Value.hits),StartsWith(Value.resource.fields.title,TextInput1.Text)). However ,why my gallery count shows only 25 items and my Total items shows 41367. When i click on button it shows the item in the gallery? any suggestion where i can get the item with out button click.

[@RezaDorrani]

@@santukondapally I cannot guess here on chat by looking at a formula. I would have to try this exact scenario to know more.

[@3MaliksConsulting]

very well explained !

[@RezaDorrani]

Thanks

[@jarekjedi]

Search works great but I’m currently managing user access to the data via power app by filtering SharePoint list based on one of a column. Is there any possibility to also apply filter on the list as well? I’m getting too many results with search picking up info from other columns.

[@RezaDorrani]

Search can also perform filtering. Check my other videos on graph and searching.

[@kurthenderson6848]

Hi Reza, I implemented this solution about 4 months ago and it has been working great. Then recently, it was not finding records that I new existed. What's odd is that if I open that record in SharePoint and change something and save, within the 15 minutes, it finds the record again. Have you heard of anyone else having this kind of issue? Any ideas on troubleshooting? As always, thanks for all you do for the Power Apps community.

[@RezaDorrani]

Hey, have not come across or heard about this.

[@TheNeoxus]

Hi Reza, amazing tutorial, seems perfect, except I encountered one issue. When I use total search results, it shows me the exact number from the API search. But the gallery itself does not reproduce any results, I double-checked the Items on Gallery and Title-Subtitle many times, but even in edit mode it does not show any results. Do you have any suggestions? Btw, amazing tutorial, loving it!

[@RezaDorrani]

Thanks so much! I have not experienced the mentioned issue, hence not sure. I will recommend checking or posting your issue on forums in case someone has experienced something similar community.powerplatform.com/

[@TheNeoxus]

So my issue was if someone experiences the same: Table(Index(Table(Index(Table(searchResults.value),1).Value.hitsContainers),1).Value.hits) In the searchResults.value for some reason power apps changed it to searchResults.Value, with capital V. And that caused the issue, because the object is "value" not "Value". It took me almost a week to figure it out :D But amazing stuff Reza, much appreciate!

[@andrewcassells9391]

Hi Reza, I have tried this method but seem to be hitting a stumbling block with the Encode to base 64 code. It seems to bring up errors on the AddColumns formulas, specifically the "char" in inverted commas and the "dec" within the Concat formula. It shows an error saying "Expected identifier name". Do you know why i would be getting this and how to fix it?

[@RezaDorrani]

Im not sure why. That part of the code was referenced from a blog post.

[@djjamba14]

The AddColumns documentation does not say you should surround your new column with quotes - remove the quotes around char and dec

[@jansentan4597]

@@djjamba14 worked like a charm! will relay this as latest comment. thanks!

[@spen2431]

I'll stick to Dataverse 🤯 - Thanks for sharing Reza

[@RezaDorrani]

I ❤️ Dataverse

[@brunoamaral3091]

Hi Reza, you are a wizard of power Apps. I managed to get the results as per the video from the search query in graph API, however, I couldn’t retrieve the custom fields from my list. I have created custom site columns, for example “SupplierName” which generated the crawled property “ows_Suppliername” that I used to map the managed property “SupplierName”. However, the search doesn’t retrieve it. Any idea why?

[@RezaDorrani]

Check documentation on managed properties in search. There are many managed properties already pre created that you can use by simply mapping your crawled properties to it. I have not come across any issues hence not sure why its not working in your scenario.