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

Notifications

Announcements

Welcome to the Power Platform Communities
Sign Up for Ask a Community Pro Today!
Share your business problems and get Power Platform leaders' perspectives!
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 Prem4253 652
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:
Building Power Apps
I have the same question (0)
  • Verified answer
    cfoenki Profile Picture
    cfoenki 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

News and Announcements

Welcome to the Power Platform Communities
Sign Up for Ask a Community Pro Today!
Share your business problems and get Power Platform leaders' perspectives!

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the December Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
Kalathiya Profile Picture

Kalathiya 321 Super User 2026 Season 1

#2
WarrenBelz Profile Picture

WarrenBelz 289 Most Valuable Professional

#3
MS.Ragavendar Profile Picture

MS.Ragavendar 200 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Auto-Populate field Power Pages
Gallery Tabs - Show or Hide Tabs based on Field Value
How to patch multiple records at once
Enable Copilot for end users in model-driven apps
Question for everyone : How are you using Create Text GPT in AI Builder?
Community content - sample components, blogs etc. - Link to this page (http://aka.ms/PCFdemos)
Welcome to the Power Apps forum!

Product updates

Microsoft Power Platform Community release plans