cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Reply
Krisslee6
Helper I
Helper I

Extract % value from an email body contains HTML Table

‎08-08-2021 01:47 PM

Hi There,

I need some help to build an expression where I can extract "TABLESPACE" & "%USED" column from the below table.

Please find the attached screenshot of the original email alert which has the below table.

 

TABLESPACE

ACT_SIZE

FREE_MB

%FREE

USED_MB

%USED

LARGEST_EXTENT_MB

POOL_DATA

3297280

323426.25

9.80888035

2973853.75

90.1911197

3968

POOL_IX

860160

83961.125

9.76110549

776198.875

90.2388945

6911

 

Krisslee6_0-1628455129669.png

I want only the below columns to put a condition to move the email to a folder called "Alerts to Action" 

 

TABLESPACE %USED 
POOL_DATA90.1911197
POOL_IX90.2388945

Condition :  If the column %USED >90% then move the email to a folder called "Alerts to Action" 

 

My incomplete Flow

 

Krisslee6_1-1628455341459.png

It will be a great help and learning for me if some one can crack this usecase.

 

Regards,

RK

 

 

Labels:
Message 1 of 23
2,260 Views
0 Kudos
4 ACCEPTED SOLUTIONS

Accepted Solutions
Paulie78
Super User
Super User

‎08-09-2021 06:20 AM

You can do it like this:

2021-08-09_14-16-30.png

 

You will need to add a compose action called mailbody, which contains the dynamic content of the body of the email. Then you can add the rest of the steps. 

 

The expressions used:

Compose action named "Table": 

concat(
substring
(
  outputs('mailbody'), 
  indexOf(outputs('mailbody'), '<table class="MsoNormalTable"'), 
  sub(indexOf(outputs('mailbody'), '</table>'), indexOf(outputs('mailbody'), '<table class="MsoNormalTable"'))
),'</table>')

Compose action named "xpath":

xpath(xml(outputs('Table')), '//span/text()')

Select Action...
From: 
range(1,sub(div(length(outputs('xpath')), 7),1))

Map Column "TableSpace:
outputs('xpath')[mul(item(), 7)]]

Map Column "%USED":
outputs('xpath')[add(mul(item(), 7),5)]

Output produced from Select Action is:

[
  {
    "TableSpace": "POOL_DATA ",
    "%USED": "90.1911197 "
  },
  {
    "TableSpace": "POOL_IX ",
    "%USED": "90.2388945 "
  }
]

See how you get on. 

 

Blog: tachytelic.net

YouTube: https://www.youtube.com/c/PaulieM/videos

If I answered your question, please accept it as a solution 😘

View solution in original post

Message 4 of 23
1,985 Views
Krisslee6
Helper I
Helper I
In response to Paulie78

‎08-09-2021 01:16 PM

the below is the error for the email 

Email Body Screenshot

Krisslee6_1-1628540137890.png

 

Flow Error : 

Krisslee6_2-1628540182969.png

 

 

View solution in original post

Message 7 of 23
1,969 Views
0 Kudos
Paulie78
Super User
Super User
In response to Krisslee6

‎08-09-2021 02:43 PM

By the way, if you want to understand how this works, I did a video on this exact technique which you can watch here: 

How to convert a HTML table to JSON with Power Automate 

 

View solution in original post

Message 14 of 23
1,944 Views
0 Kudos
Paulie78
Super User
Super User
In response to Krisslee6

‎08-11-2021 05:56 AM

Here you go:

