• Instructions to Ask a Question

    Click on the "Ask a Question" button and select the application for which you would like to ask questions.

    We have 5 different products namely - Pabbly Connect, Pabbly Subscription Billing, Pabbly Email Marketing, Pabbly Form Builder, Pabbly Email Verification.

    The turnaround time is 24 hrs (Business Hours - 10.00 AM to 6.00 PM IST, Except Saturday and Sunday). So your kind patience will be highly appreciated!

    🚀🚀Exclusive Discount Offer

    Just in case you're looking for any ongoing offers on Pabbly, you can check the one-time offers listed below. You just need to pay once and use the application forever -
     

    🔥 Pabbly Connect One Time Plan for $249 (🏆Lifetime Access) -  View offer 

    🔥 Pabbly Subscription Billing One Time Plan for $249 (🏆Lifetime Access) - View offer

Google Sheets to Microsoft Office 365 integration

ghalitzka

Member
I'm working on an integration between Google Sheets (Trigger: New or updated spreadsheet row) and Microsoft Office 365 (Action: Send mail to multiple users).

I'm using the concatenate function in Sheets to format emails properly to transmit to Outlook in the format:
{"emailAddress": {"address": "[email protected]"}}

Then I'm using TEXTJOIN to combine multiple addresses with a comma separator. So the result looks like this:
{"emailAddress": {"address": "[email protected]"}},{"emailAddress": {"address": "[email protected]"}}

So long as I'm combining at least two addresses, everything works great! But when I try to send a message to a single address, something in the chain (I suspect it's Google Sheets, but it could also be Pabbly) is stripping off the proper formatting.

Instead of looking like this:
{"emailAddress": {"address": "[email protected]"}}

The email is sent to Office 365 in a "plain" format like this:
[email protected]

That triggers an error in Office when I try to send the message because the address is not properly formatted.

Could you give me any pointers on how I might be able to resolve this, so that Office 365 receives a properly formatted email address, even when there's only a single address involved?
 
P

Pabblymember11

Guest
Hey @ghalitzka

Could you give me any pointers on how I might be able to resolve this, so that Office 365 receives a properly formatted email address, even when there's only a single address involved?
As we can see from your recent task history you have properly managed to pass the email address in the given format.

1672035019243.png
 
Top