Power Platform Community Forum Thread Details

Hello all,

I'm currently building a Power Automate flow that, based on data from a Microsoft Form — specifically part numbers — will pull the corresponding email addresses of my colleagues from an Excel file. Each colleague is responsible for certain part numbers, and the flow should use the part number from the Form to look up the matching email address in Excel. Then, the flow will automatically send an email to the appropriate colleague via Power Automate. The part numbers and the colleagues' email addresses are stored in an Excel file.

Can anybody please advise how this can be achieved.

Thank you very much.

Categories:

Building flows

Hi,

Refer this flow.

I have designed a MS Form where user enters the part no

Also excel file stores part no and email address

Now flow should be designed like this

Next i am using list rows in table to get the part no details and email address corresponding to that using filter query as shown below

Refer this :https://zeitgeistcode.com/power-automate-odata-filter-sharepoint/#:~:text=To%20filter%20a%20SharePoint%20field%20of%20type%20Choice,Status%20ne%20%27New%27%20startswith%28Product%2C%20%27Discounted%20by%27%29%20substringof%28%27organic%27%2C%20Cotton%29

Next use a condition to check whether there is output from list rows action. i.e any email address corresponding to part no.

Expression:

length(outputs('List_rows_present_in_a_table')?['body/value'])
 
if this is true - it will send an email.
 
Thanks & Regards,

Nived N
Stay connected:

LinkedIn | YouTube | Blogs
Was this answer helpful?

If yes, please mark it as the solution by selecting the checkbox in the discussion thread.

Your feedback motivates me to keep contributing. Thank you!