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?
There are some pre created managed properties that you can use to map to your crawled properties of columns. Try using those. I have not experienced the null issue, hence not sure what’s the cause or fix for it.
@@RezaDorrani that exactly did the trick. To share with the community, I went into 'Site Collection Administration - Managed Properties' and searched for 'RefinableString' as I wanted to bring up custom text fields. Chose the first, then scrolled down to add a mapping. To get the property wanted searched for the custom field which in the search result shows with 'ows' prefix. Added more as required in same fashion. Then went to 'Search and Offline Availability' and rebuilt the index. Be patient there. Then edited the URI using the 'RefinableString' names.
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)
Do you mind ellaborating a little bit more how you solved the issue? Currently, my searchResults its showing [' '], if I check my raw data shows Rows: 0, so its not generating the table. Is this the same situation?
@@juancarlosvallecillo4533 I don't think it's the same issue as I was getting search results from SPO API but was unable to then export them to a flow, if the search results are empty it's probably something to do with the query
Thank you so much for your update. I tried the steps multiple times, and I am getting the same result following Rezza's excellent video. for search results it shows [] left and right bracket. Can you please share an example of how you added a string function(). Thanks so much.
I believe fully empty strings mean the search API did not find any results. In my case I was getting a parseJSON error inside Power Apps. The string() function was added on the Power Automate side, instead of using the dynamic tags, write a custom formula and wrap the formula in the instructions in a "string(*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!
Hi @Reza, could we get directly the content preview instead of list of files ? Or When we open file it redirects to the exact page of the search phrase location? Is it feasible with power apps?
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
I believe if content is changed it should trigger, but not sure. Never come across this scenario though. I would recommend posting your query on forums powerusers.microsoft.com
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. 🙏
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 👏👏
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
Key is managed properties for searching. If you use content types then it automatically creates crawled properties and then you can create managed properties and fetch them in searching. Il recommend reading about managed properties in SharePoint search.
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
@Reza, amazing video! I can't wait to see my app deliver the same result. However, I'm stuck with Sharepoint Search API, 11:00 of your video. When the Uri specifies a document library, it returns an empty table. When I remove the path, Uri equals /_api/search/query?querytext=%27SearchText%27, it returns search results from all the Sharepoint groups that I have access to. Could you please let me know what did I do wrong?
I have not experienced the mentioned issue and hence not sure what the cause for it could be. I will recommend posting your issue on forums in case someone has experienced something similar powerusers.microsoft.com
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.
I would have to try it out to know the steps. Why not simply hardcode a dropdown of file extensions and send that as param to flow and use it for filtering.
@@RezaDorrani I have tried hard coding the file extension in the dropdown as well, but I must got be getting the formula incorrect for the filter. This is what I currently have, in an attempt to produce a result. Filter(Table(ParseJSON(varSearchResults.searchresults)), ThisRecord.Value.Key.FileExtension="doc")
I cannot debug the issue without trying it out myself. I would recommend posting your issue with screenshots on the forums at powerusers.microsoft.com/
I did it this way: On Items properties from Gallery: Filter(Table(ParseJSON(varResults.searchresults));LookUp(Table(Value.Cells);Value.Key = "IsDocument").Value.Value = true)) I changed: From: "ThisItem.Value.Cells" to: Value.Cells and From: "ThisRecord.Value.Key" to: Value.Key. Doing it this way it filters only by files. Note: My PowerApps is in Brazilian Portuguese then ";;" = ";" and ";" = "," I hope I helped you.
Awesome tutorial! I do have one question. I started getting "refresh token expirations" on the send an http request for some users. Do you need to add a specific connection into PowerApps to make sure the http request is using a user's updated connection?
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?
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.
The search api supports filter actions as well. Check the documentation for search api linked in video. You would need to pass the filter conditions as params to flow and use that to frame the search api call. I would have to try it out to provide any further guidance. I recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.
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.
@@RezaDorrani right. I’m just thinking since the goal is searching, if you just use that column, you can just use the “search” function for the gallery.
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?
Check my video playlist on graph api. I have done 3-4 videos on this topic. Search is dependent on managed properties. Check documentation on managed properties for SharePoint.
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?
Hi Reza. Thank you for this video, very useful. One question please as I still do not understand something. I have in the entire SPO 2 columns that I defined to be applicable to all Document libraries. How I can get the info from them and show it in the gallery? I'm talking about 2 choice columns with multiple selected items to add for example specific tags.
You need to map crawled properties of those columns to managed properties in SharePoint search. I would suggest checking documentation on sharepoint online search.
@@RezaDorrani Thank you. I found how to do it but it returns for now Null. Do you have any explanation on that ? I mean, is there any delay till real content will be recovered?
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 !
Check pinned comment on video. The search API works as expected and nothing has changed. Video description also has details to download the sample app (members only - check description for details)
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.
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?
It can be used for lists and attachments. I would have to try it out to know which portion of code needs to be updated. I would recommend posting your query on forums in case someone has done something similar powerusers.microsoft.com
Thank you for the video! One thing to ask: Is this applicable on Dataverse table? If not is there any similar function that can be use when the database contains a lot of records? Thank you!
Hello! This is working very well! My question is what are you putting in to call the PictureThumbnailURL property? I have it included correctly in my search query in PowerAutomate. I see in the Output of the flow that it is returning Null. I try to replace the "Title" or "Author" in the code example given with PictureThumbnailURL but it returns nothing :(
I did this video a long time ago and do not remember exactly the code used. The video is the best reference I have. I would recommend posting your issue on the forums at powerusers.microsoft.com/
Great work! How many sites and document libraries can be added by using" Send An HTTP" method. Can the search perform cross sites ? what are limitations
Reza, wish you happy new year, Does any of this - including cloud flow requires paid subscription, In other word, can we do the search via Power Apps for teams
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?
Hi Reza, I was wondering if this app is acceptable when the libraries that I want to use have been dis-inherited from the Tenant, due to security implications? As well if the lists are over the 5000 threshold is this still accpetalbe?
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. Looks like you have expanded on the video which is great. I would have to try out your scenario, recreate it to provide guidance and I have no plans to do so as I have moved onto multiple new videos. I recommend checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com
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
Im stuck on this step 11:06 , I did exactly the same, but I keep getting no results, and on the outputs I get this: "ResultTitle": null, "ResultTitleUrl": null, "RowCount": 0, "Table": { "Rows": [] I have tried many times with different sharepoint sites I own, but keep getting the same result, what could I be missing? thanks
someone posted this comment - "I ran into the same issue - I got it to work by modifying the Power Automate Uri field (in the Send an HTTP request to SharePoint) like this: /_api/search/query?querytext='*YourSearchText*+path:"YourSharepointName.sharepoint.com/YourDocumentLibraryName/*"' Let me know if this works for you as well, and happy Power Apping!"
@@RezaDorrani That was me! I think my comment got deleted due to the hyperlink in the post. But yes I got it to work by adding the quotes around the sharepoint site
@@RezaDorrani Thanks, I've been scrolling to find out why mine wasn't working and saw this and adding the quotes from https to the * of the url but leaving the %27 at the end worked
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!
Depends on how you have framed the query based on your dynamic logic from list. I have not tried this hence not sure. I recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
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
Thanks, @RezaDorrani. Have you done a search text within Power Automate for the SharePoint document library? I'm looking to update the file properties when someone adds a document in the library using the text base within the file.
@@RezaDorrani@RezaDorrani, I'm looking to add searching in content if someone adds the document to SharePoint Library, and on the base of search content, it updates the metadata of the respective document. It is the same thing you have done... but using SharePoint Library and Power Automate. Hope I have it clear to you now Cheers
@@RezaDorrani, Can we build the search file content using Power Automate's "Get File Content" instead of creating the app using SharePoint and Power Automate?
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
I have not faced this issue hence not sure what the reason for your issue could be. I recommend posting your issue with screenshots on the forums at powerusers.microsoft.com
@@RezaDorrani, If I remove the * after the document library name from the Uri , it searches in more documents, but not in all. With the * it only searches on one document...
@@nilsfragoso Depends on how the doc libs are named, how many documents it has etc. I would recommend to read about search properties and how to apply * searches in SharePoint. Video description has link to download sample app which includes my entire setup used.
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
Most welcome! I believe there was a path property to filter or target specific sites. You could dynamically phrase that based on dropdown selection. I have not tried it and hence giving an idea.
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.
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, 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?
The search results returned are in batches. So the distinct file types would not be accurate and based on entire result set. Also, distinct is not a delegable function.
@@WaldoSchobben-qf9sh Search results can be filtered by checkboxes or combo boxes. Your question was to collect all file extensions and show them in a combo box.
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?
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?
I had to replace the document library address with its list id instead other than that it is working. Any idea how to retrive values of columns associated with the file? I have columns that hold info etc that needs to be displayed in powerapps
@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?
There have been a few comments on this. There is documentation out there on web around managed properties. In my scenario, the columns were available as crawled properties and I mapped it to managed properties.
Yeah @@RezaDorrani. Thank you for the response and this use case demonstration. I would explore how to add and deal with the managed properties in SharePoint.
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
This video is about searching in power apps not sending email reminders from flow. I recommend posting your issue with screenshots on the forums at powerusers.microsoft.com
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 do not have a video reference on your scenario and would have to try it out to provide guidance. I recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.
Hi, may I ask what is the function for the button users press to open the file after all the searching algorithm is done? I added the Navigate function before your Power FX template on calling the Title etc and it returned a different variable type.
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
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?
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..
@@RezaDorrani I would like to link the found results directly to the respective document e.g. by clicking the "ChevronRightIcon" how can I do that? Thank you in advance!
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?
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.
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 ☕️?
This is awesome! Glad to hear you launched your first app 👏 Thanks for the appreciation. You can become a member of the channel if you’d like. Here is the link 👉 th-cam.com/users/rezadorranijoin
I cant find it :( did you rename it? or maybe do i need some updated licence or version of sharepoint? I havent found a way to enable it or display it@@RezaDorrani
Hello, how are you? I have a question: is there a way to focus the search on two columns contained in the library and not search within the content of the documents? Also, while running your example, I noticed it only returns 10 results out of 29 (in one example). Is there a way to increase the RowLimit?
1 - search works both on content and metadata. There are ways to even target specific columns in search query. 2 - search api has details on rowlimits and pagination
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
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?
I do not have a video reference on this scenario and would have to try it out to provide guidance. I recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.
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.
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?
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
Thanks, I searched through all the perks of the silver members, I can’t seem to find it 😢 Would you be able to link it here? Thank you! And amazing video by the way!
@@KristineTee-w4n Please post a comment on ANY of the download links shared for silver members and mention about this video. I will share link there. Note: thepoweraddicts-my.sharepoint.com/:w:/g/personal/rdorrani_thepoweraddicts_onmicrosoft_com/EbvjdBY80QRGkT6svJEmzZwBz64PNYQDRvKHm8eRHEYe6Q?rtime=A8xvRp703Eg
Yes, I used split function and then index to get it. I don’t remember the exact function. Video description has link to download entire app (members only)
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).
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...
Hello Reza, what do you think I can do when the Power Automate flow result does return the file properties that should be populated in the gallery. I only get the file name, others like size, thumbnail, path, file type etc. are not returned by the flow. Do you think it is my SharePoint settings? Thanks.
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.
Search will respect SharePoint security. I have not experienced the issue you have mentioned and hence not sure what is the cause for your issue. I recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
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, 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.
I do not have a video reference on this scenario and would have to try it out to provide guidance. I recommend checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com
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?
I have not come across the mentioned issue and hence not sure what the cause could be. I recommend posting your issue on forums in case someone has experienced something similar powerusers.microsoft.com
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 app is exactly the type project that I'm working on. How do I find it in the membership section. I've searched and scrolled to no avail? I'm looking for the app explained in this video please.
As a silver or gold member, go to any post on membership tab where I have shared a link for any video and make the request. Il share updated link there.
Brilliant Video as Always. My Gallery only returns 10 results showing but the search is retuning 38. Ho can I have the gallery show all items, I dont want to limit number to 10.
Thanks! I have not experienced the mentioned issue, hence not sure whats the cause for your issue. You can try downloading the solution shown in video (members only - check video description for details)
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.
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?
There are some pre created managed properties that you can use to map to your crawled properties of columns. Try using those.
I have not experienced the null issue, hence not sure what’s the cause or fix for it.
@@RezaDorrani that exactly did the trick. To share with the community, I went into 'Site Collection Administration - Managed Properties' and searched for 'RefinableString' as I wanted to bring up custom text fields. Chose the first, then scrolled down to add a mapping. To get the property wanted searched for the custom field which in the search result shows with 'ows' prefix.
Added more as required in same fashion.
Then went to 'Search and Offline Availability' and rebuilt the index. Be patient there.
Then edited the URI using the 'RefinableString' names.
@@marcmurray179 AWESOME!
@@marcmurray179 how long did it take to rebuilt the index in your case?
@@marcmurray179 Brother can you share the full application solution of this video which are only given to members, please, I really want it urgently
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)
Thanks for sharing
Do you mind ellaborating a little bit more how you solved the issue? Currently, my searchResults its showing [' '], if I check my raw data shows Rows: 0, so its not generating the table. Is this the same situation?
@@juancarlosvallecillo4533 I don't think it's the same issue as I was getting search results from SPO API but was unable to then export them to a flow, if the search results are empty it's probably something to do with the query
Thank you so much for your update. I tried the steps multiple times, and I am getting the same result following Rezza's excellent video. for search results it shows [] left and right bracket. Can you please share an example of how you added a string function(). Thanks so much.
I believe fully empty strings mean the search API did not find any results. In my case I was getting a parseJSON error inside Power Apps. The string() function was added on the Power Automate side, instead of using the dynamic tags, write a custom formula and wrap the formula in the instructions in a "string(*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!
You’re most welcome!
There is so much that can be done with search APIs.
Hi @Reza, could we get directly the content preview instead of list of files ?
Or
When we open file it redirects to the exact page of the search phrase location?
Is it feasible with power apps?
Im not sure if thats an option
@ Thanks Reza.
Exceptionally neatly crafted solution. SharePoint API is getting another level with Reza's creativity
Thank You
Another game changing tutorial! 👏
Sadly, video start is not great from a viewership standpoint.
Hoping more folks see the value.
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
I believe if content is changed it should trigger, but not sure. Never come across this scenario though. I would recommend posting your query on forums powerusers.microsoft.com
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. 🙏
Great to hear! Thanks so much for watching and appreciating the videos.
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 👏👏
Glad it was helpful!
Hi Reza ,great work , i dont have extracted text column in my Sharepoint online, what must i do to get that column
You will have to add that column to your view.
I did nothing to add that column.
@@RezaDorrani thanks much for the video. Super like
@@rahulkoul9110 I only noticed it when preparing for the video. I have no clue either.
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
Key is managed properties for searching. If you use content types then it automatically creates crawled properties and then you can create managed properties and fetch them in searching. Il recommend reading about managed properties in SharePoint search.
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
Check rest api documentation linked in video. There is a sort option as well.
@Reza, amazing video! I can't wait to see my app deliver the same result. However, I'm stuck with Sharepoint Search API, 11:00 of your video. When the Uri specifies a document library, it returns an empty table. When I remove the path, Uri equals /_api/search/query?querytext=%27SearchText%27, it returns search results from all the Sharepoint groups that I have access to. Could you please let me know what did I do wrong?
I have not experienced the mentioned issue and hence not sure what the cause for it could be.
I will recommend posting your issue on forums in case someone has experienced something similar powerusers.microsoft.com
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.
I would have to try it out to know the steps. Why not simply hardcode a dropdown of file extensions and send that as param to flow and use it for filtering.
@@RezaDorrani I have tried hard coding the file extension in the dropdown as well, but I must got be getting the formula incorrect for the filter. This is what I currently have, in an attempt to produce a result.
Filter(Table(ParseJSON(varSearchResults.searchresults)), ThisRecord.Value.Key.FileExtension="doc")
I cannot debug the issue without trying it out myself. I would recommend posting your issue with screenshots on the forums at powerusers.microsoft.com/
I did it this way:
On Items properties from Gallery:
Filter(Table(ParseJSON(varResults.searchresults));LookUp(Table(Value.Cells);Value.Key = "IsDocument").Value.Value = true))
I changed:
From: "ThisItem.Value.Cells" to: Value.Cells
and
From: "ThisRecord.Value.Key" to: Value.Key.
Doing it this way it filters only by files.
Note: My PowerApps is in Brazilian Portuguese then ";;" = ";" and ";" = ","
I hope I helped you.
Awesome tutorial! I do have one question. I started getting "refresh token expirations" on the send an http request for some users.
Do you need to add a specific connection into PowerApps to make sure the http request is using a user's updated connection?
Thanks!
I have not experienced the mentioned issue and hence not sure what is the cause for it.
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?
May be I showed that in one of my approval videos. You can check the approval playlist.
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.
The search api supports filter actions as well. Check the documentation for search api linked in video. You would need to pass the filter conditions as params to flow and use that to frame the search api call. I would have to try it out to provide any further guidance. I recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.
Thanks so much, I'll give that a shot!
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.
I have no idea if its a region centric feature. I simply noticed it while preparing for the video demo.
Are you able to use the “extracted text” column directly within powerapps instead of calling the rest api? Since its just another column.
Give it a try. It should be. This video is related to searching and hence I used the search API.
@@RezaDorrani right. I’m just thinking since the goal is searching, if you just use that column, you can just use the “search” function for the gallery.
@@unetseulement Search is not a delegable function. It would work for lists under 2000 items but not beyond.
@@RezaDorrani ahh right.
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?
Check my video playlist on graph api. I have done 3-4 videos on this topic. Search is dependent on managed properties. Check documentation on managed properties for SharePoint.
Great solution 👍, thank you so much for this video. Very much appreciated 😊
You're most welcome!
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?
Yes, it should work for pages as well. Im not sure about text within web parts.
Nice, thank you. Quick question, I see you added content class:STS_ListItem_DocumentLibrary. Is that valid for all OnLine Libraries?
Yes it is.
Hi Reza. Thank you for this video, very useful.
One question please as I still do not understand something. I have in the entire SPO 2 columns that I defined to be applicable to all Document libraries. How I can get the info from them and show it in the gallery? I'm talking about 2 choice columns with multiple selected items to add for example specific tags.
You need to map crawled properties of those columns to managed properties in SharePoint search. I would suggest checking documentation on sharepoint online search.
@@RezaDorrani Thank you. I found how to do it but it returns for now Null. Do you have any explanation on that ? I mean, is there any delay till real content will be recovered?
@@cosminmarcu9388 I do not as I have not run into any issues with it.
@@RezaDorrani It works now, I suppose it took some time to make my mapping working. Thank you
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 !
Check pinned comment on video. The search API works as expected and nothing has changed.
Video description also has details to download the sample app (members only - check description for details)
Great video Reza!
We can achieve SharePoint global search functionality with these APIs
Yes we can
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.
I am not aware of an option to do that.
well done Rezza, excellent tutorial!
Thanks
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?
It can be used for lists and attachments.
I would have to try it out to know which portion of code needs to be updated. I would recommend posting your query on forums in case someone has done something similar
powerusers.microsoft.com
Thank you Reza, a great tutorial with a brillant content 🙂👏
Glad it was helpful!
@@RezaDorrani how to generate an OCR extract text ? Do we have a free component in power automate, sharepoint or we have to buy something? Thx
@@robi62000 AI builder has a model for that called text extraction I believe. It does require a premium license + AI builder capacity
Thank you for the video! One thing to ask: Is this applicable on Dataverse table? If not is there any similar function that can be use when the database contains a lot of records? Thank you!
Welcome!
Dataverse has search apis. But I’m not sure if it can search data within documents.
Hello! This is working very well! My question is what are you putting in to call the PictureThumbnailURL property? I have it included correctly in my search query in PowerAutomate. I see in the Output of the flow that it is returning Null. I try to replace the "Title" or "Author" in the code example given with PictureThumbnailURL but it returns nothing :(
I did this video a long time ago and do not remember exactly the code used. The video is the best reference I have. I would recommend posting your issue on the forums at powerusers.microsoft.com/
Did you get this working? My site is mostly videos and images and nothing is being returned in the PictureThumbnailURL.
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?
I believe it would have to be launched. In other video we get a lot more info like blob which I don’t think we can get from search.
@@RezaDorrani thank you for your quick response. I will have to leave it as a launched document instead of displaying in my viewers.
Great work! How many sites and document libraries can be added by using" Send An HTTP" method.
Can the search perform cross sites ? what are limitations
This uses sharepoint search. Whatever is possible there should be possible here
Reza, wish you happy new year, Does any of this - including cloud flow requires paid subscription, In other word, can we do the search via Power Apps for teams
This is searching in SharePoint and uses standard connectors.
I'm not sure about dataverse for teams.
excellent tutorial and very useful for many business functions
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?
Flow called from power apps runs under context of user running the App and hence security will be respected.
Hi Reza, I was wondering if this app is acceptable when the libraries that I want to use have been dis-inherited from the Tenant, due to security implications? As well if the lists are over the 5000 threshold is this still accpetalbe?
Im not sure what dis-inherited from tenant means.
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. Looks like you have expanded on the video which is great.
I would have to try out your scenario, recreate it to provide guidance and I have no plans to do so as I have moved onto multiple new videos. I recommend checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com
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
A grid? This video is not on grid controls. I recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
Great demo ... you rock Reza!
Thanks so much
Im stuck on this step 11:06 , I did exactly the same, but I keep getting no results, and on the outputs I get this:
"ResultTitle": null,
"ResultTitleUrl": null,
"RowCount": 0,
"Table": {
"Rows": []
I have tried many times with different sharepoint sites I own, but keep getting the same result, what could I be missing? thanks
someone posted this comment - "I ran into the same issue - I got it to work by modifying the Power Automate Uri field (in the Send an HTTP request to SharePoint) like this:
/_api/search/query?querytext='*YourSearchText*+path:"YourSharepointName.sharepoint.com/YourDocumentLibraryName/*"'
Let me know if this works for you as well, and happy Power Apping!"
@@RezaDorrani That was me! I think my comment got deleted due to the hyperlink in the post. But yes I got it to work by adding the quotes around the sharepoint site
@@TheAnalystNik Thank You so much
@@TheAnalystNik yes! It worked! Amazing. I’m so happy. Thank you very much
@@RezaDorrani Thanks, I've been scrolling to find out why mine wasn't working and saw this and adding the quotes from https to the * of the url but leaving the %27 at the end worked
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!
Depends on how you have framed the query based on your dynamic logic from list. I have not tried this hence not sure. I recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
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
Thanks for watching. If ever you find a use case, let me know how it went.
Great video. Can this functionality also work on sharepoint list attachments?
I did a video recently on searching lists. That also searches in list attachments
Thanks, @RezaDorrani. Have you done a search text within Power Automate for the SharePoint document library? I'm looking to update the file properties when someone adds a document in the library using the text base within the file.
I did not understand the question. Video is showcasing searching in documents.
@@RezaDorrani@RezaDorrani, I'm looking to add searching in content if someone adds the document to SharePoint Library, and on the base of search content, it updates the metadata of the respective document. It is the same thing you have done... but using SharePoint Library and Power Automate. Hope I have it clear to you now Cheers
@@ssalman12 Still did not understand.
The video shows document library and power automate only.
@@RezaDorrani, Can we build the search file content using Power Automate's "Get File Content" instead of creating the app using SharePoint and Power Automate?
@@ssalman12 I’m not sure as thats not something I have explored.
Love your content! Question: any advantage to searching document libraries via this method (REST + Power Automate) vs. Graph?
License :)
@@RezaDorrani ah, of course, the ever-important licensing consideration 😅. Thanks for the response!
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
I have not faced this issue hence not sure what the reason for your issue could be. I recommend posting your issue with screenshots on the forums at powerusers.microsoft.com
@@RezaDorrani, If I remove the * after the document library name from the Uri , it searches in more documents, but not in all. With the * it only searches on one document...
@@nilsfragoso Depends on how the doc libs are named, how many documents it has etc. I would recommend to read about search properties and how to apply * searches in SharePoint.
Video description has link to download sample app which includes my entire setup used.
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
Most welcome!
I believe there was a path property to filter or target specific sites. You could dynamically phrase that based on dropdown selection. I have not tried it and hence giving an idea.
@@RezaDorrani Thanks. I'll see if I can work it out.
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.
Possible. You can include searchtext as example: ContentType:X and add additional filters. Check documentation linked in video description.
GOAT! Thank you for another incredible tutorial!
More to come!
Brillant content, as always !
Much appreciated!
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.
Video description has link to download entire solution (check description for details)
@@RezaDorrani Thank you. I will sign up for a membership so that I can download.
@@patrickcook2296 Message me in community tab where link was shared in case it got disabled. I will re-open it for you.
@@RezaDorrani Thank you so much. I just messaged you in the community tab.
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?
The search results returned are in batches.
So the distinct file types would not be accurate and based on entire result set.
Also, distinct is not a delegable function.
@@RezaDorrani Does this mean that there is no way to filter the search result by using checkboxes or comboboxes?
@@WaldoSchobben-qf9sh Search results can be filtered by checkboxes or combo boxes. Your question was to collect all file extensions and show them in a combo box.
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?
Most welcome!
I have not explored option of substring searches to know if that is possible.
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?
I do not follow or track job portals or hiring details.
I had to replace the document library address with its list id instead other than that it is working. Any idea how to retrive values of columns associated with the file? I have columns that hold info etc that needs to be displayed in powerapps
Check pinned comment on video
@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?
There have been a few comments on this. There is documentation out there on web around managed properties.
In my scenario, the columns were available as crawled properties and I mapped it to managed properties.
Yeah @@RezaDorrani. Thank you for the response and this use case demonstration. I would explore how to add and deal with the managed properties in SharePoint.
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
This video is about searching in power apps not sending email reminders from flow.
I recommend posting your issue with screenshots on the forums at powerusers.microsoft.com
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 do not have a video reference on your scenario and would have to try it out to provide guidance. I recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.
Hi, may I ask what is the function for the button users press to open the file after all the searching algorithm is done? I added the Navigate function before your Power FX template on calling the Title etc and it returned a different variable type.
Open file with navigate? Navigate is used to navigate between screens.
@@RezaDorrani Oh yea, my Power FX was rusty after several months of break. Using Launch with that works fine. Thanks.
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
I believe Author managed property does that. Check if there is another managed property that gives actual name or you may need to create one.
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?
Extracted text I believe is an out of the box column. I did not do anything special to create it. Not sure why it wont show up in your case.
@@RezaDorrani can you please let me know that what is the type of information for extracted text column. I'll try to create a custom column.
@@WineshKumar-u4p It an out of the box column and it auto stores AI extracted text. Even if you make it a custom column it wont 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..
Loading data in batches is recommended due to performance. User can always paginated through the records
@@RezaDorrani I would like to link the found results directly to the respective document e.g. by clicking the "ChevronRightIcon" how can I do that? Thank you in advance!
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?
You would need to be a site admin to get those. The ones shown in video are all standard schema names.
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.
Pdf editing is not supported with the api. It only supports word ppt and excel.
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 ☕️?
This is awesome! Glad to hear you launched your first app 👏
Thanks for the appreciation. You can become a member of the channel if you’d like. Here is the link 👉 th-cam.com/users/rezadorranijoin
Amazing! just the user case I needed, I will try soon
Question, how did you add the Extracted text column to the sharepoint list?
Extracted Text column was added by SharePoint itself. I did not do anything to add it.
I cant find it :( did you rename it? or maybe do i need some updated licence or version of sharepoint? I havent found a way to enable it or display it@@RezaDorrani
@@Maynardjones100 Im not sure what I did to get it.
Hello, how are you? I have a question: is there a way to focus the search on two columns contained in the library and not search within the content of the documents? Also, while running your example, I noticed it only returns 10 results out of 29 (in one example). Is there a way to increase the RowLimit?
1 - search works both on content and metadata. There are ways to even target specific columns in search query.
2 - search api has details on rowlimits and pagination
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
Those are emojis.
Use Windows+. to launch the emoji keyboard.
@@RezaDorrani I knew it had to be something simple. What a game changer. Thank you!
I would like to know where you get special symbols like magnifying cute glasses or folder images ,etc. Please tell me how to do it ?
Those are emoji’s.
Use windows+. to open emoji keyboard
@@RezaDorrani Thank you. ^^
Mind blowing. Thank you!
Most welcome
Wow, thanks!
As always excellent. Thank you.
Most welcome
Hello Reza do you know if it is possible to search using multiple keywords?
Probably possible by framing the query differently. I would suggest exploring graph api filter query options.
@@RezaDorrani Thank you so much!
Great video. Thanks for sharing
Thanks for watching!
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?
I do not have a video reference on this scenario and would have to try it out to provide guidance. I recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.
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?
You can always pass source info from power app to flow.
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.
Search will return multiple results. You can simply present only 1 row of information.
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?
Most welcome!
I have not experienced this issue hence not sure.
Great tutorial Reza..could you please enable download option as i just subscribed to membership today and i cant access the app.
Thanks.
I covered memberships and download options in detail here th-cam.com/users/liveoSPw6WJdPoA?si=hZXt59g3XsbL-kS9
Hi, I purchased a silver club how to download the demo for this?
Check in membership tab
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
Graph should have that option. Not something I have explored though.
Hi, is there a download option for the package used in this vid?
Yes, it would be in the Membership tab of my channel for GOLD and SILVER members
Thanks, I searched through all the perks of the silver members, I can’t seem to find it 😢 Would you be able to link it here? Thank you! And amazing video by the way!
@@KristineTee-w4n Please post a comment on ANY of the download links shared for silver members and mention about this video. I will share link there.
Note: thepoweraddicts-my.sharepoint.com/:w:/g/personal/rdorrani_thepoweraddicts_onmicrosoft_com/EbvjdBY80QRGkT6svJEmzZwBz64PNYQDRvKHm8eRHEYe6Q?rtime=A8xvRp703Eg
One other question, did you get the Library Name somehow from the "path" property? If so, which method?
Yes, I used split function and then index to get it. I don’t remember the exact function. Video description has link to download entire app (members only)
That’s great. How can I show the content and highlights it in the result next to the pdf preview?
Thanks!
You mean the actual file content? I have not tried that so not sure.
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).
Should work with lists as well. I am not aware of any issues with it or limitations with DoD
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...
I have no clue about Power Pages
Thank you very much Reza for this video.
Most welcome
Hello Reza, what do you think I can do when the Power Automate flow result does return the file properties that should be populated in the gallery. I only get the file name, others like size, thumbnail, path, file type etc. are not returned by the flow. Do you think it is my SharePoint settings? Thanks.
@@tunjivictor9279 Read about managed properties in SharePoint search.
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.
Search will respect SharePoint security. I have not experienced the issue you have mentioned and hence not sure what is the cause for your issue. I recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
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?
I cannot know without looking at your scenario, search configuration etc. I have not come across this issue hence not sure.
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.
I do not have a video reference on this scenario and would have to try it out to provide guidance. I recommend checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com
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?
I have not come across the mentioned issue and hence not sure what the cause could be.
I recommend posting your issue on forums in case someone has experienced something similar powerusers.microsoft.com
@jamc41 did you get solution for your mentioned issue? I am also facing the same issue
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
Gallery is showcasing paginated results. Technique used can work with large data.
@@RezaDorrani 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?
Yes
This app is exactly the type project that I'm working on. How do I find it in the membership section. I've searched and scrolled to no avail? I'm looking for the app explained in this video please.
As a silver or gold member, go to any post on membership tab where I have shared a link for any video and make the request. Il share updated link there.
Hello, I have became a member, but how to easily find the link of sample Apps showcased in the video?
All links are in membership tab of the channel.
Also, check the first 10 mins of th-cam.com/users/livevI4IVxYQ5Y4?si=9bkEoV9XXuKQKdSQ
This is great! def testing it out!
👍
Brilliant Video as Always. My Gallery only returns 10 results showing but the search is retuning 38. Ho can I have the gallery show all items, I dont want to limit number to 10.
Thanks!
I have not experienced the mentioned issue, hence not sure whats the cause for your issue.
You can try downloading the solution shown in video (members only - check video description for details)
Hi Reza
Thank you for the video
Need some help but as I am also not to my file documents in behind the url if you or anyone else has a solution please
Video description has link to download entire solution (members only - check description for details)
Hi Reza is there any power app pdf component framework?
I have not done any work on pcf. I will recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.
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.
There is no delegation challenge here as it uses the SharePoint Search API.