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
Highlighted
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
Highlighted

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

 

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

@Chris Boehm 

Highlighted
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

Highlighted

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

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