Multiple conditions on a single field when updating sharepoint list from MS Form

(1) Share

Report

Posted on by Portfolio_Director_...

HI,

I have 2 different sections on an MS form, both sections have a due date for respective actions. When I create a flow to update the due date response to single SharePoint List field (due date) it requires date format, or null, so it doesnt throw an error. So I use the function:

if(equals(body('Get_response_details')?['r3d5e868db8f948be9bd9f3a44c0bbd0b'],''),null,body('Get_response_details')?['r3d5e868db8f948be9bd9f3a44c0bbd0b']) - which checks to see if the field is blank, which makes it null or adds the date if there is one. This all works fine.

My issue is when I want to add the same check for the 2nd date field (which will be null if the expression above is true) I cant nest the 2 expressions together in the same field in 'Create Item'. I need to duplicate the expression above to check both fields in a single line of code?

Can anyone help how I effectively nest 2 conditions to the expression above?

Categories:

Business Process Flows

All responses (1)

Answers (1)

Verified answer

Portfolio_Director_... 24 on at

Like (0)

Report

Multiple conditions on a single field when updating sharepoint list from MS Form

Resolved!!! I just needed to put the 2nd statement in the first 'null'! Tested and works

if(equals(body('Get_response_details')?['r3d5e868db8f948be9bd9f3a44c0bbd0b'],''),INSERT 2nd IF Statement,body('Get_response_details')?['r3d5e868db8f948be9bd9f3a44c0bbd0b']) - which checks to see if the field is blank, which makes it null or adds the date if there is one. This all works fine.