cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
MrNigel
Advocate V
Advocate V

Using @split to extract URL from email body text

We have a solution that sends emails containing a URL at the start of the body text (with further text after the URL which we want to discard) and want to upload this to a SPO list URL column.  This is a standard "When new email arrives" --> "HTML to text"-->"Compose @split" flow.  This is the email body in Outlook:

 

Outlook email body textOutlook email body text

 

The output from the HTML to text action looks OK except that the space after the URL is bring translated to a new line:

 

https://techcommunity.microsoft.com/t5/Microsoft-Forms-Blog/What-s-New-in-Microsoft-Forms-Oct-Nov-20...
This is text after the URL

 

We are using @split to extract the URL only as this is the first 'column' but in the split function I have tried ' ', '%20', '\n' for the separator but it just passes all the text through:

 

This is the function in the Compose action, I have tried double quoting it as per other articles but it makes no difference:

 

split(body('Html_to_text_-_email_body'),'\n')
 
All I want is the URL https://techcommunity.microsoft.com/t5/Microsoft-Forms-Blog/What-s-New-in-Microsoft-Forms-Oct-Nov-20...so I can use it in a Create item action to fill at SPO list URL column.
 
I guess I am missing quotes/brackets somewhere but cannot figure out which/where.
 
TIA
 
Nigel

 

 

 
 
 
1 ACCEPTED SOLUTION

Accepted Solutions

Hey @MrNigel 

I've tested this as per the Flow I'd sent across, it does work 🙂

Can you add a screen shot showing the outputs from each of the actions? and can you share the configuration of your 'Create item - SPO List' action please?

%0A is the encoded representation of '\n'... you can't use ' ' or '\n' to split a string... but you can split a string using the encoded version which is why I'd converted to a URI.

Example:

a.png

 Cheers J

View solution in original post

8 REPLIES 8
Jay-Encodian
Community Champion
Community Champion

Hey @MrNigel 

I think this does what you need... I played with this for quite a while and may have missed what you're trying to do!

The email...

1.PNGThe final extracted output from the HTML email body: https://techcommunity.microsoft.com/t5/Microsoft-Forms-Blog/What-s-New-in-Microsoft-Forms-Oct-Nov-20

1.PNG

The Flow:

1.PNG

The expressions:

'Compose - URI Encode' : uriComponent(body('Html_to_text'))

'Compose - Split on Encoded Line Break' : split(outputs('Compose_2'),'%0A')

'Compose - Decode First Item in Array' : decodeUriComponent(first(outputs('Compose')))

HTH

Jay

-------------------------------------------------------------------------

If I have answered your question, please mark your post as Solved.

If you like my response, please give it a Thumbs Up

Hi Jay,

 

Updated my Flow with your mods, all green ticks but when I look at the SPO list then entire body text has been saved as a URL:

 

Added the expressions as a comments so visibleAdded the expressions as a comments so visible

 

