Answered

If SharePoint value exists, pass it to URL scheme when sending an email

(0) Share

Report

Posted on by doug_tn

I have a flow setup for when an item is created or modified in SharePoint. I'm trying to set it up so that if a value exists in a field (is not empty), it takes the value and adds it to the end of a URL and adds it to my send email action (referenced as Case # in the screenshot). I know I can create a variable and then use a compose action to generate the URL I'm wanting. I just don't know what to do if the value is blank (null) where I would not want to include the URL.

I would then simply put the MyURL output into my email and it would work fine. But if the Case # value is blank, I want to skip the URL all together.

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (1)

Sort by

v-yetonggu-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!
Hi @doug_tn .

Please try put this expression into GCNum Var Value:

if(empty(Case#),null,Case#)

Best Regards,

Sunshine Gu

Was this reply helpful? Yes No
Verified answer

doug_tn 52 on at

Like (0)

Report
Copy link

Link copied!

I ended up creating a condition that determined if the case number value was not equal to null, to generate an email with the GCL link and the no portion of the condition to generate the email without the link

Was this reply helpful? Yes No