A question to the community with the hope that what I find difficult you find easy. In the URI mentioned in this contribution I am retrieving (trying to) a number of properties, some standard, some created myself. Yet the returned values only contain "null", e.g. "Key": "Category", "Value": null, "ValueType": "Null" As far as I can see values in "Site Collection Administration - Managed Properties" are the same for items showing values and items showing "null" even if input is present. Any idea what I am missing?

If you're having trouble with parseJSON after following this tutorial, Power automate is now changing the manual formula to a dynamic tag after the first execution, which doesn't output escaped double quotes in the response. I solved it in my case by adding a string() function applied on the body(etc)

Finally documents long hidden somewhere come to light again, thanks so much Reza! Maybe you could return to the search topic again at some point to expand the search that it embraces all content of a SharePoint site beyond libraries, but also regular lists? And then given this enlarges the search result to have options to filter these down as required, e.g. filter to specific sites or where certain meta data such as categories are met? Reza, you are providing such incredible support, thank you!

Thank you very much for the video Reza ! Amazing function for sharepoint database users, will test it out ! especially the in search content capacity from a image in a standard licence from wich did not know it was possible and the possibility was always there 👏👏

Thanks a lot Reza for this video ! As you've just shown, using the SharePoint API is a really effective way of integrating data from SharePoint into Power Apps. Of course, you have to use it according to your needs, but honestly, you should use it in real scenarios, ahah. Too good. Thank again you for sharing all this content, because it's thanks to you that I'm increasing my skills and improving my vision of the Power Platform. 🙏

Another game changing tutorial! 👏

Exceptionally neatly crafted solution. SharePoint API is getting another level with Reza's creativity

I had yesterday zero experience about „Power Apps“ and all this stuff. Today I launched already my first full working and responsive app ! This videos are so crazy amazing. I would pay for such content. Where I can donate a ☕️?

Great video Reza! We can achieve SharePoint global search functionality with these APIs

Thanks Reza, again another great video. One question, how possible to check If pdf file content has been modified or not. I know I can do that by calling file modified trigger but I need to trigger the action only if file content changed not other Metadata. Wondering if graph api has solution. Thanks again

Thank you Reza. I have not had a use case around this yet but it is definitely a good knowledge to have and i might find ways to apply it in my present place of work

well done Rezza, excellent tutorial!

Great demo ... you rock Reza!

This is just awesome Reza Sir. Thanks a ton.

Great solution 👍, thank you so much for this video. Very much appreciated 😊

Thank you for this Reza, its a very great tool and its working on our SharePoint pages perfectly. Just a question on functionality, is there a way to have it also work with partial/substring searches, please?

Brillant content, as always !

As always excellent. Thank you.

