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.
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.
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!