Unanswered

Gallery Selected Items not pulling correctly in cascading prompts

(0) Share

Report

Posted on by TesDA

611

I have cascading drop downs. The 2nd and 3rd drop downs arent showing the values in the gallery once clicked which I think is because everything is reseting at the same time, so it doesn't yet have the rows it needs to show the correct selection. Any solutions?

Gallery: Gallery3

Form: Emp_Form

Cascade DropDown 1 -LOB_DataCard

Items: Sort('[dbo].[App_ICWO_HCM_Emp_LOB_vps]', LOB_Description)

Default: If( LookUp('[dbo].[App_ICWO_Entry]', ID = varRecord.ID).Request_Type = "PS on Commercial Chargeable" Or
LookUp('[dbo].[App_ICWO_Entry]', ID = varRecord.ID).Request_Type = "PS on Commercial Accountable", "PS", Gallery3.Selected.Resource_LOB_Description)

Cascade DropDown 2 -Title_DropDown

Items: Distinct(Sort(Filter('[dbo].[App_ICWO_HCM_Emp_JobTitle_vps]',LOB_DataCard.SelectedText.Value = LOB_Description), Job_Description), Job_Description)

Default: Gallery3.Selected.Resource_Title

Cascade DropDown 3 -USID_DataCard

Items: Sort( Filter('[dbo].[HCM_Emp]', LOB_DataCard.SelectedText.Value = LOB_Description && Title_DropDown.SelectedText.Result = Job_Description), Empl_Name)

Default: Gallery3.Selected.Resource_Name

Let me know if there is anything else I can provide that would be helpful.

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

Sort by

RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
@TesDA

Consider first changing your formulas to the following:

Title_DropDown : Items:

Sort( Distinct( Filter('[dbo].[App_ICWO_HCM_Emp_JobTitle_vps]', LOB_Description = LOB_DataCard.Selected.LOB_Description ), Job_Description), Result )

USID_DataCard : Items :

Sort( Filter('[dbo].[HCM_Emp]', (LOB_Description = LOB_DataCard.Select.LOB_Description) && (Job_Description = Title_DropDown.Selected.Result) ), Empl_Name )

Take a look at some of the ways I altered this to fit your scenario and let me know if you have questions.

I hope this is helpful for you.

Was this reply helpful? Yes No
TesDA 611 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @RandyHayes , I altered the item values based on what you specified and I'm still getting the same result. LOB_DataCard switches to whatever is selected in the gallery however Title_DropDown and USID_DataCard do not. Any other thoughts?

Was this reply helpful? Yes No