I have a Horizontal Gallery displaying Office 365 User Profile Pictures.
I want to display only the 3 first Office 365 User Profile Pictures from a collection collected from a dataverse table.
And if the collection have more than 3 records, I want an icon displaying +5(the count of the remaining participants in the collection).
How I want it to look is displayed in the attched screenshot.
I have attempted using the following formula: for the first picture:
If(!IsBlank(First(ThisItem.UPN), Office365Users.UserPhotoV2(First(ThisItem.UPN)))
But then I receive the error "Expecting a Table Value instead". I do not understand why I get this error? The Collection is a Table?
I use the following formula now:
If(!IsBlank(ThisItem.UPN),Office365Users.UserPhotoV2(ThisItem.UPN))
This formula works, but its displaying all the Office 365 User Profile Pictures that exist in the collection not only the three first photos.
How should I write the formula in the Image-component within the gallery to display the first, the second and the third Office 365 User Profile Picture from the collection?
Solved! Go to Solution.
I would filter the Items property of the gallery to only have three items using FirstN, and then for your +X label have something like
Visible:
CountRows(datasource)>3
label text for the +X part
"+" & (CountRows(datasource)-3)
@iAm_ManCat |
Please 'Mark as Solution' if someone's post answered your question and always 'Thumbs Up' the posts you like or that helped you! |
Thanks! |
I would filter the Items property of the gallery to only have three items using FirstN, and then for your +X label have something like
Visible:
CountRows(datasource)>3
label text for the +X part
"+" & (CountRows(datasource)-3)
@iAm_ManCat |
Please 'Mark as Solution' if someone's post answered your question and always 'Thumbs Up' the posts you like or that helped you! |
Thanks! |
Thank you @iAm_ManCat! This worked out perfectly.
I used FirstN(Collection,3) in the items gallery
Excellent, glad I could help 🙂
@iAm_ManCat |
Please 'Mark as Solution' if someone's post answered your question and always 'Thumbs Up' the posts you like or that helped you! |
Thanks! |
User | Count |
---|---|
258 | |
111 | |
95 | |
48 | |
41 |