{"id":"165fd110-755d-4789-8670-ea9a-a94c9447","brandColor":"#8C3900","connectionReferences":{},"connectorDisplayName":"Control","icon":"data&colon;image/svg+xml;base64,PHN2ZyB3aWR0aD0iMzIiIGhlaWdodD0iMzIiIHZlcnNpb249IjEuMSIgdmlld0JveD0iMCAwIDMyIDMyIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPg0KIDxwYXRoIGQ9Im0wIDBoMzJ2MzJoLTMyeiIgZmlsbD0iIzhDMzkwMCIvPg0KIDxwYXRoIGQ9Im04IDEwaDE2djEyaC0xNnptMTUgMTF2LTEwaC0xNHYxMHptLTItOHY2aC0xMHYtNnptLTEgNXYtNGgtOHY0eiIgZmlsbD0iI2ZmZiIvPg0KPC9zdmc+DQo=","isTrigger":false,"operationName":"ExtractTable","operationDefinition":{"type":"Scope","actions":{"Select":{"type":"Select","inputs":{"from":"@range(1,sub(div(length(outputs('xpath')), 7),1))","select":{"TableSpace":"@outputs('xpath')[mul(item(), 7)]","%USED":"@outputs('xpath')[add(mul(item(), 7),5)]"}},"runAfter":{"xpath":["Succeeded"]}},"xpath":{"type":"Compose","inputs":"@xpath(xml(outputs('Table')), '//span/text()')","runAfter":{"Table":["Succeeded"]},"description":"xpath(xml(outputs('Table')), '//span/text()')"},"Table":{"type":"Compose","inputs":"@concat(\r\nsubstring\r\n(\r\n  outputs('mailbody'), \r\n  indexOf(outputs('mailbody'), '<table class=\"MsoNormalTable\"'), \r\n  sub(indexOf(outputs('mailbody'), '</table>'), indexOf(outputs('mailbody'), '<table class=\"MsoNormalTable\"'))\r\n),'</table>')","runAfter":{"mailbody":["Succeeded"]},"description":"concat( substring (   outputs('mailbody'),    indexOf(outputs('mailbody'), '<table class=\"MsoNormalTable\"'),    sub(indexOf(outputs('mailbody'), '</table>'), indexOf(outputs('mailbody'), '<table class=\"MsoNormalTable\"')) ),'</table>')"},"mailbody":{"type":"Compose","inputs":"<html><head>\n<meta http-equiv=\"Content-Type\" content=\"text/html; charset=utf-8\"><meta content=\"text/html; charset=us-ascii\"><meta name=\"Generator\" content=\"Microsoft Word 15 (filtered medium)\"><style>\n<!--\n@font-face\n{font-family:\"Cambria Math\"}\n@font-face\n{font-family:Calibri}\np.MsoNormal, li.MsoNormal, div.MsoNormal\n{margin:0cm;\nmargin-bottom:.0001pt;\nfont-size:11.0pt;\nfont-family:\"Calibri\",sans-serif}\np.msipfooter9ab28e29, li.msipfooter9ab28e29, div.msipfooter9ab28e29\n{margin-right:0cm;\nmargin-left:0cm;\nfont-size:11.0pt;\nfont-family:\"Calibri\",sans-serif}\nspan.EmailStyle19\n{}\n.MsoChpDefault\n{font-size:10.0pt}\n@page WordSection1\n{margin:72.0pt 72.0pt 72.0pt 72.0pt}\ndiv.WordSection1\n{}\n-->\n</style></head><body lang=\"EN-IN\" link=\"#0563C1\" vlink=\"#954F72\"><div class=\"WordSection1\"><p class=\"MsoNormal\">&nbsp;</p><div><p class=\"MsoNormal\"><span style=\"font-size:12.0pt; color:black\">&nbsp;</span></p></div><div><div id=\"divRplyFwdMsg\"><div><p class=\"MsoNormal\" style=\"background:white\"><span style=\"font-size:10.0pt; font-family:&quot;Arial&quot;,sans-serif; color:black\">&nbsp;</span></p></div></div><div><div align=\"center\"><table class=\"MsoNormalTable\" border=\"1\" cellpadding=\"0\" summary=\"Script output\" width=\"90%\" style=\"width:90.0%; background:#F7F7E7\"><tbody><tr><td style=\"background:#CCCC99; padding:0cm 0cm 0cm 0cm\"><p class=\"MsoNormal\" align=\"center\" style=\"text-align:center\"><b><span style=\"font-size:10.0pt; font-family:&quot;Arial&quot;,sans-serif; color:#336699\">TABLESPACE </span></b></p></td><td style=\"background:#CCCC99; padding:0cm 0cm 0cm 0cm\"><p class=\"MsoNormal\" align=\"center\" style=\"text-align:center\"><b><span style=\"font-size:10.0pt; font-family:&quot;Arial&quot;,sans-serif; color:#336699\">ACT_SIZE </span></b></p></td><td style=\"background:#CCCC99; padding:0cm 0cm 0cm 0cm\"><p class=\"MsoNormal\" align=\"center\" style=\"text-align:center\"><b><span style=\"font-size:10.0pt; font-family:&quot;Arial&quot;,sans-serif; color:#336699\">FREE_MB </span></b></p></td><td style=\"background:#CCCC99; padding:0cm 0cm 0cm 0cm\"><p class=\"MsoNormal\" align=\"center\" style=\"text-align:center\"><b><span style=\"font-size:10.0pt; font-family:&quot;Arial&quot;,sans-serif; color:#336699\">%FREE </span></b></p></td><td style=\"background:#CCCC99; padding:0cm 0cm 0cm 0cm\"><p class=\"MsoNormal\" align=\"center\" style=\"text-align:center\"><b><span style=\"font-size:10.0pt; font-family:&quot;Arial&quot;,sans-serif; color:#336699\">USED_MB </span></b></p></td><td style=\"background:#CCCC99; padding:0cm 0cm 0cm 0cm\"><p class=\"MsoNormal\" align=\"center\" style=\"text-align:center\"><b><span style=\"font-size:10.0pt; font-family:&quot;Arial&quot;,sans-serif; color:#336699\">%USED </span></b></p></td><td style=\"background:#CCCC99; padding:0cm 0cm 0cm 0cm\"><p class=\"MsoNormal\" align=\"center\" style=\"text-align:center\"><b><span style=\"font-size:10.0pt; font-family:&quot;Arial&quot;,sans-serif; color:#336699\">LARGEST_EXTENT_MB </span></b></p></td></tr><tr><td style=\"padding:0cm 0cm 0cm 0cm\"><p class=\"MsoNormal\"><span style=\"font-size:10.0pt; font-family:&quot;Arial&quot;,sans-serif; color:black\">POOL_IX </span></p></td><td style=\"padding:0cm 0cm 0cm 0cm\"><p class=\"MsoNormal\" align=\"right\" style=\"text-align:right\"><span style=\"font-size:10.0pt; font-family:&quot;Arial&quot;,sans-serif; color:black\">870400 </span></p></td><td style=\"padding:0cm 0cm 0cm 0cm\"><p class=\"MsoNormal\" align=\"right\" style=\"text-align:right\"><span style=\"font-size:10.0pt; font-family:&quot;Arial&quot;,sans-serif; color:black\">85458.5 </span></p></td><td style=\"padding:0cm 0cm 0cm 0cm\"><p class=\"MsoNormal\" align=\"right\" style=\"text-align:right\"><span style=\"font-size:10.0pt; font-family:&quot;Arial&quot;,sans-serif; color:black\">9.81830193 </span></p></td><td style=\"padding:0cm 0cm 0cm 0cm\"><p class=\"MsoNormal\" align=\"right\" style=\"text-align:right\"><span style=\"font-size:10.0pt; font-family:&quot;Arial&quot;,sans-serif; color:black\">784941.5 </span></p></td><td style=\"padding:0cm 0cm 0cm 0cm\"><p class=\"MsoNormal\" align=\"right\" style=\"text-align:right\"><span style=\"font-size:10.0pt; font-family:&quot;Arial&quot;,sans-serif; color:black\">90.1816981 </span></p></td><td style=\"padding:0cm 0cm 0cm 0cm\"><p class=\"MsoNormal\" align=\"right\" style=\"text-align:right\"><span style=\"font-size:10.0pt; font-family:&quot;Arial&quot;,sans-serif; color:black\">6911 </span></p></td></tr></tbody></table></div><p class=\"MsoNormal\">&nbsp;</p><p class=\"MsoNormal\">&nbsp;</p><p class=\"msipfooter9ab28e29\" style=\"margin:0cm; margin-bottom:.0001pt\"><span style=\"font-size:7.0pt; color:black\">C2 General</span></p></div></div></div></body></html>","runAfter":{}},"Filter_array":{"type":"Query","inputs":{"from":"@body('Select')","where":"@greaterOrEquals(float(item()['%USED']), 90)"},"runAfter":{"Select":["Succeeded"]}}},"runAfter":{}}}

 

Just out of interest, what sort of database are you monitoring?

View solution in original post

Message 19 of 23
1,883 Views
0 Kudos
22 REPLIES 22
Paulie78
Super User
Super User

‎08-08-2021 02:44 PM

It would be really useful to see the source html - then i could write something for you.

Message 2 of 23
1,980 Views
0 Kudos
Krisslee6
Helper I
Helper I
In response to Paulie78

‎08-09-2021 12:28 AM

Hi Paulie,

 

Thank you for your response.

Much appreciated.

 

Below is he sample email screenshot and the HTML view :

Krisslee6_0-1628493415209.png

__________________________________________________________________________________________________________________

