Hi Team, I have a use case to filter names from a datatable and keep the rows matching the filter key. I can able to achieve it by hard coding all the names in Filter wizard(Please refer screenshot).
But I’d need to get inputs dynamically from Excel.
I tried to achieve it by using Read column → For each and pass each name into Filter wizard using variable, but ran into exception “For each: Specified cast is not valid”
Can someone please help me to get this resolved?