I have cascading drop downs issue

(0) Share

Report

Posted on by AP-19120634-0

I have cascading dropdowns called Assign To and Assign To Manager.

When I select a value in Assign To, the Assign To Manager field gets its text value correctly, but it does not save to SharePoint because that column is of Person or Group type.

To handle this, I have set a variable on the OnChange event of the Assign To dropdown:

Then, in the Assign To Manager dropdown, I am setting the value using this selected variable.

Categories:

Building Power Apps

Screenshot 2025-1...

I have the same question (0)

All responses (2)

Answers (0)

developerAJ 4,741 on at

Like (0)

Report

this blog Person Fields – reading and writing options – Practical Power Apps

helps you with the issue

if you are using Form manager data card update property you need to set as

With(
{
withManager: LookUp(
'Sales Employees Group List',
'Employee Email'.Email = DataCardValue26.Selected.Email
)
},
{
Claims: "i:0#.f|membership|" & Lower(withManager.Email),
Department: "",
DisplayName: withManager.'Reporting Manager Name',
Email: withManager.Email,
JobTitle: "",
Picture: ""
}
)

not sure how datasource looks like but in plain words you need to use manager email and displayname in formula

Was this reply helpful? Yes No
Suggested answer

developerAJ 4,741 on at

Like (0)

Report

Above approach should work tag me in case of any issues

Was this reply helpful? Yes No