<p><html><head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8"><meta content="text/html; charset=us-ascii"><meta name="Generator" content="Microsoft Word 15 (filtered medium)"><style>
<!--
@font-face
{font-family:"Cambria Math"}
@font-face
{font-family:Calibri}
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri",sans-serif}
p.msipfooter9ab28e29, li.msipfooter9ab28e29, div.msipfooter9ab28e29
{margin-right:0cm;
margin-left:0cm;
font-size:11.0pt;
font-family:"Calibri",sans-serif}
span.EmailStyle20
{}
.MsoChpDefault
{font-size:10.0pt}
@page WordSection1
{margin:72.0pt 72.0pt 72.0pt 72.0pt}
div.WordSection1
{}
-->
</style></head><body lang="EN-IN" link="#0563C1" vlink="#954F72"><div class="WordSection1"><p class="MsoNormal">&nbsp;</p><p class="MsoNormal" style="background:white"><span style="font-size:10.0pt; font-family:&quot;Arial&quot;,sans-serif; color:black">&nbsp;</span></p><div><div align="center"><table class="MsoNormalTable" border="1" cellpadding="0" summary="Script output" width="90%" style="width:90.0%; background:#F7F7E7"><tbody><tr><td style="background:#CCCC99; padding:0cm 0cm 0cm 0cm"><p class="MsoNormal" align="center" style="text-align:center"><b><span style="font-size:10.0pt; font-family:&quot;Arial&quot;,sans-serif; color:#336699">TABLESPACE </span></b></p></td><td style="background:#CCCC99; padding:0cm 0cm 0cm 0cm"><p class="MsoNormal" align="center" style="text-align:center"><b><span style="font-size:10.0pt; font-family:&quot;Arial&quot;,sans-serif; color:#336699">ACT_SIZE </span></b></p></td><td style="background:#CCCC99; padding:0cm 0cm 0cm 0cm"><p class="MsoNormal" align="center" style="text-align:center"><b><span style="font-size:10.0pt; font-family:&quot;Arial&quot;,sans-serif; color:#336699">FREE_MB </span></b></p></td><td style="background:#CCCC99; padding:0cm 0cm 0cm 0cm"><p class="MsoNormal" align="center" style="text-align:center"><b><span style="font-size:10.0pt; font-family:&quot;Arial&quot;,sans-serif; color:#336699">%FREE </span></b></p></td><td style="background:#CCCC99; padding:0cm 0cm 0cm 0cm"><p class="MsoNormal" align="center" style="text-align:center"><b><span style="font-size:10.0pt; font-family:&quot;Arial&quot;,sans-serif; color:#336699">USED_MB </span></b></p></td><td style="background:#CCCC99; padding:0cm 0cm 0cm 0cm"><p class="MsoNormal" align="center" style="text-align:center"><b><span style="font-size:10.0pt; font-family:&quot;Arial&quot;,sans-serif; color:#336699">%USED </span></b></p></td><td style="background:#CCCC99; padding:0cm 0cm 0cm 0cm"><p class="MsoNormal" align="center" style="text-align:center"><b><span style="font-size:10.0pt; font-family:&quot;Arial&quot;,sans-serif; color:#336699">LARGEST_EXTENT_MB </span></b></p></td></tr><tr><td style="padding:0cm 0cm 0cm 0cm"><p class="MsoNormal"><span style="font-size:10.0pt; font-family:&quot;Arial&quot;,sans-serif; color:black">POOL_DATA </span></p></td><td style="padding:0cm 0cm 0cm 0cm"><p class="MsoNormal" align="right" style="text-align:right"><span style="font-size:10.0pt; font-family:&quot;Arial&quot;,sans-serif; color:black">3297280 </span></p></td><td style="padding:0cm 0cm 0cm 0cm"><p class="MsoNormal" align="right" style="text-align:right"><span style="font-size:10.0pt; font-family:&quot;Arial&quot;,sans-serif; color:black">323426.25 </span></p></td><td style="padding:0cm 0cm 0cm 0cm"><p class="MsoNormal" align="right" style="text-align:right"><span style="font-size:10.0pt; font-family:&quot;Arial&quot;,sans-serif; color:black">9.80888035 </span></p></td><td style="padding:0cm 0cm 0cm 0cm"><p class="MsoNormal" align="right" style="text-align:right"><span style="font-size:10.0pt; font-family:&quot;Arial&quot;,sans-serif; color:black">2973853.75 </span></p></td><td style="padding:0cm 0cm 0cm 0cm"><p class="MsoNormal" align="right" style="text-align:right"><span style="font-size:10.0pt; font-family:&quot;Arial&quot;,sans-serif; color:black">90.1911197 </span></p></td><td style="padding:0cm 0cm 0cm 0cm"><p class="MsoNormal" align="right" style="text-align:right"><span style="font-size:10.0pt; font-family:&quot;Arial&quot;,sans-serif; color:black">3968 </span></p></td></tr><tr><td style="padding:0cm 0cm 0cm 0cm"><p class="MsoNormal"><span style="font-size:10.0pt; font-family:&quot;Arial&quot;,sans-serif; color:black">POOL_IX </span></p></td><td style="padding:0cm 0cm 0cm 0cm"><p class="MsoNormal" align="right" style="text-align:right"><span style="font-size:10.0pt; font-family:&quot;Arial&quot;,sans-serif; color:black">860160 </span></p></td><td style="padding:0cm 0cm 0cm 0cm"><p class="MsoNormal" align="right" style="text-align:right"><span style="font-size:10.0pt; font-family:&quot;Arial&quot;,sans-serif; color:black">83961.125 </span></p></td><td style="padding:0cm 0cm 0cm 0cm"><p class="MsoNormal" align="right" style="text-align:right"><span style="font-size:10.0pt; font-family:&quot;Arial&quot;,sans-serif; color:black">9.76110549 </span></p></td><td style="padding:0cm 0cm 0cm 0cm"><p class="MsoNormal" align="right" style="text-align:right"><span style="font-size:10.0pt; font-family:&quot;Arial&quot;,sans-serif; color:black">776198.875 </span></p></td><td style="padding:0cm 0cm 0cm 0cm"><p class="MsoNormal" align="right" style="text-align:right"><span style="font-size:10.0pt; font-family:&quot;Arial&quot;,sans-serif; color:black">90.2388945 </span></p></td><td style="padding:0cm 0cm 0cm 0cm"><p class="MsoNormal" align="right" style="text-align:right"><span style="font-size:10.0pt; font-family:&quot;Arial&quot;,sans-serif; color:black">6911 </span></p></td></tr></tbody></table></div></div><p class="MsoNormal">&nbsp;</p><p style="margin:15.0pt"><span style="font-size:7.0pt; color:black">C2 General</span></p><p class="MsoNormal">&nbsp;</p><p class="msipfooter9ab28e29" style="margin:0cm; margin-bottom:.0001pt"><span style="font-size:7.0pt; color:black">C2 General</span></p></div></body></html></p>

 

______________________________________________________________________________________________________________________

 

 

 

Message 3 of 23
1,982 Views
0 Kudos
Paulie78
Super User
Super User

‎08-09-2021 06:20 AM

You can do it like this:

2021-08-09_14-16-30.png

 

You will need to add a compose action called mailbody, which contains the dynamic content of the body of the email. Then you can add the rest of the steps. 

 

The expressions used:

Compose action named "Table": 

concat(
substring
(
  outputs('mailbody'), 
  indexOf(outputs('mailbody'), '<table class="MsoNormalTable"'), 
  sub(indexOf(outputs('mailbody'), '</table>'), indexOf(outputs('mailbody'), '<table class="MsoNormalTable"'))
),'</table>')

