Mimic vlookup in html email

[Tshulha]

Hi.
I have a table at sharepoint with columns
Job title
Hardware requirements
Software requirements
Users submit a Microsoft form where they select Job Title.
Then an email is sent with Job title, Hardware requirements, Software requirements.
I have all parts of flow being built except populating Hardware Requirements and Software Requirements depending on the Job Title selected in the form.
How can I do this part?

Thank you,
Tanya.

[edgonzales]

@Tshulha 

Hi Tanya!

So, I'm picturing a step with "Get Items" or something? If that's right, then you can add an OData filter where Job Title eq <whatever the dynamic value is from the Forms response>.

Check out Kent's blog post for more details, but keep us posted.  Pics of the Flow would help, too.

-Ed-

If this reply has answered your question or resolved your challenge, please consider marking it as a Solution. This helps other users find it more easily via search.

[Tshulha · Accepted solution]

Hi Ed,

I used Get a Row with the key field and it worked!

Thank you,

Tanya.