Solved: Re: PAD String.Format syntax

Zy_Sin · ‎04-11-2024

Hi

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

Nived_Nambiar · ‎04-11-2024

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! 🙌

View solution in original post

Deenuji · ‎04-11-2024

@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?

Zy_Sin · ‎04-11-2024

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

Hi All,

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

</body>
</html>

Deenuji · ‎04-11-2024

@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 🚀

Nived_Nambiar · ‎04-11-2024

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! 🙌

Agnius · ‎04-11-2024

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>

<p>Hi All,</p>

<p><b>Fail</b> to run . </p>
<p>The error description: &nbsp;<b>%Variable%</b></p>
<p> Thanks & Regards, </p>
<p> Robot </p>

</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.

-------------------------------------------------------------------------------------------------------------------------
If I have answered your question, please mark it as the preferred solution. If you like my response, please give it a Thumbs Up.
Regards, Agnius Bartninkas

Zy_Sin · ‎04-11-2024

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

Zy_Sin · ‎04-11-2024

Hi Deenuji,

Replace text works.

I am puzzle how Run.Net script syntax would be.

Thanks

Nived_Nambiar · ‎04-11-2024

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! 🙌