Thank you, Reza. How is this search method impacted by delegation? (You pointed out that it is a 'non-premium' way of searching, so I'm hoping it can also search 22,000 or 360,000 docs for search text - that would be almost too amazing!) 😊MUCH APPRECIATED.

GOAT! Thank you for another incredible tutorial!

Hi Reza 👏 great video, is their a limit to display items in a gallery as I have my result showing large number or should just create a new document library to search on

This is great! def testing it out!

Great video. Thanks for sharing

Hi Reza. I have implemented this search function across my company. Works a treat. Thanks. We have multi country SP environments. Some of the SP sites are common, some aren't. Can you think of a way that the user will be able to select and limit the results to a selectable dropdown selection? The flow can still search in all environments, but just limit the displayed results. Thanks

Hi Reza, have you thought about doing a quick lesson on how to add a new user to a Sharepoint list and giving them permissions via Powerautomate and/or Powerapps? A good example would be the Onboarding or Offboarding of an employee who needs permissions to certain sharepoint sites and/or lists.

One of the Good content so far . I have one query how to get file size in an effective manner.

Thank you Reza, a great tutorial with a brillant content 🙂👏

Mind blowing. Thank you!

Impressive ! Great job !

Amazing! just the user case I needed, I will try soon Question, how did you add the Extracted text column to the sharepoint list?

Love your content! Question: any advantage to searching document libraries via this method (REST + Power Automate) vs. Graph?

Thank you very much Reza for this video.

Brilliant Guide, but a question. can you get the document to display in a pdf viewer (as shown in your other video) or does it have to be launched?

Hi Reza Thanks a lot for this video. As always, I get solutions through your videos. I tried to do a keyword search in a Sharepoint library by following the video, but for some reason, I am getting empty rows under the table. Not sure what may be the issue. Have checked everything thrice but still getting same. Any suggestions?

Hi Reza and thanks for this great tutorial that helped me achieve exactly what I was looking for. I am wondering if it is possible to modify the query so that each document in the sharepoint is associated to a number of occurrences for the search word. Thank you in advance for your help.

Really cool video, this search funciton is amazing! Is it somehow possible to show all the found results in the gallery? At default it only shows the first 10 findings..

Reza, great video once again! How do you get the little images (eyes next to Views, folder next to Shared Documents, etc). Are those simple image controls, or some other trickery? :D

Very good and informative video. Thanks for it. Can we use search api if we need to find specific text from pages library on pages and webparts within those pages?

perfect video, Reza your are the best. I recreated the demo concept for my library. My library contains some self-created metadata. Unfortunately, this metadata is not displayed in the output of the flow. How can I ensure that this metadata is also displayed?

Thank you Reza. There are multiple requests on this and thanks for this video. I can see we can pass single query text or multiple parameters on this? Can we pass dynamic metadata on this? I'm looking on building up a Unified Search which can work on dynamic metadata from different content types? This way, search will be more centralized and I can use this search for any content types or document libraries.

Nice, thank you. Quick question, I see you added content class:STS_ListItem_DocumentLibrary. Is that valid for all OnLine Libraries?

My ambition is to get placed in MAANG kinda giant companies. As a powerapp devolper can i join there.. because , i feel like only service based company is hiring powerapps developer since its a developing tool, not a product based company ....is it?

It's super useful usecase

Hi, This is Ramya, 2022 passed out electronics engineer from India. i am interested in coding. I am working in a reputed mnc as a powerapp developer. Is it good to start my career as a powerapp developer? Whether Microsoft is hiring powerapps developer? If so how do i prepare for that like i need to complete pl400 pl200 like that or oops language like java , data structures and algorithms like that?

This was super helpful! It's there any way to add filters to the gallery as well? I can't figure out how to access the fields brought across within search results to compare with field names for use with check boxes against metadata fields, for example.

Are you able to use the “extracted text” column directly within powerapps instead of calling the rest api? Since its just another column.

Amazing Video as per usual Reza. I cant see or seem to add the extracted text column is this something that needs to be configured beforehand? I'm in the UK, so it might not be a feature here.

Hi Reza ,great work , i dont have extracted text column in my Sharepoint online, what must i do to get that column

Hey Reza, great video! Is there anyway to sort the search results in the gallery? For example if I want to sort by column. Trying to recreate the “bookmarks” experience from SP Search. haven’t been able to get it to work with the api search results. So I’m trying to figure out if I can just sort the gallery of results by a column once the results arrive in PowerApps. Thanks

Thank you very much for this demo !! I tried to implement this solution following your instructions. I have a document library with many documents, but no matter what I try to search for, I only get results from one specific document... any clues of what can be wrong? Thank you

Great video Rezza, i got it to work, is there a way to get additional sharepoint tags from the document library (other than from document itself),, i have extra columns on the document library that i would like to get the data to updated another list. Thank you in advance

Fantastic video as always. I've combined two separate searches from two separates sites into one result sent back to Power Apps. While I can get each separate search result to sort by Rank, append them together with some substring manipulation, and send to Power Apps I can't seems to identify how to re-sort the total results, the combination of two sources, by Rank once both search results are combined into a mega-result. The intent is; a universal search across multiple locations in multiple sites. Without a resorting of Rank in totality it isn't very useful. Any assistance is appreciated.

Thanks Reza for the amazing video! Quick question, how can you create a dropdown box that would dynamically populate from the search results, allowing you to further filter the results by something like FileExtension? I have been tying for a couple days but can't seem to figure it out.

Thank you for providing great content videos. This is another great video. Is there a way to get the schema search(property names of Sharepoint list columns) w/o site admin privilege?

Great video. Can this functionality also work on sharepoint list attachments?

Hi Reza, In my Share point list I had a Invoice column(Date and time) by using this I have to send an Remainder email for 10 days, 20 days, 30 days and 50 days by using power automate flow. But while using switch I am unable to use dynamic values or expression, how can I achieve this scenario

Thank you Reza for awesome video really wonderful can you please help me why I'm getting "Short Name of" instead actual name of document it's happening for few files how can we fix it

Great tutorial Reza..could you please enable download option as i just subscribed to membership today and i cant access the app.

Could you please make a video on combining 2 or 3 apps in Power Apps?

Hi reza, do you have video how to insert link somewhere in the sharepoint that enable approver to see the approve/reject button in case they accidentally deleted the approval notification to their email?

Hello Reza, thank you for your videos, they have been so helpful for me. I have one question, I was trying to do the Sharepoint Request following the instructions but it retrieves the rows as an empty array, even if I have documents that contain the value I'm searching for in the name and the document itself. I put the value in the search point search, and I have 13 items. I have full access, do you know if something has changed for the query? I would really appreciate your help, thank you !

Thank you for this great tutorial, do you think it might be possible to user the same flow and work with Team PVA to show the results?

Hi, thank you for the tutorial. I have a question where let’s say I have 3 files in doc library with item level permissions and person 1 see 1st file, person 2 see 2nd file and person 3 see 3rd file but if power automate flow is running under my connection so will everyone see their own file or my file?

Perfect explaining 👍quick question: I'm getting empty [] searchResults after the http request is done and everything is set up as in the video. Any suggestions on what issue may that may be?

Hi Reza, this is a great video and it is perfect for what I need in our environment. Do you think it would be possible to add f.e. a combobox which collects all the file extensions from the search results? With which we could refine our result? If so, could you point me in the right direction please?

Thank you, Reza, for the explanation so that people like me understand without knowing the PA language. However, I get no hits when I run the program. But what I discover is that varSearchResults gets data type: Post What have I done wrong? my files in Sharepoint/Documents are PDF only.

Thank you.

Hi reza, I have one validation problem in my app Title i given a Textinput to enter the parent project and i given one switch off and on toggle , so if we switch on toggle means the entire lookup values will be saved like multiple times how many i click on saved while we switch on that toggle , but i have a issue of saving my values are saving only one time in my list can you help me to solve my validation problem

I am really comfortable with this power platform....but kinda frustrated to start my career in this ,as my friends are learning dsa , oops concepts inorder to crack interview of faang.... whether am i going in a right path?

Reza, I am trying to modify your Uri to allow a dynamic approach whereby the search criteria would be pulled from a list. We have common terms that we need to look for often, So i am trying to automate the flow on a schedule. I use a get items to retrieve an array of the search terms. But i continue to get mixed results. i continue to receive an error stating the querytext is missing or invalid and yet when i run the flow i get results. Anyhow, if you have any idea on what the URi might look like that would be great. Great video!

That’s great. How can I show the content and highlights it in the result next to the pdf preview?

thank you rezza, you a saviour

Hi Reza, amazing video I have to work on same scenerio, but I have to perform search only one file recent uploded, So I used a trigger as when file is created and passing the doc library address+full path of document in uri column, but it is not searching, It is working when I coded as same yours (document librarypath*) it search in whole doc library.

Can this be done with a lookup column also? Impressive video BTW

Hello Reza, I am unable to get the result in the variable. the latest version of power automate does not allow to write the expression, it is somehow missing and i have written below values while getting the result in parameter kindly guide if i am doing any mistake any where i have tried with string and without as well at both level i am not getting String(body('Send_an_HTTP_request_to_SharePoint')?['PrimaryQueryResult']?['RelevantResults']?['TotalRows']) String(body('Send_an_HTTP_request_to_SharePoint')?['PrimaryQueryResult']?['RelevantResults']?['RowCount'])

Hi Reza, Thanks for such an informative video. I tried implementing this in my company. No document is retrieved even if I search with the title of the document. I am getting an empty array in search results and 0 in total rows and row count. FYI the document library is created under company licensed Sharepoint account, using SPO Site Creation form.

Hi Reza, I have a question, the option you showed in the video you can only see the visual option of the pdf but if you want to edit the pdf you need to open the desktop version of PDF, how would you do this process? normalmnente the user enters to view and edit the pdf.

Nice explained🙏🏼 the only part I don’t get is when you go to power automate and already has that template, how can I have that?

Hi Reza, First of all, thanks for this informative video. I had a query regarding the extracted text column. I can't see it in the document library I created. Can you let me know from where I can have this column. If you have created a custom column then how have you done this?

Hello Reza, can this be used to search sharepoint list and its attachments rather than sharepoint library? Which portion of code needs to be changed in the send http (get method) section?

Hi Reza, do you know how individual document or SharePoint site security settings might impact things. I'm working on this exact implementation for my organization but for some reason when the results come back, it only matches to the Document Library name itself and none of the contents or the text within the contents. It would seem the API is working and connecting to the library, but nothing within the library is getting matched. I've tried re-indexing, adjusting document level security but nothing works.

Is there a way to bring over file metadata as part of the API request? I've read all the Microsoft documents and tried several methods, but can't get anything to work. I'm trying to filter out documents with a specific value in a metadata column. Thanks

How are you displaying non pdfs in the pdf viewer, i used your other video but iI cant replicate it using the LookUp(Table(ThisItem.Value.Cells),ThisRecord.Value.Key = "Path").Value.Value I know it needs to change due to being from the Gallery but i cannot figure it out. Any help would be greatly appreciated. Keep up the great videos

@RezaDorrani. I followed this and implemented. It is working absolutely fine. I am trying to pull custom fields (Lookup and Dropdown) values too using API. But unable to make it happen. Seems, I may need to check the Managed Properties of the library for this and couldn't be able to find much helpful resources to complete this. Would you please provide any guidance or point me in the right direction to achieve this?

Thank you for the video, but after testing I notice that the search rest api isn't searching any of my indexed metadata fields in the library, am I doing something wrong?

Hi reza in my date picker i want to get date format as 7/28/2023(mm/dd/yyyy) to 28/07/2023 (dd/mm/yyyy)

One other question, did you get the Library Name somehow from the "path" property? If so, which method?

Hi Reza! I followed your exact steps, even copy pasted your expressions, however when i use the flow and hover over varSearchResults, i'm only getting back searchresults, not totalrows or rowcount. This is defaulting to just 10 rows and not pulling all the data. Any ideas on how to fix this?

Hi Reza, Thanks for sharing this knowledge. While im trying to run it i'm continuesly getting below Prase error "" Unexpected end of JSON input" Any idea ?

Any idea if we could do similar things on Power Pages? The current SharePoint integration for power pages is not sufficient in some of our use cases...

Hi Reza, How to create CSV of the SharePoint HTTP connector output . . Because Json which we are getting is complex Json. How to map key value pairs in create CSV to get exact output. Please instruct me on how to achieve it.

Hi , I had a question I wanted to add a edit button for grid where I am using only labels to make the grid andstoring where its not able to edit anything in the labels grid

Is there a way to use this same method for multiple control in a way where, when the search button is clicked it shows the precise record and not multiple records.

The Search Result is not displaying on the gallery, however the search result works well. Is there anyway I can get help with the results to display on the Gallery? Thanks in advance

Hey there, How did you hide the next button, I've managed to hide the back button but cannot figure out the code for the next button?

Hey Reza, would something like this work for SP lists? Say I wanted to search Title, ID and Created By using REST api search. I've tried using this method with the path to my list instead of a documents library, but was not getting any results. I'm thinking I need to somehow specify the columns that I want to search in the Uri. I've also tried Graph API, but it is not working in our tenant (we are in DoD tenant).

Hi Reza, Is there any way to extract data(OCR) from the selected document and format could be anything image/pdf/word? Please provide your insights how to achieve this without AI builder?

Reza thank you for another great video. I was able to follow your instructions using two of your videos. Does any know how to make the PDF Viewer work with the gallery results for this video? I want to click on the record and have the PDF viewer display the document using the "path" value from the gallery results. The link works but it opens up the document in the browser. Thanks.

Hi Reza. Great video. I've just joined as a Silver member. Is there still a link to the download for this app?

Reza this is great but how about if i want to change the source to search is there a way to allow users to change the source to search?