Hi @AeJay 

Please screenshot your Xero step so we can help you better.

Keep in mind that it might be you are passing wrong values. For example, Xero might be expecting an ID but you are passing a name

Hi @MohSwellam ,

Thanks for the tip! I’ve attached screenshots below.

Hi @AeJay 

It seems the values you have in most fields are incorrect. 
 

This is a quick tutorial on how to make sure the values you have in the fields are the correct ones that Zapier expects. 
 

So unless you have those correct values in Smartsheet, you will need Search Actions in Xero to get the correct values then Create the quote

Hey there @AeJay, 

The fact that the error reports that your account needs to be reconnected is something you can attempt to resolve by going to https://zapier.com/app/connections, clicking on Xero in the list, and then clicking on the 3 dots to the right, then Reconnect.  A popup window will appear and follow the steps there. 

I know you said you tested it and there were no errors, but let's try a reconnect to see if that helps as well.

With regards to the input, I do see a at least 1 issue with the input here:

That type of field is what we call a “Dynamic Dropdown” field, and it requires a very specific input and I would guess the typed “client” portion in the front is not correct.  In general if you are using a non-Xero trigger to send data into Xero, you would likely have to do a few Find steps in Xero to find the appropriate Organization and Contact IDs.  If you already have these exported directly from Xero into Smartsheets for these trigger events, it could be a different input that is causing an error to occur which you may see once you resolve the account issue.  

Have a look at this when you get a chance and let us know how it goes!

I’ve tried to reconnect multiple times, it says it is connected.

 

With regards to the input, I do see a at least 1 issue with the input here:

 

That type of field is what we call a “Dynamic Dropdown” field, and it requires a very specific input and I would guess the typed “client” portion in the front is not correct.  In general if you are using a non-Xero trigger to send data into Xero, you would likely have to do a few Find steps in Xero to find the appropriate Organization and Contact IDs.  If you already have these exported directly from Xero into Smartsheets for these trigger events, it could be a different input that is causing an error to occur which you may see once you resolve the account issue.  

Have a look at this when you get a chance and let us know how it goes!

Yeah, I directly exported the client names from Xero into the single select client field in Smartsheet. Nobody said anything about typing anything. I’m assuming this is correct? Let me know if I’m missing something.

Yeah, so, I have set up the Zap as per the video, not sure how this helps? And also the ‘client’ field in Smartsheet is just an import of the Xero organization list.

Your saying most fields are incorrect, can you point out a specific one, why its incorrect and how to fix it? That’d sure be helpful!!!

AJ

Hang on, light bulb moment… what I actually need in Smartsheet is not just the client ‘name’ if a particular client, but their organization ID. Got it. Thanks.

We love a good moment, @AeJay! Thanks for closing the loop here on what worked for you!