web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Using Cascading dropdo...

Power Apps

Unanswered

Using Cascading dropdown it shows error

(1) Share

Report

Report

Posted on by preethi1_suresh

100

Good evening ,

I have two drop downs.

1 drop down for Customer Id from customer entity

customer entity has fields(Customer Id, name)

2 drop down For Project Id , i am loading project Id relevant to customer Id.

The column Project is from project entity.

items property for project id drop down:

ShowColumns(Filter(Projects,CustomerAccount = dropdown1.Selected.CustomerAccount && 'Project stage'="Inprocess"),"ProjectID","ProjectName")

But i got this issues

Please give solution to me

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (0)

Sort by

Drrickryp Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!
@preethi1_suresh

Is this Dataverse or some other connector? If it is Dataverse, there may be an easier way to do it, particularly if the relationship between the tables has been created. If it is SharePoint, the CustomerID should be the foreign key in your Projects table. You can simplify your filter as follows.

Filter(Projects,CustomerID = dropdown1.Selected.CustomerID)

There is no need to use ShowColumns() as you can select the column to show in the window. Further filtering depends on the column type for 'Project stage'. (ie. Choice, Single line of text, Lookup)

Was this reply helpful? Yes No
preethi1_suresh 100 on at

Like (0)

Report
Copy link

Link copied!

Thanks @Drrickryp ,it is Not dataverse and Sharepoint connector, it is Fin & Ops connector,
I used the solution which you recommend me , but it doesn't suits my criteria it shows the same error.

please help me @Drrickryp

Was this reply helpful? Yes No

Join the conversation