Skip to main content
Best answer

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? 

Best answer by jayeshkumarbhatiaBest answer by jayeshkumarbhatia

Hey @Chels0780 ,

 

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

 

 

View original
Did this topic help you find an answer to your question?
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

15 replies

jayeshkumarbhatia
Forum|alt.badge.img+6

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?


  • Author
  • Beginner
  • 8 replies
  • November 15, 2021

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


jayeshkumarbhatia
Forum|alt.badge.img+6

Hey @Chels0780 ,

 

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

 

 


  • Author
  • Beginner
  • 8 replies
  • November 15, 2021

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

 


jayeshkumarbhatia
Forum|alt.badge.img+6

Hey @Chels0780 ,

 

Can you post screenshot of updated action?


  • Author
  • Beginner
  • 8 replies
  • November 15, 2021

 


jayeshkumarbhatia
Forum|alt.badge.img+6

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.

 

 


  • Author
  • Beginner
  • 8 replies
  • November 15, 2021

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? 


jayeshkumarbhatia
Forum|alt.badge.img+6

Hey @Chels0780 ,

 

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


  • Author
  • Beginner
  • 8 replies
  • November 15, 2021

 


jayeshkumarbhatia
Forum|alt.badge.img+6

Hey @Chels0780 ,

 

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


  • Author
  • Beginner
  • 8 replies
  • November 15, 2021

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

 


jayeshkumarbhatia
Forum|alt.badge.img+6

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


  • Author
  • Beginner
  • 8 replies
  • November 15, 2021

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

 


  • Author
  • Beginner
  • 8 replies
  • November 15, 2021

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: