Create table from Excel table

[Anonymous]

Hi everyone, I hope you are alright!!

Can someone help me?

I want to filter values ​​from a column and create a table for each value that is equal. And send the table by email to the corresponding email.

Example:

1. My table:

2. Filtering

3. Sending email

Apple -> Send the apple table to apple@apple.com

Microsoft -> Send the MS table to ms@ms.com

Dell -> Send the Dell table to dell@dell.com

Thank you!!

[miguelcas]

Hi @Anonymous 

I'm going to assist you with your issue. First I guess we need to save the corresponding email, this can be save in the same table that you have in the example 1, also could be save in another excel table or SharePoint list that has the Fornecedor column and the corresponding email. This step it's need by the flow to retrieve the email that matches with Fornecedor column an send the email. 

Let me know which option you will use to help you in the process of making the flow.

Thank you for using Microsoft Power Platform Communities.
Community Support Team - Miguel Castro.

[Anonymous]

Hello Miguel Castro,

I have another excel table saved on my OneDrive with supplier emails.

thanks for the help.

[miguelcas]

Hello @Anonymous 

Ok perfect! Here it's a way to achieve what you want. 

1. We need an instant flow that when you run the flow will ask for the supplier to sent the data. Then we are going to look for your table in example 1 to get the items from that supplier. Take a look of the filter query that it['s going to help us retrieving just those items. 

List rows in table action need to be set up with your excel table from example 1. 

2. Then we are going to look for the email from that supplier with the action Get row. This action need to be set up with your suppliers table. 

3. Then, when we have the information, we need to create a Table that is going to be in the email. Please set columns to custom an then add the columns like the image. 

Let me know if this works for you! 

Thank you for using Microsoft Power Platform Communities.
Community Support Team - Miguel Castro.
If this Post helps, then please consider Accept as solution to help the other members find it more quickly.

[Anonymous]

Hello Miguel,

this error appears:

My flow:

PS.: Supplier = Fornecedor.

Now, my tables:

Principal:

Fornecedores:

[Anonymous]

Miguel,

I got it!! Missing quotes haha. Thank you!! God bless you!!

[Anonymous]

Let me be a little more boring... can I send the emails without having to type the supplier, for example, create several tables and send them to the corresponding emails?

[miguelcas · Accepted solution]

Sure! I'm going to explain you how @Anonymous .

1. Eliminate the input variable from the trigger and add a List rows present in table action to retrieve all the suppliers. I renamed the action to better understanding.   

2. Add an apply to each loop that it's going to go through the suppliers. Then, add a List rows present in a table action that it's going to retrieve  the items. Using the filter query to get just the items from a specific supplier. Basically what we are doing here it's for every supplier we are going the look their items in order to create the table and send that table to the supplier's email. 

Note: In the filter query use the dynamic content of Supplier from the suppliers table. To get the item of each supplier in the table. 

3. Add he create HTML table as equal from the first example and the send email too. 

Thank you for using Microsoft Power Platform Communities.
Community Support Team - Miguel Castro.
If this Post helps, then please consider Accept as solution to help the other members find it more quickly.

[Anonymous]

Thank you brother! God bless you!