Get Text with dynamic content

(0) Share

Report

Posted on by TheFactorY

Hi All

Havent fround a solution to this yet. Has anybody got an idea?

Looking to import a .txt file (or orther format, if needed) as the body for an email. This text file however shall include dynamic content.

The .txt file has following content:

Dear @{outputs('Create_TFY_DataPartner_Entry')?['body/FirstName']},

This is only a test if dynamic content can be imported.

I was actually expecting the compose function to take up on the dynamic content. However it just produces the raw text version:

Anybody know how to import dynamic content?

Thanks!!!

Categories:

Building flows

I have the same question (0)

All responses (7)

Answers (0)

fchopo 8,003 Moderator on at

Like (0)

Report

Hi @TheFactorY

This is because you're writing the expression as "dynamic content" instead of using "expression":

Hope it helps!

Ferran

Was this reply helpful? Yes No
TheFactorY 29 on at

Like (0)

Report

Thank you Ferran

But im not writing anything. I want to import it from a .txt file...

I can copy paste " @{outputs('Create_TFY_DataPartner_Entry')?['body/FirstName']}" and it immediately gets recognised as expression. But when i import it trough a .txt, it does not ...

Was this reply helpful? Yes No
fchopo 8,003 Moderator on at

Like (0)

Report

Hi @TheFactorY

Let's see if I'm able to understand your problem. This is the test I've did and it works:

Questions:

a) Is the content of your file in JSON format?

b) Why are you using "Body" instead of "File Content?

If the file is based on a JSON structure, then you need to parse it using "Parse JSON" and specifying the format.

Hope it helps!

Ferran

Was this reply helpful? Yes No
TheFactorY 29 on at

Like (0)

Report

Hi Ferran

Thank you for your time!
I do have the same setup and it work. What does not work:

If in your sample text you add a dynamic content (example: @{outputs('inserttext')} the output of compose will show
@{outputs('inserttext')} in clear text
instead of the output of "inserttext"...

Does this make sense?

Was this reply helpful? Yes No
JOAS_Niels 180 on at

Like (0)

Report

Hi @TheFactorY,

Did you find a solution to this problem? I'm trying to do the same thing, with no succes.

Regards,

Niels

Was this reply helpful? Yes No
Suggested answer

BCBuizer 22,505 Super User 2025 Season 2 on at

Like (1)

Report

Hi All,

This is unfortunately not a thing: a text value can't be recognised/evaluated as a Power Automate formula.

However, what you can do to achieve similar functionality, is to use this "Super Switch" as described in a blog by David Wyatt: Power Automate - The Super Switch - DEV Community

In a nutshell, the article describes how you can parse a text to JSON to set the parameters for an HTTP action or child flows to perform the actions you want.

Perhaps not as easy to implement, but certainly there will be scenarios where this is the pattern to use.

If this reply helped you in any way, please give it a Like 💜 and in case it resolved your issue, please mark it as the Verified Answer ✅.

Was this reply helpful? Yes No
Suggested answer

JOAS_Niels 180 on at

Like (0)

Report
I found an easier solution to the problem.

I first use the action "Get file content using path" to get the content from an HTML file (this can also be a txt file). This is a example:

Dear Sir, Madam,  Your [Certificate] certification is about to expire in [Days] days.   Could you please send us a valid certificate?     With kind regards,

In this example I use two "placeholders", where I would like to have my dynamic content, namely:

[Certificate]

[Days]

You can name the placeholders whatever you want, unless they are unique in the text.

The next step is to just use a compose action with a replace function. In this case:

replace(body('Get_file_content_using_path_-_Email_body'),'[Certificate]', items('For_each_Column')['Certificate'])

You replace the placeholder text with the dynamic content you want (in my case "items('For_each_Column')['Certificate']".

For the second placeholder you use another compose step, but now you use the output of the previous compose as your input.

The last step is to use the output of your last compose action as input for your email body in your mail action (as HTML).

Hope this helps!

Was this reply helpful? Yes No