Powerapps search of Sharepoint document library - multiple column types

(0) Share

Report

Posted on by dgillespie

I am building a Powerapp that will search a document library that consists of these column types:

single line of text
choice
date and time
hyperlink or picture
person or group

When building my search, I am use the following formula:

Search('Doc library',SearchBox.Text,"{Name}")

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.

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (0)

rsaikrishna

3,703 on at

Like (0)

Report

Copy link

Link copied!

@dgillespie

Search( Table, SearchString, Column1 [, Column2, ... ] )

Table - Required. Table to search.
SearchString - Required. The string to search for. If blank or an empty string, all records are returned.
Column(s) - Required. The names of columns within Table to search. Columns to search must contain text. Column names must be strings and enclosed in double quotes. However, the column names must be static and cannot be calculated with a formula. If SearchString is found within the data of any of these columns as a partial match, the full record will be returned.

Reference: https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-filter-lookup

See in your use case, whether you can use Filter function.

Regards

Krishna Rachakonda

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.

Was this reply helpful? Yes No

dgillespie 84 on at

Like (0)

Report
Copy link

Link copied!
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.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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!

Was this reply helpful? Yes No
PaulyWauly 4 on at

Like (1)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No