Unanswered

Hide JSON built hyperlink in SharePoint list if there’s no underlying link

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi guys! I need some help URGENTLY with some conditions in my 'Create Item (SP)'

So, here it goes...
I have 3 conditions with that estructure ↓

If the user upload an attachment, my conditions runs on right side (if no side)...

But at the end of my flow I have an action 'Create Item' on Sharepoint... And there is my problem...

If you look those columns named: "Evidências (5S5), Evidências (5S6), Evidências (5S7)", they're resposible to get the attachments link...
Before my necessity to create this "if", I've inserted an href like this: <a href='Anexo 5S6'>Image</a>..

But when the user don't upload an attach, the flows was inputing only the word "Image"...

I want to insert the attachment's link on those columns ONLY if the user has entered an attach, if no i want to keep those fiends in blank...

if(empty(variables('Anexo 5S6')), '', '<a href='Anexo 5S6'>Image</a>') - but it doesn't works!!!

I need to if my variable 'Anexo 5S6' IS NOT empty, then shows de HREF in my SP column (multiline of string). like this ↓

Categories:

General topics

All responses (2)

Answers (0)

Sort by

Sundeep_Malik 6,501 on at

Like
a
(0)

Report
Copy link

Link copied!

Hey @Anonymous
Can you tell what is the source of the attachment, like Power apps attachment or an email attachment?

There should be some condition where you can check if you have received an attachment or not like in outlook, there is a field called Has Attachment. So if you have something like this, you can use a condition, according to that update SP List.
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

The source is a Microsoft Forms... In my forms I have 3 options (questions) to upload attachments... which I need to insert those attachs converted to links to each column in my SP list (IF HAVE AN ATTACHMENT)...

As I sad before, if I just input my variable in a HREF in my column, it works... But if the user doesn't upload an attachment, it brings me only the word "Image".... I don't want this.
In the print above you can see the as is of Create Item action (of another flow of mine with the same structure), for example.
If I get apply the condition which we are discussing, I'll only replicate to the others.