I've been creating a flow where it pulls data from SFDC, specifically Case Milestone data, in that data, there's a field which contains minutes:seconds in the format of xx:xx when I add a clause to fire a team's post the "less than clause" is ignored.
The flow looks like this:
What happens is the post goes out but for records where the seconds are over 30:00 (for example) so the less than clause appears to be ignored heres a screenshot:
I appreciate any guidance and help on this.
Time Remaining In Mins is less than or equal to = 30:00
30:00 is a string type in your case so less than or equal wont work
You will have to add additional logic which will require expressions
is less than or equal to 30
If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.
Can you confirm what is the data being returned in the time remaining field? if it is just an integer as 30 then you need to modify the condition over there and enter 30. If it is being returned as a time string then it needs to be formatted using the format date time function in the expression editor.
Hope this Helps!
If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!
@RezaDorrani here is the error i get when i implement your suggestion:
Unable to process template language expressions for action 'Condition' at line '1' and column '2653': 'The template language function 'split' expects its first parameter to be of type string. The provided value is of type 'Null'. Please see https://aka.ms/logicexpressions#split for usage details.'.
hopefully the error above indicates this? not entirely sure how to read this.
its the only field which counts down to 00:00 which indicated a breach of SLA we do have CreatedDate (time of case creation) and TargetDate (when SLA is due to expire if not satisfied) both fields are date/time dd/mm/yyyyThh:mm:ss
not sure if there's an alternative approach for this
again appreciate you assisting here
We are excited to announce the launch of Power Virtual Agents Community. Check it out now!
We've updated and improved the layout and uploading format of the Power Automate Cookbook!
Fill out a quick form to claim your user group badge now!