Power Platform Community Forum Thread Details

Hello,

Patching a record in a SharePoint list. When I tried to make a dropdown dependent on another (Team and Sub Team) the Patch stopped updating for that column in SharePoint. Does anyone have an idea of what has gone wrong and how to fix it.

Items Property of dropdown is:

If(UpdatePrimaryTeamValue.Selected.Value=Blank(),Blank(),
ForAll(Distinct(Filter(SubTeamMapping,Team=UpdatePrimaryTeamValue.Selected.Value),SubTeam), {Result: ThisRecord.Value}))

This generates the list properly. I used excel table as an additional data source to hold the mappings between the two.

Patch is in a button. OnSelect value is:

Patch('Project Roster',varFormUpdate,Form_UpdateExistingEntry.Updates);

If(IsEmpty(Errors('Project Roster')),Notify("Success",NotificationType.Success);

Navigate('Landing Screen'),Notify(First(Errors('Project Roster')).Message,NotificationType.Error))

Activating the button updates all other fields except the SubTeam.

In SharePoint. SubTeam is a choice column. Selections match the excel. It is required and does not allow fill in options.

Thanks!

Categories:

Building Power Apps

Hi @JFudali ,

Your issue I believe is the output of the sub-team combo box (which is .Result, but that pattern was deprecated some time ago) and you can output the required .Value like this

If(
 UpdatePrimaryTeamValue.Selected.Value = Blank(),
 Blank(),
 Distinct(
 Filter(
 SubTeamMapping,
 Team = UpdatePrimaryTeamValue.Selected.Value
 ),
 SubTeam
 )
)

NOTE I have assumed that SubTeam in SubTeamMapping is a Text column and a Choice column in 'Project Roster'

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.

MVP (Business Applications) Visit my blog Practical Power Apps