Unanswered

If Statement Referencing Item in Sharepoint List

(0) Share

Report

Posted on by Perrault

Hello,

Thank you in advance for the help. I need to write an If statement that will be placed into a Send an Email V2 "To" box. I have a Sharepoint List that needs to be referenced to determine what to do. Below is a sentence about what I need it to essentially do in non-code form:

"If N1 is listed in the Role Type column on the Sharepoint list, then send an email to jon1@jon.com. If N2 is listed in the Role Type column on the Sharepoint list, then send an email to jon2@jon.com & jon3@jon.com."

Can someone help me out?

Categories:

General topics

I have the same question (0)

All responses (6)

Answers (0)

Expiscornovus 33,480 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @Perrault,

What type of columns is the Role Type? And does it only have N1 or N2 as values, or are there more possibilities (can it be empty for example)?

Was this reply helpful? Yes No
Perrault 18 on at

Like (0)

Report
Copy link

Link copied!

Hey! It is a single line of text and will always have something in it. It will never be blank.

Was this reply helpful? Yes No
Perrault 18 on at

Like (0)

Report
Copy link

Link copied!

I guess to fully answer your question, it will never be blank, but it could have a variety of other options. So basically if N1 is selected, use this email address. If anything else is selected, use these email addresses.

Was this reply helpful? Yes No
Expiscornovus 33,480 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hi @Perrault,

In that case you could use two equals and if functions and check for N1 and N2. If it isn't one of those two values you could use a catch-all e-mail address.

Below is an example.

This example assumes you are retrieving the value via a Get Item action.

if(equals(outputs('Get_item')?['body/RoleType'], 'N1'), 'jon1@jon.com', if(equals(outputs('Get_item')?['body/RoleType'], 'N2'),'jon2@jon.com;jon3@jon.com', 'allotheroptions@jon.com'))

Was this reply helpful? Yes No
Perrault 18 on at

Like (0)

Report
Copy link

Link copied!

Thank you! Are you able to show what your Get Item looks like? The expression itself is working, but it keeps just going to the catch all email address saying it does not match, even when it does. Thanks!

Was this reply helpful? Yes No
Expiscornovus 33,480 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @Perrault,

That action is retrieving one item for testing purposes. I also used a manually trigger to run it. In my case I only used the first item of my test list with ID 1, which has the N2 value in the Role Type field.

So, that is probably something which will be different in your setup. What trigger action are you planning on using?

Was this reply helpful? Yes No