Compose action named "xpath":

xpath(xml(outputs('Table')), '//span/text()')

Select Action...
From: 
range(1,sub(div(length(outputs('xpath')), 7),1))

Map Column "TableSpace:
outputs('xpath')[mul(item(), 7)]]

Map Column "%USED":
outputs('xpath')[add(mul(item(), 7),5)]

Output produced from Select Action is:

[
  {
    "TableSpace": "POOL_DATA ",
    "%USED": "90.1911197 "
  },
  {
    "TableSpace": "POOL_IX ",
    "%USED": "90.2388945 "
  }
]

See how you get on. 

 

Blog: tachytelic.net

YouTube: https://www.youtube.com/c/PaulieM/videos

If I answered your question, please accept it as a solution 😘

Message 4 of 23
1,986 Views
Krisslee6
Helper I
Helper I
In response to Paulie78

‎08-09-2021 12:34 PM

Hi Paulie,

 

Thank you so much for the flow its working but only for the email which I posted to get the solution.

 

The email which I posted is just a sample, Text in the columns "Table Space" & "%USED" are dynamic and may vary for each email.

 

My need is to get such a flow designed where "Tablespace" text &  "%USED" column values are returned.

If this is not possible I would atleast require a flow which can return only the values of "%USED" column.

 

Regards,

RK

Message 5 of 23
1,981 Views
0 Kudos
Paulie78
Super User
Super User

‎08-09-2021 01:07 PM

It should work dynamically. What part is not working when you use it on a different email. 

Message 6 of 23
1,971 Views
0 Kudos
Krisslee6
Helper I
Helper I
In response to Paulie78

‎08-09-2021 01:16 PM

the below is the error for the email 

Email Body Screenshot

Krisslee6_1-1628540137890.png

 

Flow Error : 

Krisslee6_2-1628540182969.png

 

 

Message 7 of 23
1,970 Views
0 Kudos
Paulie78
Super User
Super User
In response to Krisslee6

‎08-09-2021 01:20 PM

The HTML source must be quite different to the example you provided.

Message 8 of 23
1,968 Views
0 Kudos
Krisslee6
Helper I
Helper I
In response to Paulie78

‎08-09-2021 01:27 PM

Is it...

In that case, can you help me with only one column which is "%USED" these are the important values .

If these values are greater than 90% then I have to take actions.

 

 

Message 9 of 23
1,967 Views
0 Kudos
Paulie78
Super User
Super User

‎08-09-2021 01:44 PM

It’s better if you post the html body for the example that didn’t work and I will see why it failed in the second example and see if I can adjust.

Message 10 of 23
1,956 Views
0 Kudos
Krisslee6
Helper I
Helper I
In response to Paulie78

‎08-09-2021 02:12 PM

Hi Paulie,

 


TABLESPACE ACT_SIZE FREE_MB %FREE USED_MB %USED LARGEST_EXTENT_MB
POOL_IX 870400 85458.5 9.81830193 784941.5 90.1816981 6911

 

 


HTML Body :

<html><head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8"><meta content="text/html; charset=us-ascii"><meta name="Generator" content="Microsoft Word 15 (filtered medium)"><style>
<!--
@font-face
{font-family:"Cambria Math"}
@font-face
{font-family:Calibri}
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri",sans-serif}
p.msipfooter9ab28e29, li.msipfooter9ab28e29, div.msipfooter9ab28e29
{margin-right:0cm;
margin-left:0cm;
font-size:11.0pt;
font-family:"Calibri",sans-serif}
span.EmailStyle19
{}
.MsoChpDefault
{font-size:10.0pt}
@page WordSection1
{margin:72.0pt 72.0pt 72.0pt 72.0pt}
div.WordSection1
{}
-->
</style></head><body lang="EN-IN" link="#0563C1" vlink="#954F72"><div class="WordSection1"><p class="MsoNormal">&nbsp;</p><div><p class="MsoNormal"><span style="font-size:12.0pt; color:black">&nbsp;</span></p></div><div><div id="divRplyFwdMsg"><div><p class="MsoNormal" style="background:white"><span style="font-size:10.0pt; font-family:&quot;Arial&quot;,sans-serif; color:black">&nbsp;</span></p></div></div><div><div align="center"><table class="MsoNormalTable" border="1" cellpadding="0" summary="Script output" width="90%" style="width:90.0%; background:#F7F7E7"><tbody><tr><td style="background:#CCCC99; padding:0cm 0cm 0cm 0cm"><p class="MsoNormal" align="center" style="text-align:center"><b><span style="font-size:10.0pt; font-family:&quot;Arial&quot;,sans-serif; color:#336699">TABLESPACE </span></b></p></td><td style="background:#CCCC99; padding:0cm 0cm 0cm 0cm"><p class="MsoNormal" align="center" style="text-align:center"><b><span style="font-size:10.0pt; font-family:&quot;Arial&quot;,sans-serif; color:#336699">ACT_SIZE </span></b></p></td><td style="background:#CCCC99; padding:0cm 0cm 0cm 0cm"><p class="MsoNormal" align="center" style="text-align:center"><b><span style="font-size:10.0pt; font-family:&quot;Arial&quot;,sans-serif; color:#336699">FREE_MB </span></b></p></td><td style="background:#CCCC99; padding:0cm 0cm 0cm 0cm"><p class="MsoNormal" align="center" style="text-align:center"><b><span style="font-size:10.0pt; font-family:&quot;Arial&quot;,sans-serif; color:#336699">%FREE </span></b></p></td><td style="background:#CCCC99; padding:0cm 0cm 0cm 0cm"><p class="MsoNormal" align="center" style="text-align:center"><b><span style="font-size:10.0pt; font-family:&quot;Arial&quot;,sans-serif; color:#336699">USED_MB </span></b></p></td><td style="background:#CCCC99; padding:0cm 0cm 0cm 0cm"><p class="MsoNormal" align="center" style="text-align:center"><b><span style="font-size:10.0pt; font-family:&quot;Arial&quot;,sans-serif; color:#336699">%USED </span></b></p></td><td style="background:#CCCC99; padding:0cm 0cm 0cm 0cm"><p class="MsoNormal" align="center" style="text-align:center"><b><span style="font-size:10.0pt; font-family:&quot;Arial&quot;,sans-serif; color:#336699">LARGEST_EXTENT_MB </span></b></p></td></tr><tr><td style="padding:0cm 0cm 0cm 0cm"><p class="MsoNormal"><span style="font-size:10.0pt; font-family:&quot;Arial&quot;,sans-serif; color:black">POOL_IX </span></p></td><td style="padding:0cm 0cm 0cm 0cm"><p class="MsoNormal" align="right" style="text-align:right"><span style="font-size:10.0pt; font-family:&quot;Arial&quot;,sans-serif; color:black">870400 </span></p></td><td style="padding:0cm 0cm 0cm 0cm"><p class="MsoNormal" align="right" style="text-align:right"><span style="font-size:10.0pt; font-family:&quot;Arial&quot;,sans-serif; color:black">85458.5 </span></p></td><td style="padding:0cm 0cm 0cm 0cm"><p class="MsoNormal" align="right" style="text-align:right"><span style="font-size:10.0pt; font-family:&quot;Arial&quot;,sans-serif; color:black">9.81830193 </span></p></td><td style="padding:0cm 0cm 0cm 0cm"><p class="MsoNormal" align="right" style="text-align:right"><span style="font-size:10.0pt; font-family:&quot;Arial&quot;,sans-serif; color:black">784941.5 </span></p></td><td style="padding:0cm 0cm 0cm 0cm"><p class="MsoNormal" align="right" style="text-align:right"><span style="font-size:10.0pt; font-family:&quot;Arial&quot;,sans-serif; color:black">90.1816981 </span></p></td><td style="padding:0cm 0cm 0cm 0cm"><p class="MsoNormal" align="right" style="text-align:right"><span style="font-size:10.0pt; font-family:&quot;Arial&quot;,sans-serif; color:black">6911 </span></p></td></tr></tbody></table></div><p class="MsoNormal">&nbsp;</p><p class="MsoNormal">&nbsp;</p><p class="msipfooter9ab28e29" style="margin:0cm; margin-bottom:.0001pt"><span style="font-size:7.0pt; color:black">C2 General</span></p></div></div></div></body></html>

 

