Check if a column cell(field) is blank when an item is created or modified: Switch case Problem

(0) Share

Report

Posted on by Community Power Pla...

Hi,

I am having trouble with this, first I figured out you need to use a switch case to check a specific column so it doesnt send my email when any of my other simliar flows get triggered:

1. But this has limitations it only alows an equals funtion: and doesnt allow expersions to check for null values(my blank cell)?

2. I am also just trying to check if a columns field, which shows dates(MM/DD/YYYY) is past a week from our current time, I have all the logic done, just trying to figure out the same problem with this switch case...where I cant specify if it equal a certain date because they are all different.

- Should I make conditions within the switch case? and if so what do I put in the switch case equals to?

Is there any way for this to work?

All responses (1)

Answers (1)

Verified answer

v-yuazh-msft on at

Like (0)

Report

Re: Check if a column cell(field) is blank when an item is created or modified: Switch case Problem

Hi @ mmkrapez,

For your first Switch case problem:

The Switch case allows an equals funtion and doesn't allow expersions to check for null values as you said, if you would like to check for null value,you could add a Condition to achieve your needs.

I have made a test on my side,you could refer to screenshot below to create the flow:

The expression in the Condition as below:

@empty(triggerBody()?['Email'])

You could refer to link below to learn more about the workflow definition language:

https://docs.microsoft.com/en-us/azure/logic-apps/logic-apps-workflow-definition-language

For your second Switch case problem:

The Switch case allows the equals funtion,if you would like to check if a data is past a week from current time,You could add a Condition to achieve your needs.

I have made a test on my side,you could refer to screenshot below to create the flow:

Please let me know if your problem could be solved.

Regards,
Alice Zhang