web

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

News and Announcements icon

Power Platform CommunityForums Power Apps Check for null value i...

Power Apps

Unanswered

Check for null value in calculated column

(0) Share

Report

Report

Posted on by sooraj_07

8

I am calculating 2 fields to set the 'Overall Recharge Costs'.

But the 'Overall Recharge Costs' field is not populating as the 'Total Recovered' field is null.

Could someone please explain the procedures for checking the null value and counting it as 0 if it is null?

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (0)

Michael E. Gernaey 53,963 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
@sooraj_07

Are you asking how to check in your app and then have it display 0 instead of , well whatever?

Firstly, Calc columns dont work well in Power Apps.. But try these just for sanity for you in the Text/Default property of your label or whatever

If(IsBlankOrError(TheCalcField), "0", TheCalcField)

If I have helped you, I would really appreciate if you please Mark my answer as Resolved/Answered, and give it a thumbs up, so it can help others

Cheers

Thank You
Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
https://gernaeysoftware.com
LinkedIn: https://www.linkedin.com/in/michaelgernaey

Was this reply helpful? Yes No

Join the conversation