Forum Discussion

PerfPC's avatar
PerfPC
Copper Contributor
Feb 17, 2022
Solved

PowerApps Profile Pic IF statement

Hi All,   I've currently got a SP list with a people field showing the users profile picture. In PowerApps I've a gallery to display all my columns including the profile picture with the below code...
PowerApps
sharepoint
  • ekarim's avatar
    ekarim
    Feb 18, 2022

    PerfPC 

    Office365Users.UserPhotoMetadata().HasPhoto

    will return true or false. You can use this in an If condition:

     

    If(
Office365Users.UserPhotoMetadata(Gallery1.Selected.Mail).HasPhoto,
Office365Users.UserPhoto(Gallery1.Selected.Mail),
'robot-face'
)

     

     

     

    To use the sample image use:

     

    If(
    Office365Users.UserPhotoMetadata(Gallery1.Selected.Mail).HasPhoto,
    Office365Users.UserPhoto(Gallery1.Selected.Mail),
    SampleImage
)

     

     

    Hope this helps.

     

    Ellis

ekarim's avatar
ekarim
Brass Contributor
Feb 18, 2022

PerfPC 

Office365Users.UserPhotoMetadata().HasPhoto

will return true or false. You can use this in an If condition:

 

If(
Office365Users.UserPhotoMetadata(Gallery1.Selected.Mail).HasPhoto,
Office365Users.UserPhoto(Gallery1.Selected.Mail),
'robot-face'
)

 

 

 

To use the sample image use:

 

If(
    Office365Users.UserPhotoMetadata(Gallery1.Selected.Mail).HasPhoto,
    Office365Users.UserPhoto(Gallery1.Selected.Mail),
    SampleImage
)

 

 

Hope this helps.

 

Ellis

  • PerfPC's avatar
    PerfPC
    Copper Contributor
    Feb 18, 2022
    ekarim
    Perfect, thank you so much, seeing what you have in the code I certainly did blind myself.
    Really appreciate your input.

    Many Thanks
    Cecil
    • PerfPC's avatar
      PerfPC
      Copper Contributor
      Feb 21, 2022

      ekarim

       

      Just noticed when running the App I get the error in the attached image.

       

      The exact code I used was derived from your information below, the image of the user and the default image shows fine but with the error. Any ideas what this could be or a possible fix.

      If(
    Office365Users.UserPhotoMetadata(ThisItem.Picture.Email).HasPhoto,
    Office365Users.UserPhoto(ThisItem.Picture.Email),
    'My-Default-Image'
)

      Many Thanks

      Cecil

       

      • ekarim's avatar
        ekarim
        Brass Contributor
        Feb 21, 2022

        PerfPC 

        Try the following:

         

        If(
    Office365Users.UserPhotoMetadata(ThisItem.Mail).HasPhoto,
    Office365Users.UserPhotoV2(ThisItem.Mail),
    SampleImage
)

         

         

        Runtime output example - within a Gallery:

        Note that ThisItem.UserPrincipalName and ThisItem.Id seem to also work.

         

         

        Please see the following, which provides a different expression - if this is of benefit to your app:

        https://powerusers.microsoft.com/t5/Building-Power-Apps/UserPhotoMetaData-UserID-Error/m-p/295317/highlight/true#M85146

         

        However,  I do see a warning when I am editing the code, although the photos are being shown correctly:

         

        See the following post Office365Users Connector – Get rid of this warning!

        https://thepoweraddict.com/office365users-connector-get-rid-of-this-warning/

         

        Ellis

Resources