Hi @marial16 ,
Do you mean that you set Manager dropdown Items:
Filter(ShowColumns(HotelManagerCol,"Title","DisplayName","Email","Claims"),Title = Hoteldropdown.Selected.Value)
set Manager default selected items:
AssignToUserVar?
Please notice :
1)Manager dropdown Items have these fields: "Title","DisplayName","Email","Claims"
2)Manager default selected items have these fields: "Claims","Email","Title","ID","DisplayName"
It means that you set these two properties to different tables.
You need to set these two properties to the same structure of data.
The person field structure should like like this:
{'@odata.type':"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",
Claims:"i:0#.f|membership|" & User().Email,
Department:"",
DisplayName:User().FullName,
Email:User().Email,
JobTitle:"",
Picture:""
}
It seems that your collection does not meet the requirement.
Please build a collection with these above fields to update your person field.
Try this:
1)OnStart
ClearCollect(
HotelManagerCol,
ShowColumns(AddColumns
(Hotels,"Claims",Manager.Claims,
"Email",Manager.Email,"DisplayName",Manager.DisplayName),
"Claims","Email","Title","DisplayName")
);
2)in the Manager dropdown Items:
DropColumns(
AddColumns(
Filter(ShowColumns(HotelManagerCol,"Title","DisplayName","Email","Claims"),Title = Hoteldropdown.Selected.Value),
"'@odata.type'","#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",
"Department","",
"JobTitle","",
"Picture",""
),
"Title"
)
3)on the OnChange property of the Hotel dropdown
Set(AssignToUserVar,
First(
DropColumns(
AddColumns(
Filter(ShowColumns(HotelManagerCol,"Title","DisplayName","Email","Claims"),Title = Hoteldropdown.Selected.Value),
"'@odata.type'","#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",
"Department","",
"JobTitle","",
"Picture",""
),
"Title"
)
)
)
4) use this variable in the default selected items property of the manager dropdown and the Update property of it's datacard.
If the problem still exists, please show me your data structure of Hotels list and Hoteldropdown's settings.
Best regards,