Message 11 of 23
1,954 Views
0 Kudos
Paulie78
Super User
Super User

‎08-09-2021 02:34 PM

If I run the flow I created, with the HTML source you provided, it works perfectly. This is the result:

[
  {
    "TableSpace": "POOL_IX ",
    "%USED": "90.1816981 "
  }
]

So you must have made a slight error when recreating the flow. I have copied my flow into a scope, so you can copy and paste it. Simply copy the code below, go into your flow editor, add a new step and go to My Clipboard then press CTRL-V. The scope will then appear and you can paste it into your flow. You just then need to modify the mailbody compose action to have the email body of your incoming email. See how you get on.

Message 12 of 23
1,952 Views
0 Kudos
Krisslee6
Helper I
Helper I
In response to Paulie78

‎08-09-2021 02:40 PM

Thank you So much Paulie.

 

I will do that and let you know the result.

 

Thank you once again its a great help and guidance

 

You are a Star 🙂 

Message 13 of 23
1,950 Views
0 Kudos
Paulie78
Super User
Super User
In response to Krisslee6

‎08-09-2021 02:43 PM

By the way, if you want to understand how this works, I did a video on this exact technique which you can watch here: 

How to convert a HTML table to JSON with Power Automate 

 

Message 14 of 23
1,945 Views
0 Kudos
Krisslee6
Helper I
Helper I

‎08-10-2021 05:45 AM

Hi Paulie,

 

Thank you so much once again.

The flow is working perfectly 🙂

 

Do let me know if I can get some classes from you 

 

Regards,

RK

 

Message 15 of 23
1,920 Views
0 Kudos
Krisslee6
Helper I
Helper I
In response to Krisslee6

‎08-10-2021 10:43 AM

Hi Paulie,

 

The final step to get my flow to work as per the purpose is to add a condition. May I please request you to help me out as this is the only step required to complete my flow in order to  automate the email alerts.

  {
    "TableSpace": "POOL_IX ",
    "%USED": "90.1816981 "
  }
]

From the above output, condition is if the "%USED"  values are greater or equal to 90 then the action is to move the email to a specific folder.

 

Regards,

RK

Message 16 of 23
1,912 Views
0 Kudos
Krisslee6
Helper I
Helper I
In response to Paulie78

‎08-11-2021 05:51 AM

Hi Paulie,

 

The final step to get my flow to work as per the purpose is to add a condition. May I please request you to help me out as this is the only step required to complete my flow in order to  automate the email alerts.

  {
    "TableSpace": "POOL_IX ",
    "%USED": "90.1816981 "
  }
]

From the above output, condition is if the "%USED"  values are greater or equal to 90 then the action is to move the email to a specific folder.

 

Regards,

RK

Message 17 of 23
1,884 Views
0 Kudos
Paulie78
Super User
Super User
In response to Krisslee6

‎08-11-2021 05:52 AM

Sure, will have a quick look now

Message 18 of 23
1,883 Views
0 Kudos
Paulie78
Super User
Super User
In response to Krisslee6

‎08-11-2021 05:56 AM

Here you go:

