web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Combine Text and Sum

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:

Building Power Apps

I have the same question (0)

All responses Img

All responses (4)

Answers Img

Answers (1)

Sort by

Verified answer

Krishna_R 525 on at

Like
a
(2)

Report
Copy link

Link copied!
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")

Was this reply helpful? Yes No
SBax 1,348 on at

Like
a
(1)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
esjimenezp 485 on at

Like
a
(1)

Report
Copy link

Link copied!

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 👋

Was this reply helpful? Yes No
esjimenezp 485 on at

Like
a
(0)

Report
Copy link

Link copied!

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

Kind regards 👋

Was this reply helpful? Yes No

Join the conversation