web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

Welcome to the Power Platform Communities
The Next Big Bite | Aussie Classics & Starting Small with Clay Wesener | EP04
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Number format - Sharep...
Power Automate
Answered

Number format - Sharepoint > Automate > Email

(0) ShareShare
ReportReport
Posted on by JerryH 431

Hi, 

I have created a Flow from Sharepoint to Outlook Email.

Despite my Sharepoint column format being either a % or Whole Number, or no decimal places

On my email, the desired fields format are wrong, please see below.

Should be 80% & 3

 

JerryH_0-1627036472342.png

Any support would be appreciated 

Thanks

Jerry

Categories:
Power Automate Desktop
I have the same question (0)
  • tkuehara Profile Picture
    tkuehara 667 on at

    Hi @JerryH 

     

    Could you provide more details of your flow (print from your flow and your email message configuration)?

  • MichaelAnnis Profile Picture
    MichaelAnnis 5,727 Moderator on at

    Try convert number to text before writing it to the e-mail:

    MichaelAnnis_0-1627053613391.png

    The Convert number to Text details are here:

    MichaelAnnis_1-1627053662029.png

     

     

  • JerryH Profile Picture
    JerryH 431 on at

    hi Michael, 

    Where do i find these screen shots in Flow/Automate?

    looks like your suggestion will work but i am unable to locate where to do this?

  • MichaelAnnis Profile Picture
    MichaelAnnis 5,727 Moderator on at

    When editing a PAD flow, the actions should be in the left bar with a search option in the top left:

    MichaelAnnis_0-1627489491852.png

    type in "convert" and then you should see "convert number to text" action to use.

     

  • Verified answer
    Community Power Platform Member Profile Picture
    Community Power Pla... Microsoft Employee on at

    I believe @JerryH flow was created in Power Automate (ex-Flow), and not Power Automate Desktop (PAD), that's why he couldn't locate the right commands...

  • JerryH Profile Picture
    JerryH 431 on at

    Hi

    Please see configuration below.

    I use the "https://emea.flow.microsoft.com/manage/environments" to create my Flow

     

    JerryH_0-1627555762306.png

     

    JerryH_1-1627555786440.png

    JerryH_2-1627555842627.png

     

     

  • JerryH Profile Picture
    JerryH 431 on at

    I am going to Download PAD now 🙂

  • JerryH Profile Picture
    JerryH 431 on at

    Hi

    I have now downloaded PAD.
    Step 1 create new flow.
    Step 2 - how do i start the flow, when a new item is added to my Sharepoint?

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Welcome to the Power Platform Communities
The Next Big Bite | Aussie Classics & Starting Small with Clay Wesener | EP04

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
David_MA Profile Picture

David_MA 262 Super User 2026 Season 1

#2
11manish Profile Picture

11manish 167

#3
Haque Profile Picture

Haque 154

Last 30 days Overall leaderboard

Featured topics

Known issue with browser automation in Power Automate for Desktop on Google Chrome 146 and 147
Share your ideas and struggles with building Power Automate flows!
Survey: Power Automate mobile app
How to Ask for Help with Your Power Automate Workflow
Flows are not visible for users who sign in with their personal accounts
Start and wait for an approval action
Restore a deleted flow
List of actions cheat sheet for Power Automate Desktop
Welcome to the Power Automate forum!

Product updates

Microsoft Power Platform Community release plans