I am building a Powerapp that will search a document library that consists of these column types:
When building my search, I am use the following formula:
It will find anything in the name column but not the other columns. What is the search formula to get it to search all the other columns? I can see the column names pulled up when adding to the formula but adding them breaks the search.
Thanks in advance.
Search( Table, SearchString, Column1 [, Column2, ... ] )
See in your use case, whether you can use Filter function.
|If this reply helped you to solve the issue, please mark the post as Accepted Solution. Marking this post as Accepted Solution, will help many other users to use this post to solve same or similar issue without re-posting the issue in the group. Saves a lot of time for everyone.|
This is the formula I am using now and it yields no results:
Search('Email Database - Testing',"",["Campaign","Audience","Target","Approval_x0020_Date","AM_x0020_Link"])
I have tried without brackets as well and either way it generates 6 errors - 5x wrong column type, expects text type and 1x the function search has some invalid arguments.
This is exactly what I'd like to do! But I've found this quite difficult to achieve. It seem using power apps with lists is straightforward, but doc libraries is a bit more tricky. Are you importing the doc library file info into a list first, or using these commands to search a doc library directly? Is there a specific piece of guidance documentation you've found useful in building this app? I seem to be going round in circles at the moment!
Yes I had the same problem, 2 SharePoint libraries and so I created a single SharePoint list and used Power Automate to take the document properties and copy them to this list. Then the power app could use this to search.