cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Tshulha
Regular Visitor

Mimic vlookup in html email

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.
1 ACCEPTED SOLUTION

Accepted Solutions

Hi Ed,

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

Thank you,

Tanya.

View solution in original post

2 REPLIES 2
edgonzales
Super User
Super User

@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.

Hi Ed,

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

Thank you,

Tanya.

Helpful resources

Announcements
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Users online (3,382)