Thanks for the video, this is helpfull. ¿Where can I find the information about all 2nd and 3th parameters type that can be use in the expression FormatNumber?
Hello! Thanks for this video. :) I've been stuck for two days now trying to have the % format in my email (value coming from an excel cell which appears in decimal). Would you be able to help on that one? Thanks!
I am trying to change a date format with an expression for my flow but my date does not show in the proper format. I get the year and the month, but not the day. any suggestions
Thank you for that video! I'm currently stuck trying to get the '%' format in my email from my excel value which appears in decimals. Would you be able to help on that one? Thanks in advance!
Thanks for the valuable work. I will have a request, I know it is possible, but I do not know the method. I want to send an e-mail by adding the person profile picture in the person column in the SharePoint list, which creates an html card. I'm trying to do this somehow, but the profile picture is not showing. Is it possible to do a study on this? thanks
Hello, thanks for the video. In my case I use the formatnumber to convert 0.00 to 0,00 (pt-BR). But when a field there is no number (blank) an error appears in Power Automate. Do you know how to solve this issue? Tks
I would add a condition into the expression to test if there is a value or not to convert, and state that if there is no value it should simply leave a blank space. Try something like: If( empty( {your dynamic content}, ' '), formatNumber( {your dynamic content}, 'C2', pt-BR))
@@fernandolemos9910 Boa tarde Fernando, tudo bem? Eu estava com o mesmo erro e encontrei o problema, era na minha expressão, ve se isso te ajuda, eu estava colocando a expressão dessa forma => formatNumber(item()?['MEDIDA'],'F2',pt-BR'), e o correto é assim formatNumber(item()?['[MEDIDA]'],'F2','pt-BR'), tem um colchetes junto na medida, isso resolveu meu problema, qualquer coisa pode me contatar.
Thanks for the video, this is helpfull. ¿Where can I find the information about all 2nd and 3th parameters type that can be use in the expression FormatNumber?
Hello! Thanks for this video. :) I've been stuck for two days now trying to have the % format in my email (value coming from an excel cell which appears in decimal). Would you be able to help on that one? Thanks!
I am trying to change a date format with an expression for my flow but my date does not show in the proper format. I get the year and the month, but not the day. any suggestions
Thank you for that video! I'm currently stuck trying to get the '%' format in my email from my excel value which appears in decimals. Would you be able to help on that one? Thanks in advance!
I have the same problem, were you able to solve it???
Thanks!
Thanks for the valuable work. I will have a request, I know it is possible, but I do not know the method. I want to send an e-mail by adding the person profile picture in the person column in the SharePoint list, which creates an html card. I'm trying to do this somehow, but the profile picture is not showing. Is it possible to do a study on this? thanks
Hello, thanks for the video. In my case I use the formatnumber to convert 0.00 to 0,00 (pt-BR). But when a field there is no number (blank) an error appears in Power Automate. Do you know how to solve this issue? Tks
I would add a condition into the expression to test if there is a value or not to convert, and state that if there is no value it should simply leave a blank space. Try something like: If( empty( {your dynamic content}, ' '), formatNumber( {your dynamic content}, 'C2', pt-BR))
@@Jonathon_Silva thanks for your answer. Empty may not work because when there is no information it consider as null
Bom dia Fernando, tudo bem contigo? Você conseguiu resolver esse problema? Pois estou enfrentando a mesma dificuldade.
Abraços
@@MauricioLuísdeOliveiraReis ainda não
@@fernandolemos9910 Boa tarde Fernando, tudo bem? Eu estava com o mesmo erro e encontrei o problema, era na minha expressão, ve se isso te ajuda, eu estava colocando a expressão dessa forma => formatNumber(item()?['MEDIDA'],'F2',pt-BR'), e o correto é assim formatNumber(item()?['[MEDIDA]'],'F2','pt-BR'), tem um colchetes junto na medida, isso resolveu meu problema, qualquer coisa pode me contatar.
i need it formatted as year-month-day (yyyy-mm-dd) but I am only getting the year and month. the day shows up as 00