web
You’re offline. This is a read only version of the page.
close
Skip to main content
News and Announcements icon
Community site session details

Community site session details

Session Id : w7gmzkEUFIXTbmZhE4ff9F
Power Platform Community / Forums / Power Automate - General Discussion / power bi values format
Power Automate - General Discussion
Unanswered

power bi values format

Like (0) ShareShare
ReportReport
Posted on 18 Mar 2024 13:31:16 by apenyaranda1985 62

Hello,

I have the following automated process where I collect values from power bi and add them to the template created from word. Among those values there are numbers which I would like to format.

Currently it adds them to me with many decimal places and I would like to put only two decimal places
Another value would like it to be with a % at the end

And on the other hand, I would like one of the columns of those values to store the total of the sum.

 

apenyaranda1985_0-1710768662815.png

 

Would it be possible?

I have the same question (0)
  • apenyaranda1985 Profile Picture
    apenyaranda1985 62 on 19 Mar 2024 at 06:01:30
    Re: power bi values format

    Hello @Joseph_Fadero 

    I don't know Power fx but I'm going to look into it. I understand that the formulas I want to use are made directly in the word template?
    On the other hand, about the total I want is the following.

    I have a table in power bi with several columns, one of them is total sales where through power automate I am capturing the entire table in my word template, what I want is that at the end of the column total sales, apart from adding all rows, also add the sum of the entire column.

     

    What I am trying that I have seen done is to do the formatting when I collect the values from power bi but I get the following error:


    Unable to process template language expressions for action 'Format_number' at line '0' and column '0': 'The template language function 'formatNumber' expects its first parameter to be an integer or a decimal number. The provided value is of type 'String'. Please see https://aka.ms/logicexpressions#FormatNumber for usage details.'.


    I have put the Format number action in Apply_to_each 2 and just below append array, I have also tried after appending array and the different function...

     

    apenyaranda1985_0-1710832036081.png

    apenyaranda1985_1-1710832046735.png

     

  • Joseph_Fadero Profile Picture
    Joseph_Fadero 666 Power Up Champ - 2025 on 18 Mar 2024 at 19:56:00
    Re: power bi values format

    Hi @apenyaranda1985,

    I trust you are good, in regards to formating the numbers, You can utilize Power FX to format the necessary values you need to populate in the word template,

    In regards to needing one column to store the total of the sum, Can you provide further clarity to aid your request,


    Kindly feel free to like my post and mark as a solution to aids others in the community

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
Announcing our 2025 Season 2 Super Users!
Responsible AI policies for the Community

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Telen Wang – Community Spotlight

We are honored to recognize Telen Wang as our August 2025 Community…

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Tomac Profile Picture

Tomac 986 Moderator

#2
stampcoin Profile Picture

stampcoin 699 Super User 2025 Season 2

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 577 Super User 2025 Season 2

Last month Overall leaderboard

Featured topics

How to Ask for Help with Your Power Automate Workflow

Product updates

Microsoft Power Platform Community release plans