Good morning everyone,
I have built an application to store information about board games, a kind of library to facilitate the share between the children in our structure. The application store only text for the moment and it is based on a list.
I would like to add the possibility for the user to upload a single picture for each game.
The picture should be shown in a reduced size in the gallery (really reduced for better performance?) and in a bigger size in the game details.
What could be the best solution to be able to load a picture, produce automatically a smaller thumbnail, and store the 2 images ?
List attachement ? separated document library ? how to reduce image size ? other better solution ?
(In the future I could be able to use CDS)
Thank you for your help!
David
Solved! Go to Solution.
If you are considering using CDS (Dataverse), that would provide a very simple solution.
This is because with image columns, Dataverse automatically generates a thumbnail image whenever a user saves an image to a field. There's no additional code that you need to write.
If you were to display the table in a gallery control in a canvas app, the image control will show the thumbnail by default to optimise performance. You can access the full image easily by referencing the "full" property of the image.
As Dataverse supports the "explicit column selection" feature (which you can configure through the settings of a canvas app), this further optimises performance because if you were to display a gallery, or to do a look up on a record without referencing the image, Power Apps will not pull the image from the server.
Another feature is that you can build a model driven app over Dataverse. The image control in model driven apps is richer than the canvas app equivalent, because it provides basic edit functionality. If you're building apps for kids, this could be a fun feature because it would allow the children to draw, annotate, and save the images through a control that's completely built-in.
Generating thumbnail images and storing those in SharePoint will involve much more work. Are you specifically looking for a SharePoint solution?
Hi @Bedavidz ,
I have a blog on this subject that may be useful to you.
Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.
If you are considering using CDS (Dataverse), that would provide a very simple solution.
This is because with image columns, Dataverse automatically generates a thumbnail image whenever a user saves an image to a field. There's no additional code that you need to write.
If you were to display the table in a gallery control in a canvas app, the image control will show the thumbnail by default to optimise performance. You can access the full image easily by referencing the "full" property of the image.
As Dataverse supports the "explicit column selection" feature (which you can configure through the settings of a canvas app), this further optimises performance because if you were to display a gallery, or to do a look up on a record without referencing the image, Power Apps will not pull the image from the server.
Another feature is that you can build a model driven app over Dataverse. The image control in model driven apps is richer than the canvas app equivalent, because it provides basic edit functionality. If you're building apps for kids, this could be a fun feature because it would allow the children to draw, annotate, and save the images through a control that's completely built-in.
Generating thumbnail images and storing those in SharePoint will involve much more work. Are you specifically looking for a SharePoint solution?
Thank you to both of you, I have now all the information I need to improve our app.
I will first investigate with our IT service if I could obtain an environnement with a database and try this way.
If it is not possible I will stick to the Sharepoint list. Below a printscreen of my app for illustration.
Have a good day
David
This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.
Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.
User | Count |
---|---|
195 | |
70 | |
51 | |
42 | |
30 |
User | Count |
---|---|
255 | |
119 | |
100 | |
93 | |
78 |