Search, fill Results wrong

(Tô Huy) #1

Hi,
I have sheet,


I search “sports”, it returns result.
{{list_rows.results_+ gsx:special 1}}
It shows “http://static2.yan.vn/YanNews/2167221/20…” -> Wrong. It must shows “empty”.
Thanks

(Daniel Beckett) #2

Hi @To_Huy

Just to clarify, search rows and list rows are separate actions. They do behave pretty much the same way though.

When using list rows it will bring back all of the results for each row. This means that when you select from a column you’ll be using Collection Outputs. In the example you shared it looks like you’re pulling the first result from the “special” column.

(Tô Huy) #3

Hi @DanielBeckett
I have table


In “Comlum2”, I have 2 values: Electricity and sports.
I search “sports”, It returns list items results.
When I used <results.‘column1’ 1>, I must empty. right?

(Daniel Beckett) #4

There’s a bit of a bug with the Google Sheets service where if you list / search rows and pull back a result from a column that has empty cells it will instead grab the first result it can find. To stop this from happening you can add a blank space to any empty cells.

(Tô Huy) #5

Hi @DanielBeckett


a blank space
:frowning:

(Daniel Beckett) #6

Which action is that for?

It may be easier to troubleshoot everything if you email support@flowxo.com with a share of your flow. You can get this by clicking on the ‘private’ button near the top right corner when editing the flow. :slight_smile:

(Tô Huy) #7

Column 1 is link image,
I show it in Card Image.

(Daniel Beckett) #8

Ah, since it’s blank you won’t be able to use it as the card image. You could have two different card actions setup - one that sends the image url with a filter on the action so that it runs if the field isn’t equal to " " and another card action that doesn’t send any image url with a filter for the field being empty.