Skip to main content

Notifications

Power Apps - Building Power Apps
Unanswered

One form or multiple?

(0) ShareShare
ReportReport
Posted on by 9

I am working on creating an "Intake" form in Power Apps for a department that has 5 different teams.
There are 11 questions/fields that are common to all teams, one field allows the user to select the team to assign the intake item to.
Each team has a unique set of fields.

 

I was requested to open the form displaying the common fields, then when the user selects the team, the team specific fields are displayed. Everything is saved to a single SharePoint list.

 

Currently, I have a single form containing about 100 fields. The 11 common fields, plus the team specific fields.
I was thinking that I would hide/show data cards using "Visible = If(".
This does work but I get a lot of errors: "Incompatible Types for comparison. These types can't be compared: Error, Boolean".
Something I have not tested yet is if a 'hidden' field is a required field, will I get an error on saving?

 

My question - is this a sound approach or should I be using separate forms for each team?
When a user fills in the 11 common fields, selects a team and clicks 'Next', it opens the team specific form?

I wasn't sure if using multiple forms would be impacted saving to a common List. (Affecting issues with reporting

 

Thanks in advance for your thoughts.

  • RandyHayes Profile Picture
    RandyHayes 76,287 on at
    Re: One form or multiple?

    @mwyller1 

    In general, you can use one form for all of this.  Setting the visible property of datacards is a good approach.  Having any fields required at the datalist level, is a bad idea!  

     

    You can, however, augment the primary form with sub forms.  The concept is based on splitting a form properly.  You can learn more about that in this video.  The concept would only change because you would display a subform as specific to the team that you want to display.  But there would still be one master form.

     

    I hope this is helpful for you.

  • Nogueira1306 Profile Picture
    Nogueira1306 7,390 on at
    Re: One form or multiple?

    Here:

     

    https://www.youtube.com/watch?v=s391rMNRbmA

     

    Check that form.

     

    If you need additional help please tag me in your reply and please like my reply.
    If my reply provided you with a solution, pleased mark it as a solution ✔️!

    Best regards,

    Gonçalo Nogueira

    Check my LinkedIn!

    My website!

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,445

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,741

Leaderboard