Hi, I am trying to build a flow to lookup an email address from a smartsheet using another column of that row. I have the variable strshortcodename that contains IRLM in column short code and want to return the value of the column email and set it into variable stremailaddress but am having no luck selecting the correct row based on the short code.
any ideas welcome please?
here is my flow so far, I get the smart sheet but just cannot figure out how to apply a select or array filter


Report
All responses (
Answers (