Answered

Filter and Search returning a full table with only a value in the searched column

(0) Share

Report

Posted on by CAH2035

193

I am attempting to use the Search function to find all rows containing a value in a single column of a table with many columns. Normally, I expect that if there are 5 rows containing the searched string in "Column 1", a table would be returned with 5 rows with all columns from the original table.

The result I am getting is five rows with all columns from the original table, however, only the values for "Column 1" are coming through. The values for the other columns are missing, and they absolutely do have values. I am not using any additional functions that would limit to only that column.

The source table is in Dataverse (for Teams) but I am not sure if that is the cause, or how to resolve it if that is the case.

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Drrickryp Super User 2024 Season 1 on at

Like (0)

Report

@cah2035

Please post your Filter/Search function.

Was this reply helpful? Yes No
CAH2035 193 on at

Like (0)

Report
Search Function and Result:
ClearCollect( testcol, Search( ResourceRequestsCTPs, "APCP585-REQ23631", "cr739_trprequests_ctprequestid" ) )

Simply grabbing the first row (same record):
ClearCollect( testcol, First( ResourceRequestsCTPs ) )

Was this reply helpful? Yes No
Verified answer

v-jefferni on at

Like (0)

Report
Hi @cah2035 ,

When using Dataverse table as the data source to collect a collection, you will only be able to get values in the searching column, so as in SQL server. This can reduce the amount of data returned to the app to improve the performance of the app. If you would like to collect all columns data into the collection, you can use ShowColumns function to list all the column names:

ClearCollect( testcol, ShowColumns( Search( ResourceRequestsCTPs, "APCP585-REQ23631", "cr739_trprequests_ctprequestid" ), "cr739_trprequests_ctprequestid", "other column1", "other column2", ... ) )

Hope this helps.

Best regards,

Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution to help the other members find it.

Was this reply helpful? Yes No