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?
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?
So, let's assume your column name is called 'Percentage'. I would suggest to add the following WDL expression to your email body:
If you are not familiar with WDL expressions yet, please follow these steps to add it
Hope this helps
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?
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
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?
Check out new user group experience and if you are a leader please create your group
On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks
Check out how to claim yours today!
Test your skills now with the Cloud Skill Challenge.