{"id":"165fd110-755d-4789-8670-ea9a-a94c9447","brandColor":"#8C3900","connectionReferences":{},"connectorDisplayName":"Control","icon":"data&colon;image/svg+xml;base64,PHN2ZyB3aWR0aD0iMzIiIGhlaWdodD0iMzIiIHZlcnNpb249IjEuMSIgdmlld0JveD0iMCAwIDMyIDMyIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPg0KIDxwYXRoIGQ9Im0wIDBoMzJ2MzJoLTMyeiIgZmlsbD0iIzhDMzkwMCIvPg0KIDxwYXRoIGQ9Im04IDEwaDE2djEyaC0xNnptMTUgMTF2LTEwaC0xNHYxMHptLTItOHY2aC0xMHYtNnptLTEgNXYtNGgtOHY0eiIgZmlsbD0iI2ZmZiIvPg0KPC9zdmc+DQo=","isTrigger":false,"operationName":"ExtractTable","operationDefinition":{"type":"Scope","actions":{"Select":{"type":"Select","inputs":{"from":"@range(1,sub(div(length(outputs('xpath')), 7),1))","select":{"TableSpace":"@outputs('xpath')[mul(item(), 7)]","%USED":"@outputs('xpath')[add(mul(item(), 7),5)]"}},"runAfter":{"xpath":["Succeeded"]}},"xpath":{"type":"Compose","inputs":"@xpath(xml(outputs('Table')), '//span/text()')","runAfter":{"Table":["Succeeded"]},"description":"xpath(xml(outputs('Table')), '//span/text()')"},"Table":{"type":"Compose","inputs":"@concat(\r\nsubstring\r\n(\r\n  outputs('mailbody'), \r\n  indexOf(outputs('mailbody'), '<table class=\"MsoNormalTable\"'), \r\n  sub(indexOf(outputs('mailbody'), '</table>'), indexOf(outputs('mailbody'), '<table class=\"MsoNormalTable\"'))\r\n),'</table>')","runAfter":{"mailbody":["Succeeded"]},"description":"concat( substring (   outputs('mailbody'),    indexOf(outputs('mailbody'), '<table class=\"MsoNormalTable\"'),    sub(indexOf(outputs('mailbody'), '</table>'), indexOf(outputs('mailbody'), '<table class=\"MsoNormalTable\"')) ),'</table>')"},"mailbody":{"type":"Compose","inputs":"<html><head>\n<meta http-equiv=\"Content-Type\" content=\"text/html; charset=utf-8\"><meta content=\"text/html; charset=us-ascii\"><meta name=\"Generator\" content=\"Microsoft Word 15 (filtered medium)\"><style>\n<!--\n@font-face\n{font-family:\"Cambria Math\"}\n@font-face\n{font-family:Calibri}\np.MsoNormal, li.MsoNormal, div.MsoNormal\n{margin:0cm;\nmargin-bottom:.0001pt;\nfont-size:11.0pt;\nfont-family:\"Calibri\",sans-serif}\np.msipfooter9ab28e29, li.msipfooter9ab28e29, div.msipfooter9ab28e29\n{margin-right:0cm;\nmargin-left:0cm;\nfont-size:11.0pt;\nfont-family:\"Calibri\",sans-serif}\nspan.EmailStyle19\n{}\n.MsoChpDefault\n{font-size:10.0pt}\n@page WordSection1\n{margin:72.0pt 72.0pt 72.0pt 72.0pt}\ndiv.WordSection1\n{}\n-->\n</style></head><body lang=\"EN-IN\" link=\"#0563C1\" vlink=\"#954F72\"><div class=\"WordSection1\"><p class=\"MsoNormal\">&nbsp;</p><div><p class=\"MsoNormal\"><span style=\"font-size:12.0pt; color:black\">&nbsp;</span></p></div><div><div id=\"divRplyFwdMsg\"><div><p class=\"MsoNormal\" style=\"background:white\"><span style=\"font-size:10.0pt; font-family:&quot;Arial&quot;,sans-serif; color:black\">&nbsp;</span></p></div></div><div><div align=\"center\"><table class=\"MsoNormalTable\" border=\"1\" cellpadding=\"0\" summary=\"Script output\" width=\"90%\" style=\"width:90.0%; background:#F7F7E7\"><tbody><tr><td style=\"background:#CCCC99; padding:0cm 0cm 0cm 0cm\"><p class=\"MsoNormal\" align=\"center\" style=\"text-align:center\"><b><span style=\"font-size:10.0pt; font-family:&quot;Arial&quot;,sans-serif; color:#336699\">TABLESPACE </span></b></p></td><td style=\"background:#CCCC99; padding:0cm 0cm 0cm 0cm\"><p class=\"MsoNormal\" align=\"center\" style=\"text-align:center\"><b><span style=\"font-size:10.0pt; font-family:&quot;Arial&quot;,sans-serif; color:#336699\">ACT_SIZE </span></b></p></td><td style=\"background:#CCCC99; padding:0cm 0cm 0cm 0cm\"><p class=\"MsoNormal\" align=\"center\" style=\"text-align:center\"><b><span style=\"font-size:10.0pt; font-family:&quot;Arial&quot;,sans-serif; color:#336699\">FREE_MB </span></b></p></td><td style=\"background:#CCCC99; padding:0cm 0cm 0cm 0cm\"><p class=\"MsoNormal\" align=\"center\" style=\"text-align:center\"><b><span style=\"font-size:10.0pt; font-family:&quot;Arial&quot;,sans-serif; color:#336699\">%FREE </span></b></p></td><td style=\"background:#CCCC99; padding:0cm 0cm 0cm 0cm\"><p class=\"MsoNormal\" align=\"center\" style=\"text-align:center\"><b><span style=\"font-size:10.0pt; font-family:&quot;Arial&quot;,sans-serif; color:#336699\">USED_MB </span></b></p></td><td style=\"background:#CCCC99; padding:0cm 0cm 0cm 0cm\"><p class=\"MsoNormal\" align=\"center\" style=\"text-align:center\"><b><span style=\"font-size:10.0pt; font-family:&quot;Arial&quot;,sans-serif; color:#336699\">%USED </span></b></p></td><td style=\"background:#CCCC99; padding:0cm 0cm 0cm 0cm\"><p class=\"MsoNormal\" align=\"center\" style=\"text-align:center\"><b><span style=\"font-size:10.0pt; font-family:&quot;Arial&quot;,sans-serif; color:#336699\">LARGEST_EXTENT_MB </span></b></p></td></tr><tr><td style=\"padding:0cm 0cm 0cm 0cm\"><p class=\"MsoNormal\"><span style=\"font-size:10.0pt; font-family:&quot;Arial&quot;,sans-serif; color:black\">POOL_IX </span></p></td><td style=\"padding:0cm 0cm 0cm 0cm\"><p class=\"MsoNormal\" align=\"right\" style=\"text-align:right\"><span style=\"font-size:10.0pt; font-family:&quot;Arial&quot;,sans-serif; color:black\">870400 </span></p></td><td style=\"padding:0cm 0cm 0cm 0cm\"><p class=\"MsoNormal\" align=\"right\" style=\"text-align:right\"><span style=\"font-size:10.0pt; font-family:&quot;Arial&quot;,sans-serif; color:black\">85458.5 </span></p></td><td style=\"padding:0cm 0cm 0cm 0cm\"><p class=\"MsoNormal\" align=\"right\" style=\"text-align:right\"><span style=\"font-size:10.0pt; font-family:&quot;Arial&quot;,sans-serif; color:black\">9.81830193 </span></p></td><td style=\"padding:0cm 0cm 0cm 0cm\"><p class=\"MsoNormal\" align=\"right\" style=\"text-align:right\"><span style=\"font-size:10.0pt; font-family:&quot;Arial&quot;,sans-serif; color:black\">784941.5 </span></p></td><td style=\"padding:0cm 0cm 0cm 0cm\"><p class=\"MsoNormal\" align=\"right\" style=\"text-align:right\"><span style=\"font-size:10.0pt; font-family:&quot;Arial&quot;,sans-serif; color:black\">90.1816981 </span></p></td><td style=\"padding:0cm 0cm 0cm 0cm\"><p class=\"MsoNormal\" align=\"right\" style=\"text-align:right\"><span style=\"font-size:10.0pt; font-family:&quot;Arial&quot;,sans-serif; color:black\">6911 </span></p></td></tr></tbody></table></div><p class=\"MsoNormal\">&nbsp;</p><p class=\"MsoNormal\">&nbsp;</p><p class=\"msipfooter9ab28e29\" style=\"margin:0cm; margin-bottom:.0001pt\"><span style=\"font-size:7.0pt; color:black\">C2 General</span></p></div></div></div></body></html>","runAfter":{}},"Filter_array":{"type":"Query","inputs":{"from":"@body('Select')","where":"@greaterOrEquals(float(item()['%USED']), 90)"},"runAfter":{"Select":["Succeeded"]}}},"runAfter":{}}}

 

Just out of interest, what sort of database are you monitoring?

Message 19 of 23
1,884 Views
0 Kudos
Krisslee6
Helper I
Helper I
In response to Paulie78

