I am trying to add images to my Dataverse table (and then view them in each profile in PowerApps) and have attempted this: https://www.powerplatformtalk.com/upload-files-and-images-to-dataverse-in-bulk/ but it fails.
Being new to Dataverse and PowerAutomate, I'm not sure I did it correctly:
These are my Dataverse columns:
(I had to have two columns for the stunt numbers so I could search by text for the student numbers)
In my PowerApps, it doesn't show up either:
I need it showing in the form rather than a gallery, just how my app is constructed. Though I'm guessing this bit isnt working as it's not uploading to Dataverse table yet.
Thank you @EricRegnier for your help.
I worked out the RowID from this article: https://learn.microsoft.com/en-gb/power-automate/dataverse/get-row-id, and created my flow within the PowerApp app - using the "add a image" media input.
I have no idea how it ended up working, but it works!! and saves nicely in my Dataverse table on the correct row, so thank you for your help!
Hi @c-e-g, You get the row ID from previous action(s) where you query Dataverse based on the logic to update the desired records' images. So in other words, the mapping logic from the images to database records/rows. You can use the List Rows (https://learn.microsoft.com/connectors/commondataserviceforapps/#list-rows) and loop through the results to get the Row ID.
Hope this helps!
Thank you @EricRegnier, I saw this article but it doesnt tell you where to obtain the RowID.
Would you be able to help me here?
Hi @c-e-g,
This MS document explains it better than me to set/update an image column from Power Automate: https://learn.microsoft.com/power-automate/dataverse/upload-download-file#upload-file-or-image-content
Then to display an image is even simplier, simply reference that Dataverse Image column in a Image control:]. For example:
Gallery1.Selected.'My Image'.Full
Hope this helps!
I've also tried to upload the image in the PowerApp and Patch to the Dataverse table, but that doesn't seem to work either.
Any help would be greatly appreciated!
WarrenBelz
146,645
Most Valuable Professional
RandyHayes
76,287
Super User 2024 Season 1
Pstork1
65,997
Most Valuable Professional