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!

[@sergii845]

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

[@RezaDorrani]

My pleasure!

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

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

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

[@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

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

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

[@ArijitDas-fr8ss]

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

[@RezaDorrani]

Glad to hear that!

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

[@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!

[@PrasadJoshi-k5r]

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

[@RezaDorrani]

Glad it helped!

[@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!

[@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!

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

[@AshleyWeller-vq8zn]

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

[@RezaDorrani]

Most welcome

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

[@simonball5602]

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

[@RezaDorrani]

Wow, thank you for your kind words

[@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

[@林先生-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.

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

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

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

[@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 😉

[@kursadkozelo889]

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

[@RezaDorrani]

💗

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

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

[@jatinsaini7773]

This is what we were expecting…. Amazing work ❤

[@RezaDorrani]

Thank you 🙌

[@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!

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

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

[@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

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

[@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! 😊

[@franknielsen3219]

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

[@RezaDorrani]

Glad you enjoyed it

[@vemurisrinivas5832]

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

[@RezaDorrani]

Many thanks!

[@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!

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

[@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

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

[@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

[@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

[@sujisam5508]

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

[@RezaDorrani]

Most welcome

[@turisabela]

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

[@RezaDorrani]

Glad it helped!

[@HaiNguyenMD]

Perfect as always Reza. Thanks for all you do.

[@RezaDorrani]

Most most welcome

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

[@shaikhfirdos2723]

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

[@RezaDorrani]

Thank you! Cheers!

[@shubhamsatpathy6489]

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

[@RezaDorrani]

Thank You

[@laszlokovacs7411]

Awesome! This solves a million issues!

[@RezaDorrani]

Yes it does!

[@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)

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

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

[@Basjuh1984]

Really cool stuff! Perfectly explained and helpful!

[@RezaDorrani]

Glad you enjoyed it!

[@wrmbanks2260]

Holy Moly! Brilliant video!

[@RezaDorrani]

Thank you very much!

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

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

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

[@Learning-Account]

It would be Great work around, excited 🎉

[@RezaDorrani]

Hope you like it

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

[@MushangasMachinimaMovies]

This looks amazing, thank you for your hard work in figuring all this out! :) For now, this is quite a bit beyond my Power Apps skill level, but we may have need of it soon. This example focuses on searching a big Sharepoint List, but I'm assuming searching a big Sharepoint Document Library wouldn't be too different?

[@RezaDorrani]

Search document libraries would be similar. I have a video lined up on that as well. Video description has link to download sample solution (for members only)

[@suebrower2275]

Brilliant! This is a game changer!

[@RezaDorrani]

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

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

[@Mario-jv2dc]

Amazing work. Thanks, Reza.

[@RezaDorrani]

Thanks

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

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

[@hamytube]

Thank you so much @reza for this amazing tutorial.

[@RezaDorrani]

Glad it was helpful!

[@NKBobcat]

A dream come true!

[@RezaDorrani]

❤️

[@yenumulavenkatesh2372]

Thanks Reza for exploring new things

[@RezaDorrani]

Most welcome

[@bobleach]

Wow, just wow! That looks amazing. I have a few Share points that could use this (although I'm developing on Data verse going forward). I've not really used the Graph API, so What other possibilities could this open up?

[@RezaDorrani]

Thank You so much! This opens up a lot of possibilities based on the endpoints supported by groups connector. I have covered the endpoints in this video 👉 kzbin.info/www/bejne/kKu6lYufgt90Y8U

[@AshutoshDubeyCivil]

Long awaited.. thanx Reza...

[@RezaDorrani]

Most welcome

[@natcongreso2763]

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

[@RezaDorrani]

It will respect security

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

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

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

[@rihabhamila4080]

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

[@rihabhamila4080]

@@RezaDorrani Thank you for your response. 👍

[@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!

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

[@MAPinkard]

Amazing as usual, Sir!

[@RezaDorrani]

Thank You Sir

[@tylerbailey460]

Hi Reza, I really enjoy your videos, keep them coming! I just re-created this search feature on my canvas app for reviewing service approvals. I'm having trouble with a couple settings. First, my gallery doesn't show until I try and search for something; What am I doing wrong? Also, what happens if you have lookup columns within the gallery? I can't get those to show up when I try to setup my gallery. Any insight would be greatly appreciated. Thanks

[@RezaDorrani]

Thanks so much! In the video I explain how to show all results somewhere in the end of the video. Video description has link to download sample app (members only) wherein you can check all the logic and more. This feature uses search so the key is managed properties. Check documentation on search managed properties.

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

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.

[@dineshb]

Wow.. amazing video as usual

[@RezaDorrani]

Thanks so much

[@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

[@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!!

[@JasonAngWeiLung]

U earn my highest appreciation for helping the community at large! By the way, can I use the same method to call Sharepoint image without delegation warning?

[@RezaDorrani]

Most welcome! SharePoint Image cannot be searched. Not sure what delegation issue you have with it?

[@hecksongomes462]

Brilhant!!

[@RezaDorrani]

Thanks

[@olssik]

Amazing ! Thank you sooo much! But i have problem.. it doesn't return me the fields values from my created SP columns :(

[@RezaDorrani]

Read more managed properties. Check documentation for search.

[@weierschatten3433]

Hi Reza, great vid! Exactly what I am looking for. I think I followed all your steps just fine, but the Monitor and the button for searching is giving me an error: "Error on Office365-Groups.HttpRequest: Contract failure: Invalid data uri format" I think it has something to do with the PowerApps syntax being different depending on the language/region it is set to (Germany for me). Do you know of tools that can "translate" it? Thanks!

[@RezaDorrani]

Not sure about the issue or the fix for language/region. I have not come across this issue and hence not sure what the cause could be. I recommend posting your issue on forums at powerusers.microsoft.com

[@Sarath98]

Hi Reza! Great video. We have been looking for a solution like this for a while. Thank you for figuring this out. I did have a quick question though. Would it be possible to include custom metadata fields within these search results? Thanks!

[@RezaDorrani]

Those metadata fields would need to come as search managed properties. Check documentation on search managed properties.

[@paulbruen3108]

Excellent and really useful video Reza. Could I ask though what code is on the NEXT button and the DROPDOWN please? I've recreated the app, but it's just missing those steps, so that I can show all the records.. Thanks.

[@RezaDorrani]

Most welcome! I have made entire app available for download to channel members (silver). I will be sharing complete apps and flows with them. I cannot share the code as its a member only feature but idea of next and previous button is to check if more record exists and accordingly update the size and from properties.

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

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

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

[@nochillbro1412]

Hi Reza, great guide! I'm just having a bit of challenge getting a specific field (custom field which is a calculated value). If I try to list the fields (( GET /sites/{site-id}/lists/{list-id}/fields )) and use the name of that Field on the Fields part of query it is not returning a result. Can only see the title, author, date created etc.

[@RezaDorrani]

I have not tried with calculated columns hence not sure.

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

[@vigneshravi6025]

Hi Reza Many thanks for your efforts👏🙏 I had an issue in getting the field values, I tried with different field names, but its not returning the field values in response.😞 can you please give some details on getting fields values. Thank you.

[@RezaDorrani]

I have not come across this issue & hence not sure what the issue you are facing is related to. Please note these are managed properties and not column names. I have mentioned this in video. Best to read documentation on search managed properties for sharepoint online.

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

[@Kaitingkate]

It's really usefull! I was trying to query text in particular sharepoint list, but it does not show any result. :(

[@RezaDorrani]

I have not faced any issues with it so not sure

[@vonis22]

Hey Reza, great video this helped me a lot. I worry a little bit about the Office365Groups connector though. Will my users need Sites.Read.All permissions to use this solution ?

[@RezaDorrani]

Office365Groups uses delegated permissions to use the graph. No elevated permissions are needed. Check documentation to see which permissions does the endpoint need. Although I did not grant any for my users.