multiple images to Excel

[thgdamasceno]

Hi

I made a simple flow triggered by a form and then save the infos in a Excel worksheet. 

One of this infos is images of the notifications, and works perfectly when people send me just one photo.

automate sends the sharepoint link to a column and in an side column i use hiperlink() to make it clickable.

To see more than one single image, i decide to create two more columns in excel, separating by image1, image2 and image3, but in automate i couldn't create a expression to separate the links of the images.

if someone had any solution, i would be grateful.

the full link are like: 

https://linklinkmy.sharepoint.com/personal/email@sss_com_br/Documents/Aplicativos/Microsoft%20Forms/....jpg;

https://linklinkmy.sharepoint.com/personal/email@_sss_com_br/Documents/Aplicativos/Microsoft%20Forms....jpg;

https://linklinkmy.sharepoint.com/personal/email@sss_com_br/Documents/Aplicativos/Microsoft%20Forms/....jpg

[thgdamasceno]

i found a solution using powerquery to separate the links for each "; ". its not the best, but works 

[v-jefferni · Accepted solution]

Hi @thgdamasceno ,

In your flow you can leverage the split function to separate the full links, and get a specific link using a number.

The first link:

split('URLs answer dynamic content',';')[0]

the second:

split('URLs answer dynamic content',';')[1]

Best regards,

[thgdamasceno]

I have modified my worksheet a little bit. Now it has five columns for the images: image 1, image 2, image 3, image 4, and image 5. I am using

split('URLs answer dynamic content',';')[0]

to get the links.

If I send five images on the form, it works. But if I send four or fewer images, the flow fails because it tries to send a split that does not exist.

Is there a function to check this existence?

Since every link starts with https, I tried

if(contains(split... ,'h'),split.... , '')

but it did not work.

[v-jefferni]

Hi @thgdamasceno ,

Just need to check if there is an answer first for respective question:

if(empty(answer),'',split(...)[0])

Best regards,

[thgdamasceno · Accepted solution]

Hi @v-jefferni 
I can’t check by this way, because in the form I send multiple images on the same field. I tried this strategy on splits like

if(empty(split…[2]),'',split…[2]) 

but it returned me an error, because it can’t check the splits that don’t exist. The same error appears in the strategy that I use in the other reply.

To get it working, I made

if(less(length(split(variables('FOTOS'), '; ')),5),'',split(variables('FOTOS'),'; ')[3])

It doesn’t make sense that one function works and others don’t, since they use the same strategy, but is ok