Hi All,
Scheduled flow to get items and then send the following email
tried using the following expression to create a due date based on column in the email, keeps throwing the following error
Any help on this would be appreciated
thanks
Matt
Solved! Go to Solution.
Hi @MattJ
Your reasoning is correct, but check if it's empty if it's empty, it will return false in case of null.
Try matching like this:
if(equals(item()?['LCSIIexpiry'],null),'no value',addDays(item()?['LCSIIexpiry'],-90,'yyyy-MM-dd'))
If you still want to check for empty, include your iff statement in the "addDays" part of the expression above, and you'll have a formula that can test both.
Cheers
Manuel
-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
Hi @MattJ
The issue is with your formula. I can see you have an "if," but you probably have an addDays function inside. The first parameter that you're providing is empty. Please check what parameter it is and check in the Flow's run if it's really empty? If so, I would recommend another "if" statement to ensure that the addData always has s value.
Cheers
Manuel
-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
Hi Manuel,
the expression is
if(empty(item()?['LCSIIexpiry']),'no value', adddays(triggerBody()?['LCSIIexpiry'],-90,'yyyy-MM-dd'))
what do i need to change?
thanks for the quick response
Hi @MattJ
Your reasoning is correct, but check if it's empty if it's empty, it will return false in case of null.
Try matching like this:
if(equals(item()?['LCSIIexpiry'],null),'no value',addDays(item()?['LCSIIexpiry'],-90,'yyyy-MM-dd'))
If you still want to check for empty, include your iff statement in the "addDays" part of the expression above, and you'll have a formula that can test both.
Cheers
Manuel
-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
Hi Manuel,
thanks so much, so if the expression checking to see if column value is null, assigning no value if true, otherwise taking away 90 days?
HI @MattJ
Yep, that's it. 😀
Cheers
Manuel
-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
User | Count |
---|---|
92 | |
44 | |
21 | |
17 | |
16 |
User | Count |
---|---|
136 | |
49 | |
42 | |
36 | |
28 |