My users will be using Distributed Marketing quick send from the standard Contact record. I need to pull User data into a content template for the email signature. Right now I'm just trying to get the phone number from the user sending the email.
Can't seem to figure out if there is some kind of additional access that needs to be granted or if I am missing something else.
User_Salesforce_1 is my synchronized User object DE living in a child BU.
Email is the standard Email field on User I'm using to match @sendFromEmail on the main QS Journey DE.
I have multi-org connected.
%%[
var @rows, @row, @senderemail, @phone
set @senderemail = AttributeValue("sendFromEmail")
set @rows = LookupRows("User_Salesforce_1","Email",@sendFromEmail)
set @row = Row(@rows, 1)
set @phone = Field(@row,"Phone")
]%%
<p>
%%=(@phone)=%%
</P>
Here is the Error
The subscriber preview failed to generate. Review the details, correct all issues, and try again. The Data Extension name for a LookupRows function call is invalid. A Data Extension of this name does not exist. Data Extension Name: User_Salesforce_1 Function Call: LookupRows("User_Salesforce_1","Email",@sendFromEmail) Parameter Name: DataExtensionName Parameter Ordinal: 1
