Unanswered

Add variable to HTML content using Power FX

(1) Share

Report

Posted on by felyoubi

I've been struggling with sending an nicely formatted email using Power Automate Desktop with Power FX enable. I tried different syntaxes in the HTML content but none of them worked. Is it possible? if not, what is the proper way of doing the following:

- Get a list

- Loop through list
- Populate the HTML Content <<<< Need help with this

- Send Html content through Email

Categories:

Power Automate Desktop

I have the same question (0)

All responses (5)

Answers (0)

Sort by

Deenuji_Loganathan_ 6,255 Moderator on at

Like (1)

Report
Copy link

Link copied!

@felyoubi

I wouldn't recommend using power fx enabled flows for any production/live automation projects as its still in preview stage and lot of limitations as well.

PFB limitations as per Microsoft documentation:

Link - Power Fx in desktop flows (preview) - Power Automate | Microsoft Learn

In case if you still want to proceed with power fx, please share how your list output looks like and template of your email content and what values you want to include into your template from list?

If possible, share some screenshot of your desktop flow as well so that we will get some idea on this.

Thanks,
Deenuji Loganathan 👩‍💻
Automation Evangelist 🤖
Follow me on LinkedIn 👥

-------------------------------------------------------------------------------------------------------------
If I've helped solve your query, kindly mark my response as the solution ✔ and give it a thumbs up!👍 Your feedback supports future seekers 🚀

Was this reply helpful? Yes No
felyoubi 6 on at

Like (1)

Report
Copy link

Link copied!

Is there a way to disable it?

Was this reply helpful? Yes No
Deenuji_Loganathan_ 6,255 Moderator on at

Like (1)

Report
Copy link

Link copied!

@felyoubi

There is no on/off switch available in Power Automate Desktop, but you can create a new flow by disabling Power FX.

Please ensure that the Power FX toggle button is turned off while creating your desktop flow (as shown in the screenshot below).

Thanks,
Deenuji Loganathan 👩‍💻
Automation Evangelist 🤖
Follow me on LinkedIn 👥

-------------------------------------------------------------------------------------------------------------
If I've helped solve your query, kindly mark my response as the solution ✔ and give it a thumbs up!👍 Your feedback supports future seekers 🚀

Was this reply helpful? Yes No
felyoubi 6 on at

Like (1)

Report
Copy link

Link copied!

Here are some screenshot of my flow
and data
The html formatting would a standard table with 2 columns, nothing fancy. Once I get the gist of the syntax, I can play with it.

Thank you Deenuji

Was this reply helpful? Yes No
Deenuji_Loganathan_ 6,255 Moderator on at

Like (1)

Report
Copy link

Link copied!
@felyoubi

Please find the below approach.

I assuming you want to send an email for each row.

Code:
Excel.LaunchExcel.LaunchAndOpenUnderExistingProcess Path: $fx'C:\\Boot\\Felyoubi.xlsx' Visible: True ReadOnly: False Instance=> ExcelInstance Excel.ReadFromExcel.ReadAllCells Instance: $fx'=ExcelInstance' ReadAsText: False FirstLineIsHeader: True RangeValue=> ExcelData LOOP FOREACH CurrentItem IN $fx'=ExcelData' SET ID TO $fx'=ReadCell(CurrentItem, 1)' Display.ShowMessageDialog.ShowMessage Title: $fx'ID' Message: $fx'=ID' Icon: Display.Icon.None Buttons: Display.Buttons.OK DefaultButton: Display.DefaultButton.Button1 IsTopMost: False ButtonPressed=> ButtonPressed SET Number TO $fx'=ReadCell(CurrentItem, 2)' Display.ShowMessageDialog.ShowMessage Title: $fx'Number' Message: $fx'=Number' Icon: Display.Icon.None Buttons: Display.Buttons.OK DefaultButton: Display.DefaultButton.Button1 IsTopMost: False ButtonPressed=> ButtonPressed Text.CreateHTMLContent HtmlEditor: $fx'Hi User,ID: ${ID}Number: ${Number} Thanks,RPA Bot ' HtmlContent=> HtmlContent END

How to copy/paste the above code into your PAD?

Thanks,
Deenuji Loganathan 👩‍💻
Automation Evangelist 🤖
Follow me on LinkedIn 👥

-------------------------------------------------------------------------------------------------------------
If I've helped solve your query, kindly mark my response as the solution ✔ and give it a thumbs up!👍 Your feedback supports future seekers 🚀

Was this reply helpful? Yes No