Power Platform Community Forum Thread Details

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!

Categories:

Building Power Apps

Your drop down or combobox needs an collection (array) of choices, a single string like "N/A" is not acceptable for the Items property.

Assuming "N/A" is a valid option in your Choice Column Option Set, try this:

(be careful, I just typed this off your image, might contain typos)

If(

'Type of Request Validation'.Text = "Posting Exception, Approvals Note Required",

Choices([@'Deployment/Posting Exceptions Request'].'Posting Exception (Approvals Not Required)'),
Filter(Choices([@'Deployment/Posting Exceptions Request'].'Posting Exception (Approvals Not Required)'), Value = "N/A")
)

The idea is that your default should be a filtered Choices collection where Value = "N/A".

If this helps, give this response a like and mark it as an answer, thanks!