cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
JerryH
Helper V
Helper V

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
Impactful Individual
Impactful Individual

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?

MichaelAnnis
Impactful Individual
Impactful Individual

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
MPA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

V3_PVA CAmpaign Carousel.png

Community Challenge - Giveaways!

Participate in the Power Virtual Agents Community Challenge

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

R2 (Green) 768 x 460px.png

Microsoft Dynamics 365 & Power Platform User Professionals

DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.

Users online (2,118)