Comparison of runtime parameter with excel values

Get Help & Discuss
1

I have created 1 workflow in which I want to pass the value during runtime and that value should be compared with all the values of the excel sheet or with particular column of excel sheet. How can this be achieved in PS.

2

Hi Sonam,

As shown in below images, you can use get variable or generate rows step in that workflow to get those run time values(to convert variables in fields).
After that you can join/lookup those values in excel file fields and then proceed with the next activities.
image or image

3

Hi Rohini,

Thanks for the reply.I tried implementing the above steps in my workflow and its working as expected.