web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Show calculation of on...
Power Apps
Answered

Show calculation of only visible fields in PowerApps Form

(0) ShareShare
ReportReport
Posted on by 669
Hi,
 
Within PowerApps form I've added around 50 fields.
 
From this 50 fields, particular fields are visible based on the Customer Name we are selecting
 
For e.g. I have a drop down as Customer Name. Say the user selects Apple as the Customer 7 fields become visible. I have one more column for which we need to have Submission of the visible fields.
 
Now when Apple is selected, user enters the values for all the 7 visible fields, so we need to have submission of this only 7 fields into the Submission column.
 
Secondly if Customer Name is selected as Samsung, 2 fields become visible. User enters the values for this 2 visible fields, so we need to have submission of this only 2 fields into the Submission column.
 
Currently my form is displaying submission of all fields, whether they are visible or not.
 
I also have a Gallery within my form. So when we select a particular Customer, Submission should show only for the selected Customer.
 
Any ideas how can we achieve this. Thanks!
Categories:
I have the same question (0)
  • Verified answer
    cfoenki Profile Picture
    100 on at
    I'm not sure of what you would like to achieve here.
    If you submit a form with fields invisible but blank it will be registered as blank in your SP list just as if the fields were not submitted.
     
    Or maybe you are talking about reseting the field to blank value when changing your customer?
    In that case, you just have to add something in the Default property of your field like:

    If(Self.Visible=false,Blank(),Parent.Default)

    Or adding a reset variable inside of your customer name "OnChange" property passing it to true then to false

    UpdateContext({var_reset_fields:true});
    UpdateContext({var_reset_fields:false})
    Then on the "Reset" property of each field put:

    var_reset_fields



Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 525 Most Valuable Professional

#2
Haque Profile Picture

Haque 308

#3
Kalathiya Profile Picture

Kalathiya 234 Super User 2026 Season 1

Last 30 days Overall leaderboard