Skip to main content

Notifications

Power Apps - Building Power Apps
Answered

Show calculation of only visible fields in PowerApps Form

(0) ShareShare
ReportReport
Posted on by 271
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!
  • Verified answer
    cfoenki Profile Picture
    cfoenki 95 on at
    Show calculation of only visible fields in PowerApps Form
    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

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,343

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,703

Leaderboard