Google sheets Search rows Do not returning Data (Output)

Questions & Answers
1

Hello everyone, I am facing this problem for 4-5 days and cannot find solution. MY scenario is this: Webhook receives data date but it is string,name, surname and phone number ,Google sheets Search rows Should have to search for similar date and time from google sheets, and then Google sheets update Row PLACE Name, Surname and phone number to that line which been received from Search Rows by placing ROW NUMBER RECEIVED from Search Rows.
Here is the problem, the google sheets search rows do not return any similar data, even i checked everything, I used AND filter to separate date and time because there columns in google sheets DATE AND TIME ALSO separated

BELOW YOU CAN SEE ALL INFORMATION TO FIND IF THERE IS MISTAKE. PLEASE HELP ME TO FIND OUT MISTAKE .

Π‘Π½ΠΈΠΌΠΎΠΊ экрана 2024-01-31 Π² 21.51.40
Π‘Π½ΠΈΠΌΠΎΠΊ экрана 2024-01-31 Π² 21.51.402880Γ—1244 443 KB

Π‘Π½ΠΈΠΌΠΎΠΊ экрана 2024-01-31 Π² 21.52.16
Π‘Π½ΠΈΠΌΠΎΠΊ экрана 2024-01-31 Π² 21.52.161920Γ—896 86.8 KB

Π‘Π½ΠΈΠΌΠΎΠΊ экрана 2024-01-31 Π² 21.52.07
Π‘Π½ΠΈΠΌΠΎΠΊ экрана 2024-01-31 Π² 21.52.071920Γ—896 101 KB

Π‘Π½ΠΈΠΌΠΎΠΊ экрана 2024-01-31 Π² 21.52.29
Π‘Π½ΠΈΠΌΠΎΠΊ экрана 2024-01-31 Π² 21.52.291920Γ—896 95.6 KB

Π‘Π½ΠΈΠΌΠΎΠΊ экрана 2024-01-31 Π² 21.52.36
Π‘Π½ΠΈΠΌΠΎΠΊ экрана 2024-01-31 Π² 21.52.361920Γ—896 96 KB

2

Instead of using β€˜Datetime operator equal to’, I suggest using the β€˜Text operator equal to’ because google sheets returns the date as a string and you are also converting date into string.

2 Likes
3

there it is , but didnt helped

Π‘Π½ΠΈΠΌΠΎΠΊ экрана 2024-01-31 Π² 23.05.07
Π‘Π½ΠΈΠΌΠΎΠΊ экрана 2024-01-31 Π² 23.05.071632Γ—1202 189 KB

4

just realised that if i delete "AND: filter where time is written it returns data , but not the special one i need

5

could you please share the output of the webhook?

2 Likes
6

sure

Π‘Π½ΠΈΠΌΠΎΠΊ экрана 2024-01-31 Π² 23.10.58
Π‘Π½ΠΈΠΌΠΎΠΊ экрана 2024-01-31 Π² 23.10.581632Γ—1202 180 KB

7

Instead of date format try to use split function

image
image499Γ—847 34.3 KB

4 Likes
8

Well your google sheet has the value

9:00

for the time.

And your filter is converting the date value with a leading 0 to

09:00

These won’t be equal.

try a different mask that does not return leading zeros (assuming you’re putting a 24 hour time into Google Sheets)

formatDate(date,k:mm)

The masks are all documented here: https://www.make.com/en/help/functions/tokens-for-date-time-formatting#hour--minute--second--millisecond--and-offset-tokens-935202

If you are using a 12 hour time use h:mm instead.

3 Likes
9

THANK YOU MY HERO A LOT,

Canadian Thank You GIF by NETFLIX

1 Like
10

Ahhh, well the 1.date string wasn’t a date value after all and was just a space delimited string… the split() would not work on a native datetime value since there is no space inside it. Good eye @RBalani !

Seeing the actual output bundle in the webhook would help to figure out what sort of data type 1.date is.

5 Likes