Unanswered

Powerapps cascading dropdowns now showing in View and Edit modes

(0) Share

Report

Posted on by abpw

Hi there,

I have 3 Sharepoint lists: request List which contains dept and div, dept list, and div list. Div list has div name and deptId. One dept can have one or many divs.

My powerapps can save the record into request list without issue. But in the view/edit mode, the selected dept and selected div are not showing up.

I use custom dropdown Data Cards.

Dept_DataCard.Update=Dept_Dropdown.SelectedText.Value

Dept_Dropdown.Items='Departments' //'Departments' is the SL List

I use 'Departments' instead of 'Departments'.Title because division dropdown needs DeptID to lookup the division.

Why do the saved dept and div not showing in view/edit mode?

Thank you in advance.

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (0)

Sort by

WarrenBelz 155,922 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
HI @abpw ,

I assume this is a combo box? Set the DefaultSelectedItems to

{Value:ThisItem.Department}

I am assuming here that Department is the correct name of the field in your table that is to be displayed.

Also replace SelectedText with Selected as the former is a deprecated function.

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
abpw 2 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank Warren. Mine is regular Dropdown not combo box, so there is no DefaultSelectedItems.
The Items property for Department dropdown is SP List ('Departments') and the Items property for Division dropdown is Filter('Division List', DeptID = Dropdown4.Selected.ID)

Was this reply helpful? Yes No
WarrenBelz 155,922 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
@abpw ,

What is the Default of the drop-down - it maybe should be

ThisItem.DeptID

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
WarrenBelz 155,922 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @abpw ,

Just checking if you got the result you were looking for on this thread. Happy to help further if not.

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
v-bofeng-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @abpw :

I am not sure if I understand what you mean correctly, please help me point it out if there are any errors:

There is a dropdown control and it's items property is

Filter('Division List', DeptID = Dropdown4.Selected.ID)

Nothing is displayed in this dropdown control.Something like:

If so,I advice you to check the dropdown control's Value property .Something like:

Best Regards,

Bof

Was this reply helpful? Yes No