Unanswered

dropdown depend on another dropdown

(0) Share

Report

Posted on by Abhilash M abi

106

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..

Categories:

Building Power Apps

I have the same question (0)

All responses (11)

Answers (0)

Sort by

eka24 20,925 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Abhilash M abi 106 on at

Like (0)

Report
Copy link

Link copied!

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...

Was this reply helpful? Yes No
eka24 20,925 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
askondo Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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')

Was this reply helpful? Yes No
Abhilash M abi 106 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
eka24 20,925 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Abhilash M abi 106 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
eka24 20,925 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Abhilash M abi 106 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
WarrenBelz 154,930 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hi @Abhilash ,
Try
Distinct( Filter( 'Check Points', 'Major point'.Value=DataCardValue22.Selected.Value ), 'Check Point' )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No