Dynamic drop list selection


I wanted to see if someone can help me create an activity that will select a drop list value based on the text search in the drop values.

Text search criteria:

  1. Search for todays date eg. 2021-05-24 – This would need to be getdate()/Today() type function

  2. Search for last name eg. “Smith”

The drop list values would be selected based on the todays date and the last name text.

Any help would be greatly appreciated.




Can you share the drop down values how they look like?

So we can help