Skip to main content

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

Learning Resources
All of our best learning resources can be found here.

Featured Articles Show & Tell Zapier's products AI Hub Zapier Tools Hub

Share your knowledge
Give back to the Community by sharing your automation wins and helping to answer questions.

Share your success See unanswered questions 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

Find Row Excel - 400 Bad Request

  • November 3, 2022
  • 3 replies
  • 143 views
C

Hi,

Please help,

I have parsed incoming mail and get PartNo information. My mission to find this PartNo in the Excel file on OneDrive and get whole row.

Parser working good (test return OK). Parser can find Part Number successfully. I connected and successfully configured everything in Find Row in Microsoft Excel, but when I try to test it is return  “400 Bad Request”.

I don’t have any detail about error. Everything run well till the Excel test.

  • PartNo is unique number in the table in the Excel.
  • PartNo is alphanumeric value.
  • The table in the Excel is error free table.

Can anyboady help me?

Best answer by CelilBest answer by Celil

I found the problem.

In excel A column is hidden. When selecting the related lookup column in Excel App, it shows the wrong column char (eg. E). Actually, Its column char should be D. 

If there are no technical names in the testing phase and you do not pay attention to them, it is not possible to understand the error. Bacause of that there is a bug actually:

Bug Definition:

In case there is a hidden column in Excel when you select the lookup column, the Excel App selects the wrong column in the background. You can check it in the Test Section of the Excel App by checking the technical name of the lookup column.

regards,

View original
Did this topic help you find an answer to your question?

3 replies

C
  • CelilBeginner
  • Author
  • Beginner
  • 2 replies
  • November 3, 2022

In addition to that:

  • The table in the Excel has not empty field. All rows are full.
  • Even if I’m giving value (like 624-745-78) directly (not from parser), it is still not working

 

C
  • CelilBeginner
  • Author
  • Beginner
  • 2 replies
  • Answer
  • November 3, 2022

I found the problem.

In excel A column is hidden. When selecting the related lookup column in Excel App, it shows the wrong column char (eg. E). Actually, Its column char should be D. 

If there are no technical names in the testing phase and you do not pay attention to them, it is not possible to understand the error. Bacause of that there is a bug actually:

Bug Definition:

In case there is a hidden column in Excel when you select the lookup column, the Excel App selects the wrong column in the background. You can check it in the Test Section of the Excel App by checking the technical name of the lookup column.

regards,

christina.d
Forum|alt.badge.img+9
  • christina.dZapier Staff
  • Zapier Staff
  • 2653 replies
  • November 10, 2022

Hey there, @Celil! Thanks so much for raising this in community and sharing what you found!

I did some digging around and it looks like there’s a similar issue with Google Sheets throwing errors when column A is hidden. It’s mentioned in the documentation here with an associated bug report on our end as well. I didn’t find any mention about this in the Excel documentation but it would make sense it would have similar issues. 

I’d actually recommend opening a ticket with my teammates in support so they can dig into this a bit further and if need be open a bug report for Excel too. Please feel free to link them to the zap and this community thread for reference as well.

Thank you again for reporting this!

Reply


Terms & Conditions