‎08-11-2021 09:42 AM

Hi Paulie,

 

We have multiple database on which retul billing and Telcom related data is stored.

 

We are the serive managment  center for Ireland retail Telcom sector.

 

I'm leading the monitoring L1 team from India where my team manually take actions on the email alerts and I'm trying to use power automate to reduce the mannual efforts on all the alerts by moving the email alerts to the folders called "Alerts to Action" and "Alerts to ignore" .

 

Current situation we have 10 ppl monitoring and taking actions on these 14,000-23,000 email alerts and most of the alerts they have to just check for threshold values and ignore the alerts. Very few alerts are being actioned.

 

If I automate diffrents types of email alerts I can show a efficiency and can have only 2 ppl to monitor these alerts.

 

And rest of my ppl I can use them for new projects and save some money for my company.

 

Regards,

RK

 

Message 20 of 23
1,868 Views
0 Kudos

Helpful resources

Announcements
April 2024 Community Newsletter

April 2024 Community Newsletter

We're pleased to share the April Community Newsletter, where we highlight the latest news, product releases, upcoming events, and the amazing work of our outstanding Community members.   If you're new to the Community, please make sure to follow the latest News & Announcements and check out the Community on LinkedIn as well! It's the best way to stay up-to-date with all the news from across Microsoft Power Platform and beyond.    COMMUNITY HIGHLIGHTS   Check out the most active community members of the last month! These hardworking members are posting regularly, answering questions, kudos, and providing top solutions in their communities. We are so thankful for each of you--keep up the great work! If you hope to see your name here next month, follow these awesome community members to see what they do!   Power AppsPower AutomateCopilot StudioPower PagesWarrenBelzDeenujialexander2523ragavanrajanLaurensMManishSolankiMattJimisonLucas001AmikcapuanodanilostephenrobertOliverRodriguestimlAndrewJManikandanSFubarmmbr1606VishnuReddy1997theMacResolutionsVishalJhaveriVictorIvanidzejsrandhawahagrua33ikExpiscornovusFGuerrero1PowerAddictgulshankhuranaANBExpiscornovusprathyooSpongYeNived_Nambiardeeksha15795apangelesGochixgrantjenkinsvasu24Mfon   LATEST NEWS   Business Applications Launch Event - On Demand In case you missed the Business Applications Launch Event, you can now catch up on all the announcements and watch the entire event on-demand inside Charles Lamanna's latest cloud blog.   This is your one stop shop for all the latest Copilot features across Power Platform and #Dynamics365, including first-hand looks at how companies such as Lenovo, Sonepar, Ford Motor Company, Omnicom and more are using these new capabilities in transformative ways. Click the image below to watch today!   Power Platform Community Conference 2024 is here! It's time to look forward to the next installment of the Power Platform Community Conference, which takes place this year on 18-20th September 2024 at the MGM Grand in Las Vegas!   Come and be inspired by Microsoft senior thought leaders and the engineers behind the #PowerPlatform, with Charles Lamanna, Sangya Singh, Ryan Cunningham, Kim Manis, Nirav Shah, Omar Aftab and Leon Welicki already confirmed to speak. You'll also be able to learn from industry experts and Microsoft MVPs who are dedicated to bridging the gap between humanity and technology. These include the likes of Lisa Crosbie, Victor Dantas, Kristine Kolodziejski, David Yack, Daniel Christian, Miguel Félix, and Mats Necker, with many more to be announced over the coming weeks.   Click here to watch our brand-new sizzle reel for #PPCC24 or click the image below to find out more about registration. See you in Vegas!       Power Up Program Announces New Video-Based Learning Hear from Principal Program Manager, Dimpi Gandhi, to discover the latest enhancements to the Microsoft #PowerUpProgram. These include a new accelerated video-based curriculum crafted with the expertise of Microsoft MVPs, Rory Neary and Charlie Phipps-Bennett. If you’d like to hear what’s coming next, click the image below to find out more!   UPCOMING EVENTS Microsoft Build - Seattle and Online - 21-23rd May 2024 Taking place on 21-23rd May 2024 both online and in Seattle, this is the perfect event to learn more about low code development, creating copilots, cloud platforms, and so much more to help you unleash the power of AI.   There's a serious wealth of talent speaking across the three days, including the likes of Satya Nadella, Amanda K. Silver, Scott Guthrie, Sarah Bird, Charles Lamanna, Miti J., Kevin Scott, Asha Sharma, Rajesh Jha, Arun Ulag, Clay Wesener, and many more.   And don't worry if you can't make it to Seattle, the event will be online and totally free to join. Click the image below to register for #MSBuild today!   European Collab Summit - Germany - 14-16th May 2024 The clock is counting down to the amazing European Collaboration Summit, which takes place in Germany May 14-16, 2024. #CollabSummit2024 is designed to provide cutting-edge insights and best practices into Power Platform, Microsoft 365, Teams, Viva, and so much more. There's a whole host of experts speakers across the three-day event, including the likes of Vesa Juvonen, Laurie Pottmeyer, Dan Holme, Mark Kashman, Dona Sarkar, Gavin Barron, Emily Mancini, Martina Grom, Ahmad Najjar, Liz Sundet, Nikki Chapple, Sara Fennah, Seb Matthews, Tobias Martin, Zoe Wilson, Fabian Williams, and many more.   Click the image below to find out more about #ECS2024 and register today!     Microsoft 365 & Power Platform Conference - Seattle - 3-7th June If you're looking to turbo boost your Power Platform skills this year, why not take a look at everything TechCon365 has to offer at the Seattle Convention Center on June 3-7, 2024.   This amazing 3-day conference (with 2 optional days of workshops) offers over 130 sessions across multiple tracks, alongside 25 workshops presented by Power Platform, Microsoft 365, Microsoft Teams, Viva, Azure, Copilot and AI experts. There's a great array of speakers, including the likes of Nirav Shah, Naomi Moneypenny, Jason Himmelstein, Heather Cook, Karuana Gatimu, Mark Kashman, Michelle Gilbert, Taiki Y., Kristi K., Nate Chamberlain, Julie Koesmarno, Daniel Glenn, Sarah Haase, Marc Windle, Amit Vasu, Joanne C Klein, Agnes Molnar, and many more.   Click the image below for more #Techcon365 intel and register today!     For more events, click the image below to visit the Microsoft Community Days website.      

Tuesday Tip | Update Your Community Profile Today!

Tuesday Tip | Update Your Community Profile Today!

