SharePoint Cascading list and setting a value on selection

[asmedic85]

Good Afternoon,

I have built a SharePoint list as a tracker for admin personnel. The tracker is working great but I received a request to make a change and I am struggling just a bit. Right now all the drop downs pull from another SharePoint list I have. 

I currently have 2 cascading drop downs (DropDown44 and DropDown45) and they are working correctly. I have another drop down (DropDown42) that is also working correctly. What I want to happen is when DropDown42.Selected= "N/A" or "No Action "(Choices from DropDown42), I want DropDown45 to change the selection to "Closed". Not 100% sure how to do this, I assume I go to the on Select or on Change part. 

Basically if a work order ticket does not apply and needs no action I want to set the selection of DropDown45 to "Closed"

[v-qiaqi-msft · Accepted solution]

Hi @asmedic85,

Could you please tell me that how you set the Items property of the DropDown42?

Based on the issue that you mentioned, do you want to populate the DropDown45 based on the DropDown42?

Not sure the column type of the column you populate the DropDown42, I assume it is a Choice column.

If the column you populate the DropDown42 is a Choice type, I set the DropDown42 Items as below:

Choices(SPListName.TextColum)

Set the DropDown45 Items as below:

If(DropDown42.Selected.Value="N/A" || DropDown42.Selected.Value= "No Action",
   ["Closed"],
   Put the formula you set based on the DropDown44 here
   )

[asmedic85]

I should have clarified. All three fields are single line text fields in sharepoint. I customized the form using power apps. I change each one of the input type for them to allow choices and then added my other sharepoint list as data source. 

[v-qiaqi-msft]

Hi @asmedic85,

Why not tell me that how you set the Items property of all your three Dropdowns? 

Could you please try to answer all the questions I mentioned before?

What do you mean by "change each one of the input type for them to allow choices"?

Always, a screenshot could be better to clarify your scenario.

Please do provide more details, you should know that all the questions I mentioned is so important to solve your problem, just improve our communication efficiency.
Since all the column are Text, assume that you set the Items of DropDown42 Items as below:

SPListName.TextColum

Set the DropDown45 Items as below:

If(DropDown42.Selected.TextColumn="N/A" || DropDown42.Selected.TextColumn= "No Action",
   ["Closed"],
   Put the formula you set based on the DropDown44 here
   )

[asmedic85]

I have attached screen shots of what the items properties are currently set to. 

When I set up the SharePoint list all three fields are single line of text. I then took that list and customized the form using power apps. In power apps I changed the Control Type of 42,44, & 45 from "Edit Text" to "Allow Values"

After changings the control type to "Allow Values" I set the items as the following:

DataCardValue42 Items: Distinct('ERLR Title and Case Type', Action)

DataCardValue44 Items: Filter('ERLR Title and Case Type', Case_x0020_Status = DataCardValue45.Selected.Result

DataCardValue45 Items: Distinct('ERLR Title and Case Type',Case_x0020_Status)

[v-qiaqi-msft · Accepted solution]

Hi @asmedic85,

Sorry for the late reply, have your solved your problem?

Since you set the Combo Box using the Distinct() function, please modify your formula as bellow.

Set the DataCardValue45 Items:

If(DropDown42.Selected.Result="N/A" || DropDown42.Selected.Result= "No Action",
   ["Closed"],
   Distinct('ERLR Title and Case Type',Case_x0020_Status)
   )

[asmedic85]

Hi Qi,

I tried it the way you recommended and got and error. I tried it another way and got and error also. I have attached screen shots.