Power Platform Community Forum Thread Details

Base64 Images into Dataverse Column with a condition

Hey Power Automate Community,

im looking for some help in building my flow.

The task

I have a large sets of images (around 5500 at 30-40kb each). It shows in item in 6 different angles. The naming of this file always follows the same pattern. First a number "12345" + "_" + "L" or "H" and then "Front","Back","Left","Right","Top","Bottom".

Resulting in a file name like this "12345_L_Front.jpg".

I want to use a flow to add these images though base 64 to a dataverse table to use afterwards connect this table to power apps.

The dataverse table itself has multiple columns like "number", "cut", "front", "back", "bottom", "top", "left", "right".

I later want to use the number to filter inside my power canvas app to get the 6 views displayed at once. (but this part is already finished. This is just to give you an explanation).

Now to my problem. I struggle a little bit with the logic on how to approach this correctly. Its always 6 views that are linked to one number. I need the flow to check the name ending through a condition and decide whether it has finished adding these 6 views in one row or not. So to say whether it should update the row its working on or adding a new row.

Additionally i want to have the flow to check which file ending it has and patch the base64 string to the correct column. I was thinking of using the Select Parameter but it requires an array.

Here is my current status of the flow. It works with one file at the moment and only patches it in to the back column( this still needs to be fixed).