I have an excel table with name and email and I want to display the user's image based on the email id, in the gallery control. What should be the Image property value.
user().Email is displaying my image.
You can use the Office365Users connector. With it you can use the following expression for the Image:
This requires that the users for which you have the e-mail in your excel table have their photos registered in the O365 tenant.
Did you add a connection to the "Office 365 Users" data source? You need to do to be able to use that function. If you go to the View tab, then select "Data Sources"", it should show you the list of connections that you have in your app.