It's time for another TUESDAY TIPS, your weekly connection with the most insightful tips and tricks that empower both newcomers and veterans in the Power Platform Community! Every Tuesday, we bring you a curated selection of the finest advice, distilled from the resources and tools in the Community. Whether you’re a seasoned member or just getting started, Tuesday Tips are the perfect compass guiding you across the dynamic landscape of the Power Platform Community.   We're excited to announce that updating your community profile has never been easier! Keeping your profile up to date is essential for staying connected and engaged with the community.   Check out the following Support Articles with these topics: Accessing Your Community ProfileRetrieving Your Profile URLUpdating Your Community Profile Time ZoneChanging Your Community Profile Picture (Avatar)Setting Your Date Display Preferences Click on your community link for more information: Power Apps, Power Automate, Power Pages, Copilot Studio   Thank you for being an active part of our community. Your contributions make a difference! Best Regards, The Community Management Team

Hear what's next for the Power Up Program

Hear what's next for the Power Up Program

Hear from Principal Program Manager, Dimpi Gandhi, to discover the latest enhancements to the Microsoft #PowerUpProgram, including a new accelerated video-based curriculum crafted with the expertise of Microsoft MVPs, Rory Neary and Charlie Phipps-Bennett. If you’d like to hear what’s coming next, click the link below to sign up today! https://aka.ms/PowerUp  

Super User of the Month | Ahmed Salih

Super User of the Month | Ahmed Salih

We're thrilled to announce that Ahmed Salih is our Super User of the Month for April 2024. Ahmed has been one of our most active Super Users this year--in fact, he kicked off the year in our Community with this great video reminder of why being a Super User has been so important to him!   Ahmed is the Senior Power Platform Architect at Saint Jude's Children's Research Hospital in Memphis. He's been a Super User for two seasons and is also a Microsoft MVP! He's celebrating his 3rd year being active in the Community--and he's received more than 500 kudos while authoring nearly 300 solutions. Ahmed's contributions to the Super User in Training program has been invaluable, with his most recent session with SUIT highlighting an incredible amount of best practices and tips that have helped him achieve his success.   Ahmed's infectious enthusiasm and boundless energy are a key reason why so many Community members appreciate how he brings his personality--and expertise--to every interaction. With all the solutions he provides, his willingness to help the Community learn more about Power Platform, and his sheer joy in life, we are pleased to celebrate Ahmed and all his contributions! You can find him in the Community and on LinkedIn. Congratulations, Ahmed--thank you for being a SUPER user!

Tuesday Tip: Getting Started with Private Messages & Macros

Tuesday Tip: Getting Started with Private Messages & Macros

Welcome to TUESDAY TIPS, your weekly connection with the most insightful tips and tricks that empower both newcomers and veterans in the Power Platform Community! Every Tuesday, we bring you a curated selection of the finest advice, distilled from the resources and tools in the Community. Whether you’re a seasoned member or just getting started, Tuesday Tips are the perfect compass guiding you across the dynamic landscape of the Power Platform Community.   As our community family expands each week, we revisit our essential tools, tips, and tricks to ensure you’re well-versed in the community’s pulse. Keep an eye on the News & Announcements for your weekly Tuesday Tips—you never know what you may learn!   This Week's Tip: Private Messaging & Macros in Power Apps Community   Do you want to enhance your communication in the Community and streamline your interactions? One of the best ways to do this is to ensure you are using Private Messaging--and the ever-handy macros that are available to you as a Community member!   Our Knowledge Base article about private messaging and macros is the best place to find out more. Check it out today and discover some key tips and tricks when it comes to messages and macros:   Private Messaging: Learn how to enable private messages in your community profile and ensure you’re connected with other community membersMacros Explained: Discover the convenience of macros—prewritten text snippets that save time when posting in forums or sending private messagesCreating Macros: Follow simple steps to create your own macros for efficient communication within the Power Apps CommunityUsage Guide: Understand how to apply macros in posts and private messages, enhancing your interaction with the Community For detailed instructions and more information, visit the full page in your community today:Power Apps: Enabling Private Messaging & How to Use Macros (Power Apps)Power Automate: Enabling Private Messaging & How to Use Macros (Power Automate)  Copilot Studio: Enabling Private Messaging &How to Use Macros (Copilot Studio) Power Pages: Enabling Private Messaging & How to Use Macros (Power Pages)

Tuesday Tip: Subscriptions & Notifications

Tuesday Tip: Subscriptions & Notifications

TUESDAY TIPS are our way of communicating helpful things we've learned or shared that have helped members of the Community. Whether you're just getting started or you're a seasoned pro, Tuesday Tips will help you know where to go, what to look for, and navigate your way through the ever-growing--and ever-changing--world of the Power Platform Community! We cover basics about the Community, provide a few "insider tips" to make your experience even better, and share best practices gleaned from our most active community members and Super Users.   With so many new Community members joining us each week, we'll also review a few of our "best practices" so you know just "how" the Community works, so make sure to watch the News & Announcements each week for the latest and greatest Tuesday Tips!   This Week: All About Subscriptions & Notifications We don't want you to a miss a thing in the Community! The best way to make sure you know what's going on in the News & Announcements, to blogs you follow, or forums and galleries you're interested in is to subscribe! These subscriptions ensure you receive automated messages about the most recent posts and replies. Even better, there are multiple ways you can subscribe to content and boards in the community! (Please note: if you have created an AAD (Azure Active Directory) account you won't be able to receive e-mail notifications.)   Subscribing to a Category  When you're looking at the entire category, select from the Options drop down and choose Subscribe.     You can then choose to Subscribe to all of the boards or select only the boards you want to receive notifications. When you're satisfied with your choices, click Save.     Subscribing to a Topic You can also subscribe to a single topic by clicking Subscribe from the Options drop down menu, while you are viewing the topic or in the General board overview, respectively.     Subscribing to a Label Find the labels at the bottom left of a post.From a particular post with a label, click on the label to filter by that label. This opens a window containing a list of posts with the label you have selected. Click Subscribe.     Note: You can only subscribe to a label at the board level. If you subscribe to a label named 'Copilot' at board #1, it will not automatically subscribe you to an identically named label at board #2. You will have to subscribe twice, once at each board.   Bookmarks Just like you can subscribe to topics and categories, you can also bookmark topics and boards from the same menus! Simply go to the Topic Options drop down menu to bookmark a topic or the Options drop down to bookmark a board. The difference between subscribing and bookmarking is that subscriptions provide you with notifications, whereas bookmarks provide you a static way of easily accessing your favorite boards from the My subscriptions area.   Managing & Viewing Your Subscriptions & Bookmarks To manage your subscriptions, click on your avatar and select My subscriptions from the drop-down menu.     From the Subscriptions & Notifications tab, you can manage your subscriptions, including your e-mail subscription options, your bookmarks, your notification settings, and your email notification format.     You can see a list of all your subscriptions and bookmarks and choose which ones to delete, either individually or in bulk, by checking multiple boxes.     A Note on Following Friends on Mobile Adding someone as a friend or selecting Follow in the mobile view does not allow you to subscribe to their activity feed. You will merely be able to see your friends’ biography, other personal information, or online status, and send messages more quickly by choosing who to send the message to from a list, as opposed to having to search by username.

Users online (6,284)