cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ianallen13
Helper II
Helper II

SharePoint to Outlook email question

Hello, 

 

I have a flow built where once a item is created in SharePoint, an email is automatically sent out via outlook.  Everything works create except I have one field in SharePoint (a 'score' field) that shows up in SharePoint as a percent, which is good, but comes across in the email as a decimal (i.e. 95% vs. .95).  Before anyone says double check SharePoint, I did and I do have that field set to display percentages, so is there something else that I am missing by chance?  

 

SharePoint View.JPGOutlook view.JPGSharePoint View2.JPG

6 REPLIES 6
efialttes
Super User III
Super User III

Hi!

So even you set on Sharepoint that field to display percentages, it is internally stored and delivered by the API in this other format.

If you inspect trigger's output from your flow execution you will realize it

Now, how to proceed?

You can use a WDL expression to convert it back to percentage and display it this way in your email. mul() and concat() should do the magic

So, let's assume your column name is called 'Percentage'. I would suggest to add the following WDL expression to your email body:

 

concat(mul(triggerBody()?['Percentage'],100),'%')

 

If you are not familiar with WDL expressions yet, please follow these steps to add it

https://flow.microsoft.com/es-es/blog/use-expressions-in-actions/

 

Hope this helps



Each time you click on any of our inspiring answers 'Thumb up' icon...
...an ewok scapes from the stormtroopers.

Be grateful, Thumbs up! Save the Galaxy for free!


Escribo sobre Power Automate en:
https://medium.com/anyone-can-automate/

Proud to be a Flownaut!



Thank you for providing this.  I'm still very new to everything, but I tried this - including my column "CU QA Score" and followed the equation that you mentioned and tested it, but it failed.  I'm sure I missed something - if you can provide further details on what this needs, I'd appreciate?  This is the error I received: 

 

InvalidTemplate. Unable to process template language expressions in action 'Send_an_email_(V2)' inputs at line '1' and column '2858': 'The template language function 'mul' expects its first parameter to be an integer or a decimal number. The provided value is of type 'Null'. Please see https://aka.ms/logicexpressions#mul for usage details.'.

 

How would I resolve this so that it works moving forward?

Hi again!

Since you named your column "CU QA Score" I think the problem is probably its Sharepoint internal name differs. In order to doubleckeck it, you can add a dummy 'Compose' action block just after the trigger just for troubleshooting purposes, assigns as its input your 'Percentage column', then hover your mouse over it so your Sharepoint internal column name will be displayed. You should use this name in your expression

If this is not the problem, please share a screenshot from your current flow design

Thanx!

 



Each time you click on any of our inspiring answers 'Thumb up' icon...
...an ewok scapes from the stormtroopers.

Be grateful, Thumbs up! Save the Galaxy for free!


Escribo sobre Power Automate en:
https://medium.com/anyone-can-automate/

Proud to be a Flownaut!



Thank you for the reply, 

 

Unfortunately, you will have to dumb it down for me a bit.  So it sounds like the problem lies in SharePoint?   

 

Also, let me provide a bit of background.  The information that is going to SharePoint is coming from a form I built in Power Apps, where the score is calculated, would that have any play in the problem?  Here is the equation for that calculation in PowerApps: 

 

Text(((14-'CU_Error Count_Eval')/14)*100,"[$-en-US]")& "%" 

 

Not sure if that helps or not?

Hi!

Can you share a screenshot from your current flow design?

Thanx!



Each time you click on any of our inspiring answers 'Thumb up' icon...
...an ewok scapes from the stormtroopers.

Be grateful, Thumbs up! Save the Galaxy for free!


Escribo sobre Power Automate en:
https://medium.com/anyone-can-automate/

Proud to be a Flownaut!



Flow1.JPG

Helpful resources

Announcements
MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are Your Ready?

Test your skills now with the Cloud Skill Challenge.

Top Solution Authors
Users online (73,298)