Hello -
I am building a multi-screen power app based on a SharePoint list DataSource and I have an issue that I'm hoping someone can help me with...
The form control in question is a choice column in SharePoint. Here are the choices:
- Legal right of re-employment (e.g., following maternity or parental leave)
- Return from approved leave of absence (e.g., reinstatement guarantee, sabbatical
- Return of expatriates to their home country according to their Development Plan
- Priority of placements because of agreements with employee representatives
- Extensive departmental or divisional reorganizations that are approved by the responsible management (e.g. redeployments pools) – (this is also a deployment)
- Summer hires, interns, co-ops, trainees and other temporary positions
- Extension of contracts as well as takeover from temporary employment in the same position
- Post-doctoral positions
- All Project Manager positions with defined, time limited project assignments
- Short-term assignments (posting optional)
- Placement of trainees at the end of formal trainee programs
- Transfers that are intended to avoid the potential layoff or termination of qualified employee – (if it’s a potential layoff, this is also a deployment scenario)
- N/A
Here is how this looks in my PowerApp:
Here is what I want to happen -
If Type of Request Validation reads "Posting Exception, Approvals Not Required", I want all of the choices in DataCardValue17 to show up (they are all of the choices in the choice column listed above). If Type of Request Validation reads anything else, I want "N/A" to be the only choice.
The formula that I started to use in the items property for DataCardValue17 is included in the screenshot - this is not working.
Any other ideas on how I can get this to work?
Thank you!