Add Images From OneDrive to Gallery

[Anonymous]

Hello. New to power apps. I am trying to create an app that starts out on the first screen with a list of contacts from a spreadsheet. clicking on the contact should open up the second screen with contact email/phone/extension, etc. So far, it works well. What I want to add now is a picture of the contact.

So on screen 1, I have a contacts gallery with a spreadsheet of all information from my OneDrive. I wish to drop pictures of my contacts into a OneDrive folder, and label the filename with the first and last name of the contact. How do I recall these images on my second screen?

--contactgallery build on first screen

--contactgallery.selected on second screen to pull information from my spreadsheet

Thank you! Please let me know if i'm leaving out any details or any files that would help. I have searched forums for adding pictures but I havent found anything that fits my issue quite right. Any links to forums also greatly appreciated. 

[aprildunnam]

First thing you'll need is a column in your contact spreadsheet to hold the URL of where that contact's picture is stored in OneDrive. On your Contact View/Edit Detail Screen you can insert an Image Control and set the Image property to the URL field in your Contacts List.

[Anonymous]

Thanks for the response. From other forums I've seen a similiar solution to what you're saying. Attached are a few pictures of what i have going on.

It's pulling an image, but just the first image on the spreadsheet. How do I reference column one and say if column 1 = (below)

ContactGallery.Selected.First_x0020_Name & " " & ContactGallery.Selected.Last_x0020_Name

then pull column B photo? What i'm picturing is a vlookup with photos. the spreadsheet in the screenshot attached would have about 100 names with photo links. 

Thank you

[Anonymous]

See attached picture. I have the spreadsheet all set up but I'm having trouble calling on the "picture" column, which contains a link to the picture in my onedrive. All other fields work fine using "ContactGallery.Selected.XXXXX." Should I be using "ContactGallery.Selected.picture" in an image?

Thanks

[v-monli-msft · Accepted solution]

Hi @Anonymous,

The excel in your screenshot should be something similar with the one in:

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/add-images-to-excel

This documentation is about how to upload and view images in PowerApps using excel in OneDrive as the data source. You just need to followed the steps inside and you will get the app that you need. Notice that you have to have "[image]" inclued in your image column name to make PowerApps automantically show this column as a Picture control in the app. In your screenshot, it seems that your image column name is "picture". Please change it to "picture[image]" and recreate the app.

Regards,

Mona

Regards,

Mona

[Anonymous]

worked perfectly thank you!