SharePoint to Outlook email question

(0) Share

Report

Posted on by ianallen13

282

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.JPG Outlook view.JPG SharePoint View2.JPG

Categories:

General topics

All responses (6)

Answers (0)

Sort by

efialttes 14,756 on at

Like
a
(0)

Report
Copy link

Link copied!
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
ianallen13 282 on at

Like
a
(0)

Report
Copy link

Link copied!

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?
efialttes 14,756 on at

Like
a
(0)

Report
Copy link

Link copied!

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!
ianallen13 282 on at

Like
a
(0)

Report
Copy link

Link copied!

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?
efialttes 14,756 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi!

Can you share a screenshot from your current flow design?

Thanx!
ianallen13 282 on at

Like
a
(0)

Report
Copy link

Link copied!