Im currently working on a staff directory using powerapps and I need ideas on how to proceed.
I need to pull Office365 profile picutres (using the O365Users Connector) and match them with the corresponding staff record (from our SQL database, using the SQL Server Connector).
Currently, the records are being displayed in the gallery and Im filtering the gallery using a search bar. Once the user finds the record they want, they click the arrow button which populates the right-hand-side information screen.
So my issue is finding a way to "check" the common fields ('Email' OR 'Initials') and display the O365 profile picutre (UserPhoto).
For example: When I press the gallery button, the app should check the SQL Email with the O365 Email and if both match then display the selected users O365UserPhoto.
If you need any further clarification on anything, feel free to leave a comment.