What it has done is encode the entire body text as a single URL string (presumably the lat Compose action doing its stuff!  IMHO it is the split function 'separator' that is the issue.  To test it I used the letter 'm' and it duly broke up the string on every occurrence of 'm'.  I have tried various combinations of '%0A', '%0D', '\n', '\\n' but all pass through the body text unaltered.  It seems to be an issue when using a non-ASCII separator character - I even tried removing the single quotes around the %0A but that wouldn't let me save.

 

Has anyone successfully used @split with a non-ASCII separator?

 

Tks

 

Nigel

Hey @MrNigel 

I've tested this as per the Flow I'd sent across, it does work 🙂

Can you add a screen shot showing the outputs from each of the actions? and can you share the configuration of your 'Create item - SPO List' action please?

%0A is the encoded representation of '\n'... you can't use ' ' or '\n' to split a string... but you can split a string using the encoded version which is why I'd converted to a URI.

Example:

a.png

 Cheers J

Im trying to do the same, Extract a URL from an Email, that i receive daily, this Link is a ZIP file that i save to sharepoint.

 

Problem is , when @split to extract i get the whole email body and not just the url

@master_NK This is how I did it, the key item is  the '%0A'

 

image.png

 

Hi,

I am facing a similar issue only that the URL is in between the email text, how can this be split? 

 

aanyoti1_0-1600236281181.png

 

Hi @aanyoti1 

Can you raise a new thread and clearly explain what your trying to achieve? i.e. the input and outputs you require

Thanks J

ravirajyenneti
New Member

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional //EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:v="urn:schemas-microsoft-com:vml">
<head>
<!--[if gte mso 9]><xml><o:OfficeDocumentSettings><o:AllowPNG></o:AllowPNG><o:PixelsPerInch>96</o:PixelsPerInch></o:OfficeDocumentSettings></xml><![endif]-->
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<meta name="viewport" content="width=device-width">
<!--[if !mso]><!-->
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<!--<![endif]-->
<title></title>
<!--[if !mso]><!-->
<link href="https://fonts.googleapis.com/css?family=Bitter" rel="stylesheet" type="text/css">
<link href="https://fonts.googleapis.com/css?family=Open+Sans" rel="stylesheet" type="text/css">
<!--<![endif]-->
<style type="text/css">
body {
margin: 0;
padding: 0;
}

table,
td,
tr {
vertical-align: top;
border-collapse: collapse;
}

* {
line-height: inherit;
}

a[x-apple-data-detectors=true] {
color: inherit !important;
text-decoration: none !important;
}

.ie-browser table {
table-layout: fixed;
}

[owa] .img-container div,
[owa] .img-container button {
display: block !important;
}

[owa] .fullwidth button {
width: 100% !important;
}

[owa] .block-grid .col {
display: table-cell;
float: none !important;
vertical-align: top;
}

.ie-browser .block-grid,
.ie-browser .num12,
[owa] .num12,
[owa] .block-grid {
width: 600px !important;
}

.ie-browser .mixed-two-up .num4,
[owa] .mixed-two-up .num4 {
width: 200px !important;
}

.ie-browser .mixed-two-up .num8,
[owa] .mixed-two-up .num8 {
width: 400px !important;
}

.ie-browser .block-grid.two-up .col,
[owa] .block-grid.two-up .col {
width: 300px !important;
}

.ie-browser .block-grid.three-up .col,
[owa] .block-grid.three-up .col {
width: 300px !important;
}

.ie-browser .block-grid.four-up .col [owa] .block-grid.four-up .col {
width: 150px !important;
}

.ie-browser .block-grid.five-up .col [owa] .block-grid.five-up .col {
width: 121px !important;
}

.ie-browser .block-grid.six-up .col,
[owa] .block-grid.six-up .col {
width: 100px !important;
}

.ie-browser .block-grid.seven-up .col,
[owa] .block-grid.seven-up .col {
width: 86px !important;
}

.ie-browser .block-grid.eight-up .col,
[owa] .block-grid.eight-up .col {
width: 75px !important;
}

.ie-browser .block-grid.nine-up .col,
[owa] .block-grid.nine-up .col {
width: 67px !important;
}

.ie-browser .block-grid.ten-up .col,
[owa] .block-grid.ten-up .col {
width: 60px !important;
}

.ie-browser .block-grid.eleven-up .col,
[owa] .block-grid.eleven-up .col {
width: 54px !important;
}

.ie-browser .block-grid.twelve-up .col,
[owa] .block-grid.twelve-up .col {
width: 50px !important;
}

</style>
<style type="text/css" id="media-query">
@media only screen and (min-width: 625px) {
.block-grid {
width: 600px !important;
}
.block-grid .col {
vertical-align: top;
}
.block-grid .col.num12 {
width: 600px !important;
}
.block-grid.mixed-two-up .col.num3 {
width: 150px !important;
}
.block-grid.mixed-two-up .col.num4 {
width: 200px !important;
}
.block-grid.mixed-two-up .col.num8 {
width: 400px !important;
}
.block-grid.mixed-two-up .col.num9 {
width: 450px !important;
}
.block-grid.two-up .col {
width: 302px !important;
}
.block-grid.three-up .col {
width: 201px !important;
}
.block-grid.four-up .col {
width: 151px !important;
}
.block-grid.five-up .col {
width: 121px !important;
}
.block-grid.six-up .col {
width: 100px !important;
}
.block-grid.seven-up .col {
width: 86px !important;
}
.block-grid.eight-up .col {
width: 75px !important;
}
.block-grid.nine-up .col {
width: 67px !important;
}
.block-grid.ten-up .col {
width: 60px !important;
}
.block-grid.eleven-up .col {
width: 55px !important;
}
.block-grid.twelve-up .col {
width: 50px !important;
}
}

@media (max-width: 625px) {
.block-grid,
.col {
min-width: 320px !important;
max-width: 100% !important;
display: block !important;
}
.block-grid {
width: 100% !important;
}
.col {
width: 100% !important;
}
.col>div {
margin: 0 auto;
}
img.fullwidth,
img.fullwidthOnMobile {
max-width: 100% !important;
}
.no-stack .col {
min-width: 0 !important;
display: table-cell !important;
}
.no-stack.two-up .col {
width: 50% !important;
}
.no-stack .col.num4 {
width: 33% !important;
}
.no-stack .col.num8 {
width: 66% !important;
}
.no-stack .col.num4 {
width: 33% !important;
}
.no-stack .col.num3 {
width: 25% !important;
}
.no-stack .col.num6 {
width: 50% !important;
}
.no-stack .col.num9 {
width: 75% !important;
}
.mobile_hide {
min-height: 0px;
max-height: 0px;
max-width: 0px;
display: none;
overflow: hidden;
font-size: 0px;
}
}

</style>
</head>
<body class="clean-body" style="margin: 0; padding: 0; -webkit-text-size-adjust: 100%; background-color: #FFFFFF;">

 

 

<style type="text/css" id="media-query-bodytag">
@media (max-width: 625px) {
.block-grid {
min-width: 320px!important;
max-width: 100%!important;
width: 100%!important;
display: block!important;
}
.col {
min-width: 320px!important;
max-width: 100%!important;
width: 100%!important;
display: block!important;
}
.col > div {
margin: 0 auto;
}
img.fullwidth {
max-width: 100%!important;
height: auto!important;
}
img.fullwidthOnMobile {
max-width: 100%!important;
height: auto!important;
}
.no-stack .col {
min-width: 0!important;
display: table-cell!important;
}
.no-stack.two-up .col {
width: 50%!important;
}
.no-stack.mixed-two-up .col.num4 {
width: 33%!important;
}
.no-stack.mixed-two-up .col.num8 {
width: 66%!important;
}
.no-stack.three-up .col.num4 {
width: 33%!important
}
.no-stack.four-up .col.num3 {
width: 25%!important
}
}

</style>
<!--[if IE]><div class="ie-browser"><![endif]-->

<table bgcolor="#FFFFFF" cellpadding="0" cellspacing="0" class="nl-container" style="table-layout: fixed; vertical-align: top; min-width: 320px; Margin: 0 auto; border-spacing: 0; border-collapse: collapse; mso-table-lspace: 0pt; mso-table-rspace: 0pt; background-color: #FFFFFF; width: 100%;" valign="top" width="100%">
<tbody>
<tr style="vertical-align: top;" valign="top">
<td style="word-break: break-word; vertical-align: top; border-collapse: collapse;" valign="top">
<!--[if (mso)|(IE)]><table width="100%" cellpadding="0" cellspacing="0" border="0"><tr><td align="center" style="background-color:#FFFFFF"><![endif]-->
<div style="background-color:#0a2139;">
<div class="block-grid " style="Margin: 0 auto; min-width: 320px; max-width: 600px; overflow-wrap: break-word; word-wrap: break-word; word-break: break-word; background-color: transparent;">
<div style="border-collapse: collapse;display: table;width: 100%;background-color:transparent;">
<!--[if (mso)|(IE)]><table width="100%" cellpadding="0" cellspacing="0" border="0" style="background-color:#49A6E8;"><tr><td align="center"><table cellpadding="0" cellspacing="0" border="0" style="width:600px"><tr class="layout-full-width" style="background-color:transparent"><![endif]-->
<!--[if (mso)|(IE)]><td align="center" width="600" style="background-color:transparent;width:600px; border-top: 0px solid transparent; border-left: 0px solid transparent; border-bottom: 0px solid transparent; border-right: 0px solid transparent;" valign="top"><table width="100%" cellpadding="0" cellspacing="0" border="0"><tr><td style="padding-right: 0px; padding-left: 0px; padding-top:0px; padding-bottom:0px;"><![endif]-->
<div class="col num12" style="min-width: 320px; max-width: 600px; display: table-cell; vertical-align: top;">
<div style="width:100% !important;">
<!--[if (!mso)&(!IE)]><!-->
<div style="border-top:0px solid transparent; border-left:0px solid transparent; border-bottom:0px solid transparent; border-right:0px solid transparent; padding-top:0px; padding-bottom:0px; padding-right: 0px; padding-left: 0px;">
<!--<![endif]-->

<table border="0" cellpadding="0" cellspacing="0" class="divider" style="table-layout: fixed; vertical-align: top; border-spacing: 0; border-collapse: collapse; mso-table-lspace: 0pt; mso-table-rspace: 0pt; min-width: 100%; -ms-text-size-adjust: 100%; -webkit-text-size-adjust: 100%;" valign="top" width="100%">
<tbody>
<tr style="vertical-align: top;" valign="top">
<td class="divider_inner" style="word-break: break-word; vertical-align: top; min-width: 100%; -ms-text-size-adjust: 100%; -webkit-text-size-adjust: 100%; padding-top: 20px; padding-right: 20px; padding-bottom: 0px; padding-left: 20px; border-collapse: collapse;" valign="top">


<table align="center" border="0" cellpadding="0" cellspacing="0" class="block-grid " style="table-layout: fixed; vertical-align: top; border-spacing: 0; border-collapse: collapse; mso-table-lspace: 0pt; mso-table-rspace: 0pt; width: 100%; border-top: 0px solid transparent;" valign="top" width="100%">
<tbody></tbody>
</table>
</td>
</tr>
</tbody>
</table>

<!--[if mso]><table width="100%" cellpadding="0" cellspacing="0" border="0"><tr><td style="padding-right: 10px; padding-left: 10px; padding-top: 20px; padding-bottom: 30px; font-family: Georgia, 'Times New Roman', serif"><![endif]-->

<!--[if mso]></td></tr></table><![endif]-->
<div align="center" class="img-container center autowidth " style="padding-right: 0px;padding-left: 0px; background-color: transparent;">
<!--[if mso]><table width="100%" cellpadding="0" cellspacing="0" border="0"><tr style="line-height:0px"><td style="padding-right: 0px;padding-left: 0px;" align="center"><![endif]-->
<a href="https://www2.splashbi.com/Evidence-Based-Decision-Making-using-ORSS.html" target="_blank"> <img class="center autowidth" align="center" border="0" src="https://www2.splashbi.com/rs/069-CJM-174/images/06-24_01.jpg" alt="Image" title="Image" style="outline: none; text-decoration: none; -ms-interpolation-mode: bicubic; clear: both; height: auto; float: none; border: none; width: 100%; max-width: 600px; display: block;" width="600"></a>
<!--[if mso]></td></tr></table><![endif]-->
</div>
<!--[if (!mso)&(!IE)]><!-->
</div>
<!--<![endif]-->
</div>
</div>
<!--[if (mso)|(IE)]></td></tr></table><![endif]-->
<!--[if (mso)|(IE)]></td></tr></table></td></tr></table><![endif]-->
</div>
</div>
</div>
<div style=" background-color:#f5f3f3;">
<div class="block-grid " style="Margin: 0 auto; min-width: 320px; max-width: 600px; overflow-wrap: break-word; word-wrap: break-word; word-break: break-word; background-color:#ffffff;">
<div style="border-collapse: collapse;display: table;width: 100%;background-color:#ffffff;">
<!--[if (mso)|(IE)]><table width="100%" cellpadding="0" cellspacing="0" border="0" style="background-color:#f3f3f3;"><tr><td align="center"><table cellpadding="0" cellspacing="0" border="0" style="width:600px"><tr class="layout-full-width" style="background-color:transparent"><![endif]-->
<!--[if (mso)|(IE)]><td align="center" width="600" style="background-color:transparent;width:600px; border-top: 0px solid transparent; border-left: 0px solid transparent; border-bottom: 0px solid transparent; border-right: 0px solid transparent;" valign="top"><table width="100%" cellpadding="0" cellspacing="0" border="0"><tr><td style="padding-right: 0px; padding-left: 0px; padding-top:0px; padding-bottom:0px;background-color:#FFFFFF;"><![endif]-->
<div class="col num12" style="min-width: 320px; max-width: 600px; display: table-cell; vertical-align: top; background-color: #f5f3f3;">
<div style="width:100% !important;">
<!--[if (!mso)&(!IE)]><!-->
<div style="border-top:0px solid transparent; border-left:0px solid transparent; border-bottom:0px solid transparent; border-right:0px solid transparent; padding-top:0px; padding-bottom:0px; padding-right: 0px; padding-left: 0px;">
<!--<![endif]-->
<div align="center" class="img-container center autowidth " style="padding-right: 0px;padding-left: 0px;">
<!--[if mso]><table width="100%" cellpadding="0" cellspacing="0" border="0"><tr style="line-height:0px"><td style="padding-right: 0px;padding-left: 0px;" align="center"><![endif]-->
<a href="https://www2.splashbi.com/Evidence-Based-Decision-Making-using-ORSS.html" target="_blank"> <img class="center" align="center" border="0" src="https://www2.splashbi.com/rs/069-CJM-174/images/06-24_02.jpg" alt="Image" title="Image" style="outline: none; text-decoration: none; -ms-interpolation-mode: bicubic; clear: both; height: auto; float: none; border: none; width: 100%; max-width: 600px; display: block;" width="600"></a>
<!--[if mso]></td></tr></table><![endif]-->
</div>

<!--[if mso]><table width="100%" cellpadding="0" cellspacing="0" border="0"><tr><td style="padding-right: 30px; padding-left: 30px; padding-top: 30px; padding-bottom: 5px; font-family: Georgia, 'Times New Roman', serif"><![endif]-->

<!--[if mso]></td></tr></table><![endif]-->
<!--[if mso]><table width="100%" cellpadding="0" cellspacing="0" border="0"><tr><td style="padding-right: 30px; padding-left: 30px; padding-top: 5px; padding-bottom: 20px; font-family: Arial, sans-serif"><![endif]-->

<!--[if mso]></td></tr></table><![endif]-->

 

<!--[if (!mso)&(!IE)]><!-->
</div>
<!--<![endif]-->
</div>
</div>
<!--[if (mso)|(IE)]></td></tr></table><![endif]-->
<!--[if (mso)|(IE)]></td></tr></table></td></tr></table><![endif]-->
</div>
</div>
</div>
<div style="background-color:#f5f3f3;">
<div class="block-grid " style="Margin: 0 auto; min-width: 320px; max-width: 600px; overflow-wrap: break-word; word-wrap: break-word; word-break: break-word; background-color: transparent;">
<div style="border-collapse: collapse;display: table;width: 100%; background-color:#ffffff;">
<!--[if (mso)|(IE)]><table width="100%" cellpadding="0" cellspacing="0" border="0" style="background-color:#ffffff;"><tr><td align="center"><table cellpadding="0" cellspacing="0" border="0" style="width:600px"><tr class="layout-full-width" style="background-color:transparent"><![endif]-->
<!--[if (mso)|(IE)]><td align="center" width="600" style="background-color:transparent;width:600px; border-top: 0px solid transparent; border-left: 0px solid transparent; border-bottom: 0px solid transparent; border-right: 0px solid transparent;" valign="top"><table width="100%" cellpadding="0" cellspacing="0" border="0"><tr><td style="padding-right: 0px; padding-left: 0px; padding-top:5px; padding-bottom:5px;"><![endif]-->
<div class="col num12" style="min-width: 320px; max-width: 600px; display: table-cell; vertical-align: top;">
<div style="width:100% !important;">
<!--[if (!mso)&(!IE)]><!-->
<div style="border-top:0px solid transparent; border-left:0px solid transparent; border-bottom:0px solid transparent; border-right:0px solid transparent; padding-top:5px; padding-bottom:5px; padding-right: 30px; padding-left: 30px; text-align: left;">
<!--<![endif]-->
<!--[if mso]><table width="100%" cellpadding="0" cellspacing="0" border="0"><tr><td style="padding-right: 10px; padding-left: 10px; padding-top: 10px; padding-bottom: 10px; font-family: Georgia, 'Times New Roman', serif"><![endif]-->
<div style="color: #555555; font-family:'Bitter', Georgia, Times, 'Times New Roman', serif;line-height:120%;padding-top:0px;padding-right:10px;padding-bottom:10px;padding-left:0px; text-align:left;">
<div style="font-size: 12px; line-height: 14px; font-family: 'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif; color: #555555;">

<p style="font-size: 16px; line-height: 18px; margin: 0;"><span style="font-size: 16px; line-height: 18px; text-align: left;"></span></p>
</div>
</div>
<!--[if mso]></td></tr></table><![endif]-->
<!--[if mso]><table width="100%" cellpadding="0" cellspacing="0" border="0"><tr><td style="padding-right: 10px; padding-left: 10px; padding-top: 10px; padding-bottom: 10px; font-family: Arial, sans-serif"><![endif]-->
<div style="color:#555555;font-family:'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif;line-height:150%;padding-top:10px;padding-right:10px;padding-bottom:0px; text-align: left;">
<div style="font-size: 14px; line-height: 16px; color: #555555; font-family: 'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif;">

<p style="font-size: 14px; line-height: 16px; margin: 0;">

 


Hello {{lead.First Name:default=}},<br/><br/>

As an organisation, are you facing the dilemma of undertaking a right-sizing exercise through economic necessity or as a result of a merger & acquisition, leading to a reduced workforce? How do you make these critical business decisions - right-sizing, restructuring, or downsizing - based on unreliable or incomplete data?
<br/><br/>

Well, you are not alone, as research shows that over 50% of HR teams struggle to extract and analyse data to make robust decisions and hope for the best.

<br/><br/>

Join <strong>Steven Atkins and Andy Fisher</strong> for an enthralling session on <strong>Thursday, June 24th, at 11 AM BST</strong> to see how <strong>SplashHR</strong> is able to provide a solution to this sensitive process.


<br/><br/>
This session will explore:
</p>

 

 

 

 

 

</div>

<div style="font-size: 14px; line-height: 16px; color: #555555; font-family: 'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif;">

<table>
<tbody>
<tr>
<td>

<table>
<tbody>
<tr>
<td bgcolor="#FFFFFF" style="font-size:14px;line-height:18px;color:#000000;font-family: Arial, Helvetica, sans-serif;text-align:left; padding-top:0px; padding-left:20px; padding-right:15px; padding-bottom:0px;">

<table border="0" width="100%">
<tbody>
<tr>
<td style="color: #555555;" valign="top" width="3%">•&nbsp; </td>
<td align="left" style="font-size: 14px; color: #555555; font-family: Arial, Helvetica, sans-serif;text-align:left;" valign="top"><strong>How do I start the process, which employee’s should I choose, and why?</strong></td>
</tr>
<tr>
<td style="color: #555555;" valign="top" width="3%">•&nbsp; </td>
<td align="left" style="font-size: 14px; color: #555555; font-family: Arial, Helvetica, sans-serif;text-align:left;" valign="top"><strong> Using your data to make better-informed decision making </strong></td>
</tr>
<tr>
<td style="color: #555555;" valign="top" width="3%">•&nbsp; </td>
<td align="left" style="font-size: 14px; color: #555555; font-family: Arial, Helvetica, sans-serif;text-align:left;" valign="top"><strong>Do I know what my organisation currently looks like? </strong></td>
</tr>
<tr>
<td style="color: #555555;" valign="top" width="3%">•&nbsp; </td>
<td align="left" style="font-size: 14px; color: #555555; font-family: Arial, Helvetica, sans-serif;text-align:left;" valign="top"><strong>What will the organisation look like after the right-sizing exercise? </strong></td>
</tr>
<tr>
<td style="color: #555555;" valign="top" width="3%">•&nbsp; </td>
<td align="left" style="font-size: 14px; color: #555555; font-family: Arial, Helvetica, sans-serif;text-align:left;" valign="top"><strong>Using online criteria to model outcomes </strong></td>
</tr>
<tr>
<td style="color: #555555;" valign="top" width="3%">•&nbsp; </td>
<td align="left" style="font-size: 14px; color: #555555; font-family: Arial, Helvetica, sans-serif;text-align:left;" valign="top"><strong>Concluding the right-sizing process <br/><br/>
</strong></td>

</tr>


</tbody>
</table>
</td>
</tr>
</tbody>
</table>
</td>
</tr>
</tbody>
</table>
</div>
<div style="font-size: 14px; line-height: 16px; color: #555555; font-family: 'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif;">

<p style="font-size: 14px; line-height: 16px; margin: 0;">

 


Organisational Right-Sizing Solution (ORSS) allows you to make true evidence-based decision making with in-built selection criteria covering Diversity, Performance Reviews, Competencies, Absences, and Rankings and gives you a holistic view of all your organisational workforce data.

<br><br>

See how <strong><a href="https://splashhr.com/" rel="noopener" style="text-decoration: none; color: #994590;" target="_blank">SplashHR</a></strong> can help drive better decision-making.<br><br>
</p>

 

 

 

 

 

</div>
<div style="font-size: 14px; line-height: 16px; color: #555555; font-family: 'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif;">

 

 

 

 

 

 

</div>
</div>

<div style="font-size: 14px; line-height: 16px; color: #555555; font-family: 'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif;">

 

 

 

 

 

 

</div>
<div>


</div>
<!--[if mso]></td></tr></table><![endif]-->
<div align="center" class="button-container" style="padding-top:10px;padding-right:10px;padding-bottom:10px;padding-left:10px; text-align-last: center;">
<!--[if mso]><table align="center" width="100%" cellpadding="0" cellspacing="0" border="0" style="border-spacing: 0; border-collapse: collapse; mso-table-lspace:0pt; mso-table-rspace:0pt;"><tr><td style="padding-top: 10px; padding-right: 10px; padding-bottom: 10px; padding-left: 10px" align="left"><v:roundrect xmlns:v="urn:schemas-microsoft-com:vml" xmlns:w="urn:schemas-microsoft-com:office:word" href="https://www2.splashbi.com/Evidence-Based-Decision-Making-using-ORSS.html" style="height:39pt; width:135.75pt; v-text-anchor:middle;" arcsize="49%" stroke="false" fillcolor="#994590"><w:anchorlock></w:anchorlock><v:textbox inset="0,0,0,0"><center style="color:#ffffff; font-family:Arial, sans-serif; font-size:16px"><![endif]-->
<a href="https://www2.splashbi.com/Evidence-Based-Decision-Making-using-ORSS.html" style="-webkit-text-size-adjust: none; text-decoration: none; display: inline-block; color: #ffffff; background-color: #994590; border-radius: 25px; -webkit-border-radius: 25px; -moz-border-radius: 25px; width: auto; width: auto; border-top: 1px solid #994590; border-right: 1px solid #994590; border-bottom: 1px solid #994590; border-left: 1px solid #994590; padding-top: 10px; padding-bottom: 10px; font-family: 'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif; text-align: center; mso-border-alt: none; word-break: keep-all;" target="_blank"><span style="padding-left:30px;padding-right:30px;font-size:16px;display:inline-block;"> <span style="font-size: 14px; line-height: 32px;">Register Here</span> </span></a>
<!--[if mso]></center></v:textbox></v:roundrect></td></tr></table><![endif]-->
</div>
<div style="font-size: 14px; line-height: 16px; color: #555555; font-family: 'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif;">

<p style="font-size: 14px; line-height: 16px; margin: 0;">


<br/>

</p>

 

 

 

 

 

</div>
<!--[if mso]><table width="100%" cellpadding="0" cellspacing="0" border="0"><tr><td style="padding-right: 10px; padding-left: 10px; padding-top: 10px; padding-bottom: 10px; font-family: Arial, sans-serif"><![endif]-->

<br>
<!--[if mso]></td></tr></table><![endif]-->
<!--[if (!mso)&(!IE)]><!-->
</div>
<!--<![endif]-->

</div>
</div>
<!--[if (mso)|(IE)]></td></tr></table><![endif]-->
<!--[if (mso)|(IE)]></td></tr></table></td></tr></table><![endif]-->
</div>
</div>
</div>
<div style="background-color:#0a2139;">
<div class="block-grid mixed-two-up" style="Margin: 0 auto; min-width: 320px; max-width: 600px; overflow-wrap: break-word; word-wrap: break-word; word-break: break-word; background-color: 0a2139;">
<div style="border-collapse: collapse;display: table;width: 100%;background-color:0a2139;">
<!--[if (mso)|(IE)]><table width="100%" cellpadding="0" cellspacing="0" border="0" style="background-color:#0a2139"><tr><td align="center"><table cellpadding="0" cellspacing="0" border="0" style="width:600px"><tr class="layout-full-width" style="background-color:transparent"><![endif]-->
<!--[if (mso)|(IE)]><td align="center" width="403" style="background-color:transparent;width:403px; border-top: 0px solid transparent; border-left: 0px solid transparent; border-bottom: 0px solid transparent; border-right: 0px solid transparent;" valign="top"><table width="100%" cellpadding="0" cellspacing="0" border="0"><tr><td style="padding-right: 0px; padding-left: 0px; padding-top:15px; padding-bottom:15px;"><![endif]-->
<div class="col num8" style="display: table-cell; vertical-align: top; min-width: 320px; max-width: 400px;">
<div style="width:100% !important;">
<!--[if (!mso)&(!IE)]><!-->
<div style="border-top:0px solid transparent; border-left:0px solid transparent; border-bottom:0px solid transparent; border-right:0px solid transparent; padding-top:15px; padding-bottom:15px; padding-right: 0px; padding-left: 0px;">
<!--<![endif]-->
<!--[if mso]><table width="100%" cellpadding="0" cellspacing="0" border="0"><tr><td style="padding-right: 10px; padding-left: 10px; padding-top: 10px; padding-bottom: 10px; font-family: Arial, sans-serif"><![endif]-->
<div style="font-size: 12px; line-height: 14px; color: #ffffff; font-family: 'Cabin', Arial, 'Helvetica Neue', Helvetica, sans-serif; padding-left: 30px;">
<br>

<p style="font-size: 12px; line-height: 14px; margin: 0;">Unit 3 Sussex Innovation Centre, Sussex University, Science Park Square Falmer, Brighton, England BN1 9SB

</p>

<p style="font-size: 12px; line-height: 14px; margin: 0;">© <a href="https://splashbi.com/" rel="noopener" style="text-decoration: underline; color: #ffffff;" target="_blank">SplashBI</a> 2021&nbsp;<a href="https://splashbi.com/about-us/contact-us/" rel="noopener" style="text-decoration: underline; color: #ffffff;" target="_blank">Contact us</a> <a href="https://splashbi.com/about-us/privacy-policy/" rel="noopener" style="text-decoration: underline; color: #ffffff;" target="_blank">Privacy Policy</a></p>
<br>
<br>
</div>
<div class="block-grid mixed-two-up" style="Margin: 0 auto; min-width: 320px; max-width: 600px; overflow-wrap: break-word; word-wrap: break-word; word-break: break-word; background-color: transparent;">

<table>
<tbody>

</tbody>
</table>
</div>
<div class="block-grid mixed-two-up" style="Margin: 0 auto; min-width: 320px; max-width: 600px; overflow-wrap: break-word; word-wrap: break-word; word-break: break-word; background-color: transparent;">

<table>
<tbody>

</tbody>
</table>
</div>
<!--[if mso]></td></tr></table><![endif]-->
<!--[if (!mso)&(!IE)]><!-->
</div>
<!--<![endif]-->
</div>
</div>
<!--[if (mso)|(IE)]></td></tr></table><![endif]-->
<!--[if (mso)|(IE)]></td><td align="center" width="201" style="background-color:transparent;width:201px; border-top: 0px solid transparent; border-left: 0px solid transparent; border-bottom: 0px solid transparent; border-right: 0px solid transparent;" valign="top"><table width="100%" cellpadding="0" cellspacing="0" border="0"><tr><td style="padding-right: 10px; padding-left: 10px; padding-top:15px; padding-bottom:15px;"><![endif]-->
<div class="col num4" style="display: table-cell; vertical-align: top; max-width: 320px; min-width: 200px;">
<div style="width:100% !important;">
<!--[if (!mso)&(!IE)]><!-->
<div style="border-top:0px solid transparent; border-left:0px solid transparent; border-bottom:0px solid transparent; border-right:0px solid transparent; padding-top:15px; padding-bottom:15px;">
<!--<![endif]-->

<table cellpadding="0" cellspacing="0" class="social_icons" style="table-layout: fixed; vertical-align: top; border-spacing: 0; border-collapse: collapse; mso-table-lspace: 0pt; mso-table-rspace: 0pt;" valign="top" width="100%">
<tbody>
<tr style="vertical-align: top;" valign="top">
<td style="word-break: break-word; vertical-align: top; padding-top: 10px; padding-right: 10px; padding-bottom: 10px; padding-left: 10px; border-collapse: collapse;" valign="top">

<table align="center" cellpadding="0" cellspacing="0" class="social_table" style="table-layout: fixed; vertical-align: top; border-spacing: 0; border-collapse: undefined; mso-table-tspace: 0; mso-table-rspace: 0; mso-table-bspace: 0; mso-table-lspace: 0;" valign="top">
<tbody>
<tr align="right" style="vertical-align: top; display: inline-block; text-align: right;" valign="top">
<td style="word-break: break-word; vertical-align: top; padding-bottom: 5px; padding-right: 0px; padding-left: 5px; border-collapse: collapse;" valign="top">
<a href="https://www.facebook.com/splashbi?" target="_blank" title="Facebook"><img width="32" height="32" src="https://d2fi4ri5dhpqd1.cloudfront.net/public/resources/social-networks-icon-sets/circle-color/facebo..." alt="Facebook" title="Facebook" style="outline: none; text-decoration: none; -ms-interpolation-mode: bicubic; clear: both; height: auto; float: none; border: none; display: block;"></a></td>
<td style="word-break: break-word; vertical-align: top; padding-bottom: 5px; padding-right: 0px; padding-left: 5px; border-collapse: collapse;" valign="top">
<a href="https://twitter.com/SplashBI" target="_blank" title="Twitter"><img width="32" height="32" src="https://d2fi4ri5dhpqd1.cloudfront.net/public/resources/social-networks-icon-sets/circle-color/twitte..." alt="Twitter" title="Twitter" style="outline: none; text-decoration: none; -ms-interpolation-mode: bicubic; clear: both; height: auto; float: none; border: none; display: block;"></a></td>
<td style="word-break: break-word; vertical-align: top; padding-bottom: 5px; padding-right: 0px; padding-left: 5px; border-collapse: collapse;" valign="top">
<a href="https://www.linkedin.com/company/splash-bi/" target="_blank" title="LinkedIn"><img width="32" height="32" src="https://d2fi4ri5dhpqd1.cloudfront.net/public/resources/social-networks-icon-sets/circle-color/linked..." alt="LinkedIn" title="LinkedIn" style="outline: none; text-decoration: none; -ms-interpolation-mode: bicubic; clear: both; height: auto; float: none; border: none; display: block;"></a></td>
</tr>
</tbody>
</table>
</td>
</tr>
</tbody>
</table>
<!--[if (!mso)&(!IE)]><!-->
</div>
<!--<![endif]-->
</div>
</div>
<!--[if (mso)|(IE)]></td></tr></table><![endif]-->
<!--[if (mso)|(IE)]></td></tr></table></td></tr></table><![endif]-->
</div>


</div>

</div>
<!--[if (mso)|(IE)]></td></tr></table><![endif]--></td>
</tr>
</tbody>
</table>
<!--[if (IE)]></div><![endif]-->
</body>
</html>

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

May UG Leader Call Carousel 768x460.png

June User Group Leader Call

Join us on June 28 for our monthly User Group leader call!

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

Power Automate Designer Feedback_carousel.jpg

Help make Flow Design easier

Are you new to designing flows? What is your biggest struggle with Power Automate Designer? Help us make it more user friendly!

Top Solution Authors
Top Kudoed Authors
Users online (1,295)