Unanswered

Error in the value for calculated column in the Approval request

(0) Share

Report

Posted on by luvcoelho

Hello guys,

I have built this flow with these calculated columns in my SharePoint, and I am having these funny extra zeros that are messing with my approval conditions when sending the approval request:

I have these fields in my power app form, and it had the same error as above, however I did search it here and added the following formula and its fixed now in the power app. But I still have the same issue in the approval request detail:

The formula for the calculated column is this one:

And the formula I added to power apps is this one:

Do you know how I can fix it in my approvals? It looks okay in my SharePoint list and in the Form, however in the email I still see all these 00000000

Thank you very much in advance!

Categories:

General topics

I have the same question (0)

All responses (7)

Answers (0)

annajhaveri 8,531 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@luvcoelho you can use format number action in power automate https://powerautomate.microsoft.com/en-us/blog/simplified-number-formatting/

Was this reply helpful? Yes No
luvcoelho 10 on at

Like (0)

Report
Copy link

Link copied!

Hello Anna,

thank you very much for reaching out. I added this action to my flow, however I still have the same issue...
I believe it's because it's a calculated value from the SharePoint list?

Was this reply helpful? Yes No
annajhaveri 8,531 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@luvcoelho did you use the calculated value as input in the Format Number action and used the output of Format Number in approval action?

Was this reply helpful? Yes No
luvcoelho 10 on at

Like (0)

Report
Copy link

Link copied!

Hi @annajhaveri , how do I do it?

Was this reply helpful? Yes No
annajhaveri 8,531 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
@luvcoelho use below expression in format number action, replace Test1 with your calculated column name
float(outputs('Get_item')?['body/Test1'])

It should look like below:

Use Formatted Number in your approval action content from Dynamic content

Was this reply helpful? Yes No
luvcoelho 10 on at

Like (0)

Report
Copy link

Link copied!

Hi Anna,

Thank you very much for your help. The formatting of the request is fixed, however now my number formatting is triggering wrong qty.

In this flow below, I want to trigger only the items less than 25000, however its triggering everything:

Thank you very much!!!

Was this reply helpful? Yes No
annajhaveri 8,531 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@luvcoelho i would suggest to add compose action just above the condition action. In compose action, select the column from dynamic content that you are using in condition for comparision with 25,000. And then run the flow and see the value in compose action, that will give you an idea why condition is not working.

Was this reply helpful? Yes No