I am fairly close to having the correct setup but need a little help.
The situation: I am trying to exact a data table and filter it/export to excel and filter. Below is my data from excel. I want to find the rows that:
-Contain “Whlesale” in the Title
-Have a value of “Ready” in the Status column
-Have a Creation Date of the previous business day
What I have seems to complete but not export to queue:
-Read range and output(dtExportData)
-For Each Row in dtExportData
-Assign strStatus = “Ready”
-Get Row Item: row (ColumnName: “Title”) - Output: Arg_Title
-Get Row Item: row (ColumnName: “Status”) - Output: Arg_Status
If: Arg_Status.Equals(strStatus) AND Arg_Title.Contains(“Whlesale”)
-Then: Add Queue Item
Thanks in advance for the help!