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?
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.
Was this reply helpful?YesNo
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
24
Share
Report
All responses (
Answers (
