SHOW RESULTS DEPENDING ON THE DROPDOWN SELECTED VALUE

[Gorilla_8]

HEY GUYS,

I HAVE TWO SHAREPOINT LISTS:

THE FIRST ONE:

I HAVE ON THE FIRST LIST:

TITLE (TÍTULO)

MISSIONUNIT

SUBAREADEPARTMENT

AND THE SECOND:

IN THE FIRST LIST IN THE "MISSIONUNIT" COLUMN I HAVE THESE VALUES:

OPTIONS: 

AREA_1

AREA_2

AREA_3

AND IN THE OTHER COLUMN CALLED: "SUBAREA DEPARTMENT"

I HAVE THE SAME VALUES THAT THE COLUMN OF THE SECOND LIST WITH THE COLUMN CALLED "SUBAREA"

AND THEN, I WANT THAT WHEN THE USER SELECTS ANY OPTION IN THE "MISSIONUNIT" COLUMN, SHOW ONLY SOME SPECIFIC RESULTS

LIKE THIS:

IF THE USER SELECTS IN THE "MISSIONUNIT" COLUMN THE VALUE "AREA_1" I WANT YOU TO SHOW ONLY THE VALUES TO SELECT IN THE "SUBAREADEPARTAMENT" COLUMN: "SUBAREA_1.0" AND "SUBAREA_1.1"

AND ALSO THAT SHE ALWAYS PULLS THE VALUES OF THE SECOND LIST, CALLED "DEPARTMENTO"

[v-bofeng-msft]

Hi @Gorilla_8 :

Do you want the options of SUBAREADEPARTMENT to change according to the choice of MISSIONUNIT?

If so, the best way is using custom form.

Set the DataCardValue4(Combo box)'s Items property to :

Filter(
    Choices([@Test5].SUBAREADEPARTMENT), /*Test5 is my list*/
    Value in Switch(
        DataCardValue3.Selected.Value,
        "AREA_1",
        [
            "SubArea_1.0",
            "SubArea_1.1"
        ],
        "AREA_2",
        [
            "SubArea_2.0",
            "SubArea_2.1"
        ],
        "AREA_3",
        [
            "SubArea_3.0",
            "SubArea_3.1"
        ]
    )
)

Best Regards,

Bof

[Gorilla_8]

Hi @v-bofeng-msft ,

Thanks for the response, 

But I want him to pull and filter data from another list, if possible...

I have the first list with the MissionUnit drop...

And...I have the second list with a field called "subarea"...

And so I wanted the MissionUnit field to be filtered and taking the data from the second one and showing it in the first ... Do you understand?

[v-bofeng-msft]

Hi @Gorilla_8 :

Do you want to select MissionUnit in the first list and then modify the subarea options in the second list? What is the logical relationship between the two? What if there are multiple records in the first list and multiple MissionUnits are selected? Could you describe your plan in detail?

Best Regards，

Bof

[Gorilla_8]

Hi @v-bofeng-msft 

Thanks for the help

So, I have a list with a drop-down menu and another list with another drop-down menu...

I want the drop-down menu in the first list to do a conditional filter as you order above, pulling the data from the second list in the first.

Did you get it?

OBS: There is no connection between them, I just want to know if it is possible and how to do it.

[v-bofeng-msft]

Hi @Gorilla_8 :

I'm sorry, I still don't understand what you mean.Could you explain what this sentence means?

pulling the data from the second list in the first

In addition, is the solution I provided previously feasible? If it is not feasible, what are the current difficulties?

Best Regards,

Bof

[Gorilla_8]

Hi @v-bofeng-msft 

Thanks for the help and patience

I want to take data from a dropdown in another SharePoint list, and put a filter from another dropdown in another SharePoint list, that is, I will have:

* Two SharePoint lists
* A custom PowerApps form (Or not, I don't know if you can connect to SharePoint)
* Two dropdowns both with different values

For example, I have a list in SharePoint, called "A" and it has a choice field called "AREA" with the following options:

* area_1
* area_2
* area_3

And I have another list in SharePoint called "B" with a choice field called "SUBAREA" with the following options:

* subarea_1.0
* subarea_1.1
* subarea_2.0
* subarea_2.1
* subarea_3.0
* subarea_3.1

So I want to make a filter in the first list where the field of choice "AREA" filters the options of the field in the second list called "SUBAREA", thus appearing some options depending on the choice in the field "AREA".

Example:

If the user chooses in the "AREA" field that is in the first list "A", the option:

* AREA_1

I want it to have a drop below taking the data from list "B" and showing it in list "A", but with a filter like you did up there.

I hope you understand now.

[v-bofeng-msft · Accepted solution]

Hi @Gorilla_8 :

Please confirm if my understanding is correct:

• You are creating a custom form for list1
• You need to update SUBAREADEPARTMENT in list1 with SUBAREA in list2

If there is no problem with my understanding, then this is easy to solve. 

1)Add a list2 connection

2)modify the code:

Filter(
    Choices([@list2].SUBAREA),
    Value in Switch(
        DataCardValue3.Selected.Value,
        "AREA_1",
        [
            "SubArea_1.0",
            "SubArea_1.1"
        ],
        "AREA_2",
        [
            "SubArea_2.0",
            "SubArea_2.1"
        ],
        "AREA_3",
        [
            "SubArea_3.0",
            "SubArea_3.1"
        ]
    )
)

I don’t know if there is a deviation in my understanding. I don’t know what it means to do so.

Best Regards,

Bof

[v-bofeng-msft · Accepted solution]

Hi @Gorilla_8 :

Is your problem solved? Do you still need help?

If you have found a solution, could you mark it as a solution so that more people can see it.

Best Regards,

Bof