Messege when cann't find data in sheet

(M E) #1

i make a flow for get data and send it to user by id …
i want to make the bot sending message when " There was no matching row for the “Problem Id” column with value "

send a message like " your date is not available now in our sheets "
how can i do that … i think the flow is stopped because these log error

(Karen Barker) #2

Hi Mohammed,

If a row doesn’t exist then yes it will throw an error. You’d need to split this into 2 steps. Firstly search for the data. If the number of rows returned is greater than 0 then you can do the get data request to send to the user, otherwise you’ll be able to send a message saying “Date is not available”.

Hope this helps. :slight_smile:

Karen

2 Likes
(M E) #3

thank you very much ! :slight_smile: :wink: