I have a new requirement where I need to read dates from my excel sheet (dates are in column2 comma separated) and compare the date with current system date. IF date matches with any of the column in excel sheet get the jobname and based on the jobname trigger the job flow.
How we can have flows for different jobs and trigger the appropriate flow based on the match flow .Will switch case work ?
MY excel looks like below
Can someone please share a flow on how to get this done. I have tried different solutions but did not work.
I tried implementing the pseudo code shared
“row(“Dates”).ToString.Split(”,“c).Where(Function(d) IsDate(d.Trim) ).Select(Function(d) CDate(d.Trim) ).ToArray.Contains(Now)”
but was not able to do it in uipath as I am pretty new to uipath and still learning lot of stuff.
Can somebody help me with sample workflow it will help me.
Thanks for your time and support