SOLVED

Using @ symbol in logic app with dynamic content

%3CLINGO-SUB%20id%3D%22lingo-sub-633903%22%20slang%3D%22en-US%22%3EUsing%20%40%20symbol%20in%20logic%20app%20with%20dynamic%20content%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-633903%22%20slang%3D%22en-US%22%3E%3CP%3EWhen%20a%20alert%20query%20uses%20the%20AccountcustomEntity%20mapping%2C%20when%20the%20case%20is%20created%20the%20users%20UPN%20is%20broken%20up%20into%20Account%20Name%20and%20UPN%20suffix%2C%20which%20can%20be%20obtained%20from%20the%20case%20with%20a%20logic%20app%20step%20to%20be%20used%20as%20dynamic%20content.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20code%20to%20use%20UPN%20suffix%20as%20a%20dynamic%20step%20is%20%40%7Bitems('For_each')%3F%5B'UPNSuffix'%5D%7D.%26nbsp%3B%20When%20I%20try%20to%20generate%20an%20email%20that%20includes%20in%20the%20body%20(Account%20Name)%40(UPN%20suffic)%2C%20the%26nbsp%3B%40%20symbol%20that%20precedes%20%40%7Bitems('For_each')%3F%5B'UPNSuffix'%5D%7D%20causes%20problems.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHas%20anyone%20else%20run%20into%20this%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAndrew%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-638276%22%20slang%3D%22en-US%22%3ERe%3A%20Using%20%40%20symbol%20in%20logic%20app%20with%20dynamic%20content%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-638276%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F306179%22%20target%3D%22_blank%22%3E%40andrew_bryant%3C%2FA%3E%3A%20Hi%20Andrew%2C%20thank%20you%20for%20taking%20your%20time%20to%20post.%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EHi%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F293879%22%20target%3D%22_blank%22%3E%40Ofer_Shezaf%3C%2FA%3E%3A%20Is%20this%20something%20you%20can%20speak%20to%3F%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F89690%22%20target%3D%22_blank%22%3E%40Chris%20Boehm%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-650054%22%20slang%3D%22en-US%22%3ERe%3A%20Using%20%40%20symbol%20in%20logic%20app%20with%20dynamic%20content%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-650054%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%0A%3CP%3EI%20would%20recommend%20that%20you%20either%20initialize%20a%20variable%20at%20the%20start%2C%20then%20set%20that%20variable%2C%20or%20perhaps%20use%20a%20function%20concat%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1449787%22%20slang%3D%22en-US%22%3ERe%3A%20Using%20%40%20symbol%20in%20logic%20app%20with%20dynamic%20content%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1449787%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F306179%22%20target%3D%22_blank%22%3E%40andrew_bryant%3C%2FA%3E%26nbsp%3Bcould%20you%20please%20share%20the%20concatenated%20string.%20Can't%20figure%20out.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1450167%22%20slang%3D%22en-US%22%3ERe%3A%20Using%20%40%20symbol%20in%20logic%20app%20with%20dynamic%20content%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1450167%22%20slang%3D%22en-US%22%3EIF%20you%20are%20trying%20to%20use%20a%20hardcoded%20%40%2C%20have%20you%20tried%20escaping%20it%20by%20prepending%20'%20%3F%3C%2FLINGO-BODY%3E
Contributor

When a alert query uses the AccountcustomEntity mapping, when the case is created the users UPN is broken up into Account Name and UPN suffix, which can be obtained from the case with a logic app step to be used as dynamic content.

 

The code to use UPN suffix as a dynamic step is @{items('For_each')?['UPNSuffix']}.  When I try to generate an email that includes in the body (Account Name)@(UPN suffic), the @ symbol that precedes @{items('For_each')?['UPNSuffix']} causes problems.

 

Has anyone else run into this?

 

Thanks,

 

Andrew

4 Replies

@andrew_bryant: Hi Andrew, thank you for taking your time to post. 

 

Hi @Ofer_Shezaf: Is this something you can speak to? 

@Chris Boehm 

Best Response confirmed by andrew_bryant (Contributor)
Solution

Hi,

I would recommend that you either initialize a variable at the start, then set that variable, or perhaps use a function concat

@andrew_bryant could you please share the concatenated string. Can't figure out.

IF you are trying to use a hardcoded @, have you tried escaping it by prepending ' ?