Power Platform Community Forum Thread Details

Hi i have a list - gadgetRequest which contains 2 lookup columns department and subDepartment (department and subDepartment (are 2 lists, subDepartment list and gadgetRequestt has department as lookup column) . In the form that i have built, the subDepartment's value is dependent on the department value(eg if we choose laptop as department, we get option of laptop brands in the subDepartment, if we choose mobile phone as department, then we get option of mobile brands in the subDepartment, etc)

The Items field of subDepartment dropdown are filtered by using the formula :

Filter(SubDepartment, Department.Value = dropDownDepartment.Selected.Value).Title

(Title column in the subDepartment List contains the name of subDepartment

Now i want to patch result of SubDepartment ot the gadgetRequest List, for which i am using the formula

SubDepartment:{

'@odata.type': "#Microsoft.Azure.Connectors........"

Id: Lookup(SubDepartmentList, dropdownSubDepartment.Selected.Title=Title, ID},

Value: dropdownSubDepartment.Selected.Title

}

The value field works as i am able to see the Value on selecting that line, but i am not able to get the id, as it shows nothing on selecting the line, please suggest a correct solution.

Thanks in advance.

@Meneghino

Categories:

Building Power Apps