PAD String.Format syntax

(0) Share

Report

Posted on by Zy_Sin

I have this syntax String.format(config("Email_Body").Tostring, ErrorMsg) from uipath to be converted to PAD usable

ErrorMsg is a variable

my config("Email_Body") read from excel as a html body as follow

Hi All,

Fail to run . 
The error description:  {0}
 Thanks & Regards, 
 Robot

</body>
</html>

how can i change this syntax String.format(config("Email_Body").Tostring, ErrorMsg) so my email body that {0} can be dynamic?
thanks

Categories:

Power Automate Desktop

I have the same question (0)

All responses (10)

Answers (1)

Sort by

Deenuji_Loganathan_ 6,255 Moderator on at

Like (0)

Report
Copy link

Link copied!

@Zy_Sin
Please understand UIPath and power automate desktop both syntax are working in different ways. So please elaborate what you trying to achieve in your use case?

Is UIPath having any email template in excel the same you want to use in power automate desktop?
Please elaborate your issue?

Was this reply helpful? Yes No
Zy_Sin 79 on at

Like (0)

Report
Copy link

Link copied!

Hi Deenuji

i have this email template that has a part that need to be dynamic which hereby i indicate it as {0}
the {0} will be replace by a variable name "ErrorMsg"
How should the syntax be? in Power Automate Desktop Sent email body?
my email template is in html format
<html>
<body>
Hi All,
Fail to run . 
The error description:  {0}
 Thanks & Regards, 
 Robot 
</body>
</html>

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

Like (0)

Report
Copy link

Link copied!

@Zy_Sin
First create template like below using set variable option:

Then using replace text option you can replace {0} with actual error.

Finally assign html template variable into outlook send email body as highlighted 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
Nived_Nambiar 18,138 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi @Zy_Sin

Another method where you can use String.Format method simmilar to in UiPath (advanced approach ) ,

see below

first set a variable like this

Now use Run .Net script action like below

set script parameters like this

Now use below code

Now run the flow and see the output

Hope this helps 🙂

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
Agnius Bartninkas Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
If you just want to send it as an email, you don't need any conversions or anything. Just pass in a variable into the template like this (assuming you have your dynamic part in %Variable%):

<html> <body> Hi All, Fail to run . The error description:  %Variable% Thanks & Regards, Robot </body> </html>

You can either set this as a variable, or use it directly in your Send email action. Just make sure that when you use your Send email, you enable the toggle to use HTML body. Depending on the specific action, this may be disabled by default.

Was this reply helpful? Yes No
Zy_Sin 79 on at

Like (0)

Report
Copy link

Link copied!

Hi Nived_Nambiar,
I put this {0} as a variable inside the .NET code to run but it throw as Expression expected error. Instead of your 'NN', i put it as %Err_Msg% and it throw Expression expected.
Then i remove the %% and put it as outputstring=string.format(inputstring,Err_Msg) and it throw as 'Err_Msg' is not declared. It may be inaccessible due to its protection level.

I am trying to replace {0} which is inside my config file to the variable that i set in PAD line 7 an error message (this line 7 is an example, in actual flow line 7 will be a variable that is derive from Macro run)

Thanks

Was this reply helpful? Yes No
Zy_Sin 79 on at

Like (0)

Report
Copy link

Link copied!

Hi Deenuji,

Replace text works.
I am puzzle how Run.Net script syntax would be.

Thanks

Was this reply helpful? Yes No
Verified answer

Nived_Nambiar 18,138 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi @Zy_Sin

one thing to remember , if you need to pass any variable from Power Automate Desktop to Run .Net script action, you have to pass it via script parameters, for passing %Error_Msg% variable, you have to create script parameter whose direction is In and then pass the the variable into it (Just like arguments in UiPath)

see below for example 🙂

Hope now you got a clear idea on this !

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
Zy_Sin 79 on at

Like (0)

Report
Copy link

Link copied!

Thanks @Nived_Nambiar

Understood and it works.

Was this reply helpful? Yes No
Zy_Sin 79 on at

Like (0)

Report
Copy link

Link copied!

Hi @Nived_Nambiar

I have another issue for the above
Actually the string.format for {0} is an output from my macro script, written as function.
i am unable to output it as variable to PAD.
is there a way to pass data out from macro into PAD?
i have created a new topic under this heading
"how to get output from Macro to be input to Email in PAD flow"
but no one respond on that.
Thanks

Was this reply helpful? Yes No