Answered

Upload multiple images to dataverse

(0) Share

Report

Posted on by Gerard_Araq

Hello, I have the following query, I have a folder with 1000 images and a table with the same number of rows in Dataverse.

Is there a way to upload all the images of each line, without uploading one by one.

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (9)

Answers (1)

tomsaudrins 74 on at

Like (1)

Report

Is there any relation between the images and the records? Suppose the filename, for example, contains the record ID. In that case, you can have a Power Automate flow that gets all of the images from a SharePoint folder, finds the corresponding records by looking at the file name, and uses an action called "Upload a file".

Was this reply helpful? Yes No
Gerard_Araq 67 on at

Like (0)

Report

Thanks for answering.
Each image has the same name as the table row in dataverse.
All images are uploaded to OneDrive for business.

Was this reply helpful? Yes No
tomsaudrins 74 on at

Like (1)

Report

Awesome! In your case, you can either iterate over the dataverse rows or iterate over the photos.

1. Iterate over all of the images in the OneDrive folder.
2. Get the name of the image (2100. png), and extract the SKU number.
3. List Rows action in Dataverse with row count = 1 and filter rows "sku_column eq varImageDisplayName"
4. Use the Upload a file action, select the record ID, and upload the image contents to the record.

Was this reply helpful? Yes No
Gerard_Araq 67 on at

Like (0)

Report

Yes, I have a column listed in the table.
Now I do all those steps in power automate?

Was this reply helpful? Yes No
tomsaudrins 74 on at

Like (1)

Report

Yes 🙂

Was this reply helpful? Yes No
Gerard_Araq 67 on at

Like (0)

Report

Can you help me with a tutorial? I got lost trying 😥

Was this reply helpful? Yes No
tomsaudrins 74 on at

Like (1)

Report

Hi Gerard,

Where did you get stuck? Could you please share your flow here?
Otherwise, you can follow this short guide, and adapt it to your business case: https://www.powerplatformtalk.com/upload-files-and-images-to-dataverse-in-bulk/

Was this reply helpful? Yes No
Gerard_Araq 67 on at

Like (0)

Report

Use this variable:
first(split(triggerOutputs()?['headers/x-ms-file-name'], '.'))

Message that appears after starting test

Was this reply helpful? Yes No
Verified answer

Gerard_Araq 67 on at

Like (1)

Report

After a while I decided to check calmly and if it works 😁, thank you very much for the help! 👍

Was this reply helpful? Yes No