Power Apps cascading form not updating to Sharpeoint list

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi,

My Power Apps form looks like below:

The column Department and Dept_Approver are look up columns and they are both combo boxes. When choosing a group in Department, it displays the approvers within the selected department.

The form currently displays users when a particular department is selected, but my Sharepoint list doesnt get updated with the selected user. The Sharepoint list gets updated for the Department.

The update property of the Dept_approver DATACARD LEVEL (Datacardvalue5) is set to {Value:DatacardValue5.selected.Result}

Default is set to Thisitem.Dept_Approver

The defaultselecteditems for Dept_Approver combo box is set to {Result:ThisItem.Dept_Approver.Value}

I'm not sure what I'm missing in here. Please help

Categories:

Building Power Apps

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

v-jefferni Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @arake412 ,

I assume both Department and Dept_approver are text columns in the other two lists (Departments and Approvers), to update the LookUp column, both Id and Value are required by the Update property. So please modify the formula as below:

{ Id:LookUp(ApproversList,Approver = DatacardValue5.selected.Result).ID, Value:DatacardValue5.selected.Result }

Best regards,

Was this reply helpful? Yes No