I have a SharePoint listing with a field called 'PowerAppUser' that is a lookup of 'people'
I've run into two issues. I'm trying to do a lookup of the currently logged in use to grab a default value for the app
Set(SelectedCommunity,LookUp(PowerAppUserPreferences,User().Email = PowerAppsUser.Email,DefaultCommunity))
This expression isn't throwing an error but it also isn't bringing back the value. I'm not getting an error on the expression. I've also tried reversing the condition and using the 'in' expression that didn't work either.
Along with that, I'm trying to update that record and I'm getting an error on my expression with regards to the PowerAppsUser field. It is expecting a record rather than text. I'm not sure how to build that expression
{PowerAppsUser:{'@odata.type':"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",Id:[where would I find the Id].ID,Value:User().FullName}}Above is what I think I would use but I'm not sure what source I go against to find the 'ID' of a SharePoint user list - certainly it's not a value that is associated with my PowerUser user? Also, what value should I be passing (Full Name, E-mail, etc.)?
Has anyone else tried this? I searched the community and couldn't find an example.
Thanks!
Tom.