web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Still having trouble d...

Power Apps

Answered

Still having trouble displaying Office365UserPhoto

(0) Share

Report

Report

Posted on by bobgodin

380

Hi Rob sorry to open this one up again: Solved: Re: Having trouble displaying the correct Office36... - Power Platform Community (microsoft.com) but my datasource has been refreshed and I now have to cater for records like this:

WARREN ANDREWS ; Louis Gettings ; * * ; * * ; * *

the code I have currently caters for a double space or a semi-colon between names - I now need to add the 2 asterisks separated by a space

here's my code:

If(
!IsBlank(ThisItem.Title),
Office365Users.UserPhoto(
LookUp(
MyDetails,
Switch(
CountRows(
Filter(
Split(
Title1.Text,
""
),
Result = ";"
)
),
0,
First(
Split(
Title1.Text,
" "
)
).Result,

First(
Split(
Title1.Text,
" ; "
)
).Result
) in Lower(firstname & " " & surname),
email
)
)
)

I have tried adding another Split but it doesn't like my syntax - any assistance would be greatly appreciated

Categories:

Building Power Apps

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

TheRobRush 11,128 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
are the * * always separated from previous name in the string by a ; semicolon as in your example "WARREN ANDREWS ; Louis Gettings ; * * ; * * ; * *"? Because the original split would still work just fine to pull the first name in that string shown, plugged it into our original formula that determines first name just to be sure

Switch( CountRows(Filter(Split(Label7.Text,""),Result=";")), 0, First(Split(Label7.Text, " ")).Result, First(Split(Label7.Text, "; ")).Result)

with the string referenced above, the result is still

Warren Andrews as expected.

Join the conversation