Unanswered

Can I embed a variable within a variable?

(0) Share

Report

Posted on by suemv

I'm working on streamlining some flows that use Excel and Outlook connector (Send an email V2). I'd like to define the email body as a variable in an Excel table but the email body also currently contains other variables. I'm not sure if what I want to do is possible. I've tried formatting the embedded variables to no avail.

Is this possible?

Categories:

General topics

I have the same question (0)

All responses (8)

Answers (0)

Sort by

v-yueyun-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

HI , @suemv

Can you show me a sample you want to get in your flow?

Best Regards,

Yueyun Zhang

Was this reply helpful? Yes No
suemv on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @v-yueyun-msft

Thanks for replying. As an example, I'm trying to put the footer content in an Excel table and just call the Footer variable. For the most part it works! However, there's a variable in the Footer variable that doesn't render. 😑

I've tried using the percentage symbols (%var% or %%var%%) and nothing works. Is this just another limitation from the outlook connector? I can't be the only one who's tried to use a variable within a variable, right?🤣

Was this reply helpful? Yes No
Nived_Nambiar 18,138 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @suemv

so you meant that the HTML component of the footer variabke does not show up in the email viewed in outlook ?

Thanks & Regards,
Nived N 🚀

LinkedIn: Nived N's LinkedIn
YouTube: Nived N's YouTube Channel
Blog: Nived Nambiar's Blogs

🔍 Found my answer helpful? Please consider marking it as the solution!
Your appreciation keeps me motivated. Thank you! 🙌

Was this reply helpful? Yes No
suemv on at

Like
a
(0)

Report
Copy link

Link copied!

Correct! The variable within the footer variable just shows up as jibberish. Let's say it's a year or date. It appears as %%'whatever'&&. It doesn't matter which quotation marks or how many % I use or their sequence in the string, it's not working.

To be clear, the footer as a whole renders fine. It's just the embedded variable that's not working.

Was this reply helpful? Yes No
Nived_Nambiar 18,138 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @suemv

Ok ,did you check in outlook online and outlook and any difference observed ?

Also could you show footer looks like so that i can see how whatever look ?

Thanks & Regards,
Nived N 🚀

LinkedIn: Nived N's LinkedIn
YouTube: Nived N's YouTube Channel
Blog: Nived Nambiar's Blogs

🔍 Found my answer helpful? Please consider marking it as the solution!
Your appreciation keeps me motivated. Thank you! 🙌

Was this reply helpful? Yes No
suemv on at

Like
a
(0)

Report
Copy link

Link copied!

I just checked outlook online. It shows the same results.

This is what it looks like if I just copy the code for the footer from the body pane and put it in an Excel table. The copyright is already a defined variable. For this example, I didn't add any % or ' to the var_Year variable.

Was this reply helpful? Yes No
Nived_Nambiar 18,138 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @suemv

doesn't seems like a bug- i have tried something simmilar - like embedding a year in a footer variable like below

And using this footer in a send email like below

And the mail looks like this-

Let me know if it is something simmilar what you are trying to do, if not- tell me what changes were there ?

Thanks & Regards,
Nived N 🚀

LinkedIn: Nived N's LinkedIn
YouTube: Nived N's YouTube Channel
Blog: Nived Nambiar's Blogs

🔍 Found my answer helpful? Please consider marking it as the solution!
Your appreciation keeps me motivated. Thank you! 🙌

Was this reply helpful? Yes No
suemv on at

Like
a
(0)

Report
Copy link

Link copied!

I have the footer variable and the year variable. I can't embed the year variable in the footer variable. I'm trying to reuse the footer across various flows by storing the content in an Excel table. Unfortunately, the year variable just shows up as code as seen previously.

Was this reply helpful? Yes No