dropdown depend on another dropdown

[Abhilash]

i'm trying to filter dropdown items.. 1st dropdown consist of majorpoint which is related to checkpoint table's majorpoint.. now i need to display only checkpoints which belongs to major point selected in 1st dropdown...

i tried below formula but i'm getting error in = symbol saying that invalid argument...

formula : Distinct(Filter('Check Points','Major point'=DataCardValue22.Selected.'Major Point ID'),'Check Point')

please help me.. 

[eka24]

What is the relationship between the major point and major point Id, are the the same?

Distinct(Filter('Check Points','Major point'=DataCardValue22.Selected.'Major Point ID')),'Check Point')

Distinct(Filter('Check Points','Major point' in DataCardValue22.Selected.'Major Point ID'),'Check Point')

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

[Abhilash]

Yes, major point and major point id are the same.. major point in check point table represents foreign key to major point id in major point table..

when i used "in" instead of "=" then major point id is marked as error...

[eka24]

Can you show what you have on the first dropdown DataCardValue22

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

[askondo]

Can you write the following formula? Does this solve the error?

Distinct(Filter('Check Points','Major point'.'Major Point ID'=DataCardValue22.Selected.'Major Point ID')),'Check Point')

[Abhilash]

i tried your sugession.. no errors but it is not displaying any data in 2nd dropdown

[eka24]

Can you show what you have on the first dropdown DataCardValue22 (formula on the Dropdown)

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

[Abhilash]

Choices([@'Assign Tasks'].systvs_Majorpoint) this is formula on 1st dropdown

[eka24]

There should be a relationship between the tables in the first and the second table.

First Table:

Choices([@'Assign Tasks'].systvs_Majorpoint)

Second table:

Distinct(Filter('Check Points','Major point'=DataCardValue22.Selected.'Major Point ID'),'Check Point')

Can you try:

Distinct(Filter('Check Points','Major point'=DataCardValue22.Selected.systvs_Majorpoint),'Check Point')

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

[Abhilash]

tried with your suggesson... again "=" is showing error invalid argument type