cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Milesjustmiles
Level: Powered On

Multiple Images through Excel Based App

Hello!

 

So apparently I'm a lot worse at grasping new programs than I originally thought! I hope somebody out in Silicon Valley is bored this week!

 

I have two separate Excel databases running two separate pages on my app, the first page (locations) acts as a home page, and filters the the second page's gallery by district:

 

SortByColumns(Search(Filter(FULL_LIST, DISTRICT = 'Locations Gallery'.Selected.DISTRICT),TextSearchBox1.Text,"ADDRESS","DESCRIPTION","DISTRICT"),"ADDRESS",If(SortDescending1,Descending, Ascending))

 

The second page (Lot List) then has a simple detail screen when you make a selection.

 

What I'd ideally like to do is find a way through Excel (I'm open to alternatives, but our Excel doc is edited by the whole team) to embed the multiple photos for each lot in Lot List. Pick a District, see the lots in that district, see the photos in that lot.

 

Any help would be GREATLY appreciated!

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Multiple Images through Excel Based App

Hi @Milesjustmiles ,

Do you want to update multiple images to excel in PowerApps?

Firstly, you need to create a field named fieldname[image] in excel.

Then upload all your images to PowerApps.

11131.PNG

 

Save all the images that you want to update in a collection.

Use this collection to update the excel file.

 

For example:

I create a collection saved these images: 

ClearCollect(data,{ID:1,image:1.jpg},{ID:2,image:2.jpg},{ID:3,image:3.jpg},....)

Use this collection to update:

ForAll(data,Patch(table,LookUp(table,ID=data[@ID]),{fieldname[image]:image})

 

Then all the images will be updated to Excel.

I think maybe you want to know more about updating multiple records , here's a doc about it for your reference:

https://powerapps.microsoft.com/en-us/blog/bulk-update-using-forall-and-patch/

 

 

 

Best regards,

Community Support Team _ Phoebe Liu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
Community Support Team
Community Support Team

Re: Multiple Images through Excel Based App

Hi @Milesjustmiles ,

Do you want to update multiple images to excel in PowerApps?

Firstly, you need to create a field named fieldname[image] in excel.

Then upload all your images to PowerApps.

11131.PNG

 

Save all the images that you want to update in a collection.

Use this collection to update the excel file.

 

For example:

I create a collection saved these images: 

ClearCollect(data,{ID:1,image:1.jpg},{ID:2,image:2.jpg},{ID:3,image:3.jpg},....)

Use this collection to update:

ForAll(data,Patch(table,LookUp(table,ID=data[@ID]),{fieldname[image]:image})

 

Then all the images will be updated to Excel.

I think maybe you want to know more about updating multiple records , here's a doc about it for your reference:

https://powerapps.microsoft.com/en-us/blog/bulk-update-using-forall-and-patch/

 

 

 

Best regards,

Community Support Team _ Phoebe Liu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Milesjustmiles
Level: Powered On

Re: Multiple Images through Excel Based App

Thank you! I was looking everywhere and had no idea how to even start!

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

Top Kudoed Authors (Last 30 Days)
Users online (4,986)