You’re offline. This is a read only version of the page.
Announcements
hi i have two list from SharePoint ,requests and employees list,i have powerapps form with data source of requests list inside form i have two custom card with items being
Share
Report employees.'full name'
for both of them im trying to update a field in my request sharepoint list form requests form by setting the onselect and onchange of both custom drop down to
Set(send_dep,LookUp(employees,employees.'full name'=Dropdown2.SelectedText,department))
but i have nothing the variable apparently have value of none no how matter what i do
Request list
employees list
the dropdown i talked about it also i get delegation warning how do i solve
the text input that i apply the value in
thanks
Hi @Anonymous ,
You did not include the Items of the drop-down, but I will assume it is based on the 'full name' column in employees.
If so, this should be Delegable
All responses (
Answers (
153,084
Set(
send_dep,
LookUp(
employees,
'full name'=Dropdown2.Selected.'full name'
).department
)You also need the code in the OnChange (not OnSelect)
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.
