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.

  • Home
  • Get Help
  • How Do I
  • Xero - Monday: How do I setup Monday.com board to only show outstanding invoices?

I have created a Zap so that every time a new sales invoice is created in Xero it shows on the invoice board in Monday.com - this is working fine. 

However I am now trying to create another Zap that when the invoice has been paid in Xero it automatically deletes from Monday.com. Basically I just want the board to show outstanding invoices.

I cannot get this step to work, it lets me set up the trigger as “new payment received” in Xero but when I try to set the “action” as delete or archive item matching invoice number in Monday.com the step just errors. It either has  The app returned "User unauthorized to perform action" or The app returned "Internal server error". 

Does anyone know how to fix this? 

Hey @Chels0780 ,

 

Can you post screenshot of your 2nd Zap and how have you configured action? Also, Are you using an action to Lookup values in Monday Board in 2nd Zap?

Thanks so much for replying, here are the screen shots for the Zap. 

Hey @Chels0780 ,

 

You will have to add below action to lookup for the item id, which you can use in Monday - Delete Item action.

 

 

hmm ok so I’ve done that and then added an additional action of deleting the item but it’s still not working :(

 

Hey @Chels0780 ,

 

Can you post screenshot of updated action?

 

Hey @Chels0780 ,

 

This is incorrect input in Action 3. You will see a value of Item id in action 2 output, use that in Action 3 input.

 

 

Thank you so much! I got the test to complete and it deleted the paid invoice! However, I’ve just tested it myself adding a new invoice to Xero - the Zap works and it appears in Monday - then I’ve put through a payment received and it’s not automatically deleted it from the board? Even though the test function in Zap did work? 

Hey @Chels0780 ,

 

Can you go to Zap History and share screenshot of Data In and Data Out?

 

Hey @Chels0780 ,

 

The reason your Zap did not work is because it failed. Click on anyone failure history and check for the errors. 

It’s gone through now but I had to manually click run Zap? Should it not be automatic? 

 

Hey @Chels0780 , That should be automatic. Can you check from the history what was the error?

It said no item was found even though there was a payment - 

 

I have retested and it is working now, maybe I didn’t give it long enough to process! Thank you so much for your help, wouldn’t have got there without it! :raised_hands_tone1:

Terms & Conditions