Calculated field

[VladGeorgescu]

Hello Power Apps Comunity

I am very new to PowerApps, I'd like some support if possible please?

I need to have a calculated field to display mandatory trininngs bease on the selection of 1 or multiple roles?

For example i have field A multiselect dropdown with values Role 1, Role 2, Role 3, Role 4, Role 5....then field B multiselect calculated with value Training 1, Training 2, Training 3, Training 4, Training 5 ; i need corelation between both, to list in field B values based on selection in field A.

One important aspect is that a role may have 1 or multiple traininigs for example Role 1 only needs Training 1 same goes for Role 2, on the other hand for Role 3 we need Training 1, Training 2, Training 3, Training 4

BR

Vlad

[EddieE · Accepted solution]

@VladGeorgescu 

How is your data setup? We need some examples before we can help with this.

Also, how to you want to present your calculated field, for example, as a label, in a gallery, etc??

[VladGeorgescu]

Thanks EddieE for your comment.

So i have a blank simple SharePoint list on which i am using PowerApps to configure the fill in form.

I am not sure what would be simpler to present the calculated field; i guess as a label....but i am opened to other ways. i tried with 'If' based on text but does not seem to work?!

[Roberto_el_Hajj]

Hey @VladGeorgescu, to use the Sharepoint and Office 365 connectors in Power Apps, you will need a Power Apps plan that includes these connectors. Here are some options:

1. Power Apps Per App Plan: This plan allows you to create and run a single custom business app. It includes access to the Common data service, premium connectors, and the ability to use custom connectors. This plan does not include the SharePoint and Office 365 connectors.

2. Power Apps Per User Plan: This plan allows you to create and run unlimited custom business apps. It includes access to the Common Data Service, premium connectors, and the ability to use custom connectors. This plan also includes the SharePoint and Office 365 connectors.

3. Office 365 Enterprise E5 Plan: This plan includes access to the full suite of Office 365 applications, including SharePoint an Outlook, as well as Power Apps and Power Automate (formerly known as Microsoft Flow).

You can compare the features and pricing of these plans on https://powerapps.microsoft.com/en-us/pricing/  to determine which plan best meets your needs. Note that pricing may vary depending on your location and other factors, so be sure to check the pricing details for your specific situation.

[VladGeorgescu]

Hi Roberto_el_Hajj,

For now i simply asked the community via free forum for a solution or idea about my situation.

I am not interested in any paid subscription at this time since i may not use PowerApps altogether; howvere will consider this in the future and buy a subscription at the later date

[EddieE]

@VladGeorgescu 

I'm still unsure of what you are trying to achieve, sorry.

Maybe this will give you some ideas? 

1. Add a button with this OnSelect code

ClearCollect(
    colTrainingRoles,
    {Role: "Role 1", Training: "Training 1"},
    {Role: "Role 2", Training: "Training 1"},
    {Role: "Role 3", Training: "Training 1"},
    {Role: "Role 3", Training: "Training 2"},
    {Role: "Role 3", Training: "Training 3"},
    {Role: "Role 3", Training: "Training 4"},
    {Role: "Role 4", Training: "Training 4"},
    {Role: "Role 4", Training: "Training 5"},
    {Role: "Role 5", Training: "Training 2"},
    {Role: "Role 5", Training: "Training 5"}
)

2. Add a Dropdown control, rename it to ddRole. Add this code to its Items

Distinct( colTrainingRoles, Role)

3. Add a vertical gallery and set its Items to

Filter( colTrainingRoles, Role = ddRole.Selected.Value )

This short demo will give you an insight into how you can manipulate your data, you just need to work out how to apply it to your required solution.

I'm happy to help further if needed.