About Zapier Community
New to our Community? Get to know more about our space and how to make the most of your time here.

Code of Conduct Community FAQ's Zapier Common Questions What to Expect

Get Started With Zapier
New to Zapier? We have got you covered with our Zapier 101 Resources.

Zapier Essentials

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Zapier Products
Learn more about Zapier's new products.

Zapier Tables Zapier Interfaces

Zapier Reading
All of our best learning resources can be found here.

Featured Articles Show & Tell AI Hub Zapier Tools Hub

Learning Groups
Excited to meet other builders? Check out our interest areas full of doers, dreamers, and in-betweeners.

User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

Best answer

Failed to find a find row in Microsoft Excel

S
Userlevel 1

Hi there,

 

I am using Microsoft "Excel - Find Row" and using a hard-coded Lookup Value.

 

When I run it, it doesn't find the value in my data, although it exists, and instead gives me an error.

 

The value is just a string. I can also use “6” which is in every row in that column, but it does not return any results.

What am I doing wrong?

 


 


 

 

icon

Best answer by sd2024 11 April 2024, 10:05

View original

11 replies

Troy Tessalone
Userlevel 7
Badge +14

Hi @sd2024 

Help articles for using Excel in Zaps: https://zapier.com/apps/excel/help

 

  • There can be no completely blank rows before the end of your spreadsheet.


⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
S
Userlevel 1

@Troy Tessalone 

Thanks for getting back to me. The entire row is not blank, and rows contain data in other columns. I did not include the data in the screenshot as it is sensitive data.

Do you mean it can’t have blank data in that column for the lookup?

Troy Tessalone
Userlevel 7
Badge +14

@sd2024 

In general, I advise users to use other apps such as Airtable or GSheets in stead of Excel.

 

Things to check/try:

Reselect each dropdown field value.

Check the Lookup Value has no leading/trailing whitespace.

 

 

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
S
Userlevel 1

Unfortunately, I can’t change to a better platform. But I do agree that other platforms are better.

@Troy Tessalone I made the changes now and added data into the column where it was blank, and it didn’t change the outcome and still has the issue/error.

I also re-selected each dropdown field value, as per your suggestion.

Troy Tessalone
Userlevel 7
Badge +14

@sd2024

Try testing with other Lookup Values to see if you still encounter the error.

 

If you are going to use using a static lookup value, then do you even need the Excel step?

Perhaps just add the other column data to the following Zap step fields.

 

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
S
Userlevel 1

 @Troy Tessalone I get that “ID” from Trello in a previous step. In the live case, there is “no data”, so I have to rely on the test output in order to map data to steps thereafter.

I tried with other values and for each it gave the same error message.

Troy Tessalone
Userlevel 7
Badge +14

@sd2024 

Try this…

Map the dynamic variable for the Lookup Value field.

Turn the Zap ON.

Test live.

Check your Zap Runs history to see the DATA IN/OUT for each step: https://zapier.com/app/history/

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
S
Userlevel 1

 
@Troy Tessalone

 
Data In : 
 

storage_source : one_drive

folder_id : 01B6JRWY2ROG6XTWUHZZBZBSCR6QS3GJCU

_zap_search_success_on_miss : False

workbook_id : 01B6JRWY3N6DVL4PDEFBD3HAQIBVQHHBDX

worksheet_id : {0198D1C8-8809-7D48-9CD1-EE919ADF20B6}

lookup_key : COL$A

lookup_value : 65fe7a915fc7fc23c7c90c4d

Data Out : Nothing

Same error as before, Live. I also recreated the step, but that also did not change anything.

Troy Tessalone
Userlevel 7
Badge +14

@sd2024 

You can try opening a ticket with Zapier Support: https://zapier.com/app/get-help

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
S
Userlevel 1

@Troy Tessalone I think I figured it out. The issue was the file I was working on on Zapier and the file that I am looking at on Excel is different. Their names were very similar, but they are not the same.

I created a Table in the file I have in Excel, and it didn’t show up on Zapier. 

Thank you very much for your help and assistance.

ken.a
Userlevel 7
Badge +6

That’s an awesome news @sd2024! We’re glad to hear that the issue is now resolved.

Also, a huge thanks to Troy for lending a hand here.

If you have any other questions, please don’t hesitate to reach out to the Community. We’re always happy to help! 🤗

Reply


Terms & Conditions