cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
JerryH
Resolver III
Resolver III

Number format - Sharepoint > Automate > Email

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

1 ACCEPTED SOLUTION

Accepted Solutions

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...

View solution in original post

8 REPLIES 8
tkuehara
Solution Specialist
Solution Specialist

Hi @JerryH 

 

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

MichaelAnnis
Memorable Member
Memorable Member

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

 

 

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?

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.

 

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...

View solution in original post

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

 

 

I am going to Download PAD now 🙂

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?

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Users online (1,338)