Announcements
Hello,
I need to show all names in People Picker field from different rows (not to repeat)
Based on its number, for example i want to be written in labelMihaela Zlateska, Test Test Thanks in advance,
Mihaela
Hi @Mihaela08zl
You can use the formula Concatenate, that allows you to join both fields, but you must use an additional function that would be addcolum inside that gallery or table, and in that formula addcolum(Concatenate(text1,"",Text2))
If I have answered your question, please mark your post as Solved. If you like my response, please give it a Thumbs Up. You can accept more than one post as a solutionFollow me on Linkedin, I talk about Power Platformwww.linkedin.com/in/jonathan-manrique-rios
Can you be more precise
This will display the the distinct names from the responsible column of your SharePoint list.
Concat(AddColumns(Distinct(YourSharePointList, Responsible), "Name", Value.DisplayName), Name, ", " )
@timl Thank you for your suggestion, but it is still not working... I guess because it is multiple people picker column.. Do you have any other ideas?
hey @Mihaela08zl
can you try this please:
ClearCollect(AllResponsibles, ForAll(YourSharePointList, ForAll(Responsible, {Name: DisplayName} ) ) )
Distinct(AllResponsibles, Name)
Concat(Distinct(AllResponsibles, Name), Name & ", ")
Let me know if my answer helped solving your issue.If it did please accept as solution and give it a thumbs up so we can help others in the community.Greetings
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
WarrenBelz 305 Most Valuable Professional
11manish 212
Valantis 167
