Power Platform Community Forum Thread Details

Hi I ´m building an App to display and edit user permissions. I´m using excel in the POC and the tables look like this:

Table1 (User)	cardenality	Table2 (UserPermissons)	cardenality	Table3 (Permissons)
	1---*		*---1
UserID (unique)		UserID		PermissonID (unique)
UserName		PermissonID		PermissonName

I´m trying to display UserName and PermissonNames associated with that user in a Gallery. I can get username and associated permissionIDs but when I try to add PermissionName things don´t look so god : (

This is my latest code

Concat(Nämnd,Filter(Behörighet,BehörighetId=NämndId, BehörighetId in Filter(Behörighet,AnvändarId=ThisItem.AnvändarId).BehörighetId),Benämning

Any ideas?

Best regards Måns

Categories:

Building Power Apps