Textbox is showing 1 instead of 100

(0) Share

Report

Posted on by 1RiverJK77

Hello,

I am trying to Sum the budget numbers out of budget number string as shown on the picture.

the result textbox show 1 instead of 100. This ends up storing the value 1 in my SharepointList column called %. I need it to show 100 in the result textbox so that it stores in the % column as 100.

Here is my code: Sum( Filter(Mid( Split(DataCardValue10.Text,Char(10)),16,17),!IsBlank( Result)),Result)

What do I need to adjust so that result shows as 100 instead of 1?

Thank you

Categories:

Building Power Apps

Screen.JPG

I have the same question (0)

All responses (8)

Answers (1)

Verified answer

WarrenBelz 153,084 Most Valuable Professional on at

Like (0)

Report
Hi @1RiverJK77 ,

You only need two characters

Sum( Filter( Mid( Split( DataCardValue10.Text, Char(10) ), 16, 2 ), !IsBlank(Result) ), Result )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No
1RiverJK77 60 on at

Like (0)

Report

Thank you. It works

Was this reply helpful? Yes No
1RiverJK77 60 on at

Like (0)

Report

Also since you provided the solution. In continuation of this, in my Power Automate, I have Power Automate email that sends the submitted information from my app. The issue is how can I split budget entries to show in two or more lines when email sent out via Power Automate.
in the body of the email budget entry line shows as one line as shown in the attachment. Need to show the second entry below of the first entry.
Thank you for your help

Linebreak_needed.JPG

Was this reply helpful? Yes No
WarrenBelz 153,084 Most Valuable Professional on at

Like (0)

Report
Hi @1RiverJK77 ,

You can send directly from Power Apps with Office365Outlook.SendEmailV2() as below as part of the body. You can also send this as the content to a Flow if you are using that.

"Budget Numer Percentages - & Substitute( DataCardValue10.Text, Char(10), " " ) & " Total of Budget Percentage" & YourLabelName.Text

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No
1RiverJK77 60 on at

Like (0)

Report

I am using a an email flow. So this how the email flow is and the result still not showing correctly in the email content. Break line is not happening.
Attached: Email_Content--Shows when received email still no line break and the word Substitute shows in the line as well.
Email_Flow_Content --- is my email flow code.

Am I placing your code not correctly? Thank you for your help.

Email_Content.JPG

Email_Flow_Conten...

Was this reply helpful? Yes No
WarrenBelz 153,084 Most Valuable Professional on at

Like (0)

Report

@1RiverJK77 ,

That code is for Power Apps, not Flow - I was simply suggesting you could send it direct using Power Apps. In the Flow, you just need to add the String " " where you want the break.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No
1RiverJK77 60 on at

Like (0)

Report

yes. but , is till not seperating the string in the multiLine text:
10-94-20-70023 90%
10-94-20-70024 10%
I need it to show as the one above in the email content my email flow sends out.
This entry in the multiline text comes out 10-94-20-70023 90% 10-94-20-70024 10% in the email content and putting is not doing anything.
Any ideas?

Was this reply helpful? Yes No
WarrenBelz 153,084 Most Valuable Professional on at

Like (0)

Report

Hi @1RiverJK77 ,

This document may be of assistance - I have however never used the function for this purpose.

Was this reply helpful? Yes No