News and Announcements icon

Power Platform CommunityForums Power Apps - Building Power Apps Combine Text and Sum

Power Apps - Building Power Apps

Answered

Combine Text and Sum

(0) Share

Report

Report

Posted on by esjimenezp

485

Hi Community,

I will like to add the next formula to Default property, but the field is give me an error, the intention is to get the sum of two fields.

Text(
 varStatusReport.EndofYearEstimate, "[$-en-US]$#,##.00", sum(txt_ActualCostToDate + txt_LeftToDo))

Kind regards 👋

Categories:

Using Apps Using Formulas

All responses Img

All responses (4)

Answers Img

Answers (1)

esjimenezp 485 on at

Like (0)

Report

Re: Combine Text and Sum

thanks @SBax I will for my next formulas into my apps, I really appreciate your comment, thanks.

Kind regards 👋
esjimenezp 485 on at

Like (1)

Report

Re: Combine Text and Sum

Awesome @Krishna_R the intention of the varStatusReport.EndofYearEstimate is to get the value from the SharePoint list when the user select the item from the Gallery, thanks for your help 😎

Kind regards 👋
SBax 1,348 on at

Like (1)

Report

Re: Combine Text and Sum

By the looks of it you have multiple formulas in here, try separating the formulas with & symbols
Verified answer

Krishna_R 525 on at

Like (2)

Report
Re: Combine Text and Sum

Hi @esjimenezp

what is varStatusReport.EndofYearEstimate here ?

If the intention is only to add two fields try below

Text(Value(txt_ActualCostToDate.Text) + Value(txt_LeftToDo.Text),"[$-en-US]$#,##.00")