hi,
I am able to pull the data from SharePoint list to Power app.
The Data like - Total Score come as = 0.80 , But i want to convert it to percentage. How to do it ?
The Second issue how can i add an indicator based on Total score % . if Total score > 0.8 - High , > 0.5 - Medium , > 0.2 - Low
Hi @Bhanu2023
The Switch function evaluates a formula and determines whether the result matches any value in a sequence that you specify. If a match is found, a corresponding value is returned. If no match is found, a default value is returned. In either case, the returned value might be a string to show, a formula to evaluate, or another form of result.
Could you try this to convert it to percentage: Text(0.05 * 100 ,"#%")
Share
Report
All responses (
Answers (
5,909
Switch(
Total_score.Text,
0.8,
"High",
0.5,
"Medium",
0.2,
"Low"
)
-----------------------
PowerYsa Power Platform Enthusiast [LinkedIn] | [Youtube]
I love to share my knowledge and learn from others. If you find my posts helpful, please give them a thumbs up 👍 or mark them as a solution ✔️. You can also check out my [@PowerYSA] for some cool solutions and insights. Feel free to connect with me on any of the platforms above. Cheers! 🍻
