# Difficulty sending personalized email with information split in two tables that do not have all common points
**URL:** https://community.glideapps.com/t/difficulty-sending-personalized-email-with-information-split-in-two-tables-that-do-not-have-all-common-points/70947
**Category:** Ask for Help
**Tags:** actions
**Created:** [February 19, 2024, 6:20am UTC](https://community.glideapps.com/t/difficulty-sending-personalized-email-with-information-split-in-two-tables-that-do-not-have-all-common-points/70947 "2024-02-19T06:20:03Z")
**Posts on this page:** 7
**Page:** 2
### Author:  [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [February 23, 2024, 6:59am UTC](https://community.glideapps.com/t/difficulty-sending-personalized-email-with-information-split-in-two-tables-that-do-not-have-all-common-points/70947/21 "2024-02-23T06:59:55Z")
I was referring to the below - what happens if you swap those actions so that the Set Column Values comes first?
---
### Author:  [@prettycold](https://community.glideapps.com/u/prettycold)
#### Post date: [February 23, 2024, 7:17am UTC](https://community.glideapps.com/t/difficulty-sending-personalized-email-with-information-split-in-two-tables-that-do-not-have-all-common-points/70947/22 "2024-02-23T07:17:19Z")
Bid Proposals Helper is a Single Row table that has the value of the Final JSON which is what I’m trying to set in my user profile row. So it won’t help if I swap.
One discrepancy I notice is, although there are 2 records in Bid Proposals, when I click on the Data below, initially I see only 1. Sometimes I see both. Not sure why.
One point that I missed to mention is, I “Show new screen” and map it to Bid Proposals table when the user clicks on Verify & Send email button. It’s not a form screen.
---
### Author:  [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [February 23, 2024, 1:04pm UTC](https://community.glideapps.com/t/difficulty-sending-personalized-email-with-information-split-in-two-tables-that-do-not-have-all-common-points/70947/23 "2024-02-23T13:04:06Z")
So you are trying to get a value from the relation and write it to the user table? I see you have a relation, which is a link to an entire row but I don’t see any Lookup columns to retrieve any specific column values out of the relation.
---
### Author:  [@prettycold](https://community.glideapps.com/u/prettycold)
#### Post date: [February 23, 2024, 1:25pm UTC](https://community.glideapps.com/t/difficulty-sending-personalized-email-with-information-split-in-two-tables-that-do-not-have-all-common-points/70947/24 "2024-02-23T13:25:05Z")
Jesus! What was I thinking, How on earth did I miss that? 🙄
Thank you sooo much @Jeff_Hager !
---
### Author:  [@prettycold](https://community.glideapps.com/u/prettycold)
#### Post date: [February 27, 2024, 6:08am UTC](https://community.glideapps.com/t/difficulty-sending-personalized-email-with-information-split-in-two-tables-that-do-not-have-all-common-points/70947/25 "2024-02-27T06:08:04Z")
@ThinhDinh - I made decent progress with invoking the zap where I send the JSON Payload and the number of JSON Objects in it as 2 values to my Zap.
I wrote a 3 step Zap where I use Code by Zap (using Python) where I put the objects in a dictionary and then invoke Send Outbound email by Zapier.
I’ve a problem sending this JSON Payload to my Zap as when I trigger the action from my Glide app and look at the Zap run, the value corresponding to JSON Payload doesn’t seem to be present. I tried to pass a lookup column, then changed to a Single value column, a text column. No luck!
My Zap definition from Glide:
This is that single value column that I set in my Zap trigger:
And when I click on the button that triggers this Glide action in my app, It calls the Zap and fails there with the following:
Though I pass 2 values, in the zap output only Value 2 is passed.
Anything catches anybody’s eye?
Just to test the zap, I tested the entire step by hardcoding the same JSON in my Code By Zap test and it neatly picks up each JSON Object and sends an email as I expect to.
This is my code test in Zap:
This is my Email step in Zap:
---
### Author:  [@prettycold](https://community.glideapps.com/u/prettycold)
#### Post date: [March 1, 2024, 12:13pm UTC](https://community.glideapps.com/t/difficulty-sending-personalized-email-with-information-split-in-two-tables-that-do-not-have-all-common-points/70947/26 "2024-03-01T12:13:16Z")
@ThinhDinh - This one is complete now. With Trigger Webhook suggestion that you gave on [the other thread](https://community.glideapps.com/t/all-of-a-sudden-a-particular-zap-is-not-getting-triggered-from-my-glideapp/71242/5), I was able to complete this step.
I shall very soon write a post on how to perform sending multiple personalized emails in one click of a button using Zapier. Once done, will share it here as well. Thanks much for all the help!
---
### Author:  [@system](https://community.glideapps.com/u/system)
#### Post date: [March 8, 2024, 12:13pm UTC](https://community.glideapps.com/t/difficulty-sending-personalized-email-with-information-split-in-two-tables-that-do-not-have-all-common-points/70947/27 "2024-03-08T12:13:16Z")
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.
[Previous page](https://community.glideapps.com/t/difficulty-sending-personalized-email-with-information-split-in-two-tables-that-do-not-have-all-common-points/70947.md?page=1)