cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
SirCell25
Frequent Visitor

Create table from Excel table

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:

SirCell25_0-1638879873505.png

2. Filtering

SirCell25_1-1638879913827.png

 

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!!

1 ACCEPTED SOLUTION

Accepted Solutions
miguelcas
Microsoft
Microsoft

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

 

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.   

 

miguelcas_0-1639150852909.png

 

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. 

 

miguelcas_1-1639151214341.png

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. 

 

miguelcas_2-1639151352927.png

 

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.

 

 

View solution in original post

8 REPLIES 8
miguelcas
Microsoft
Microsoft

Hi @SirCell25 

 

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.

SirCell25
Frequent Visitor

Hello Miguel Castro,

 

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

 

thanks for the help.

miguelcas
Microsoft
Microsoft

Hello @SirCell25 

 

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. 

 

 

miguelcas_1-1639062992554.png

 

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. 

 

 

miguelcas_3-1639063135709.png

 

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. 

 

miguelcas_4-1639063307804.png

 

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.

 

 

 

 

Hello Miguel,

 

this error appears:

SirCell25_0-1639071924187.png

My flow:

PS.: Supplier = Fornecedor.

 

SirCell25_2-1639072003890.png

 

SirCell25_1-1639071973427.pngSirCell25_3-1639072033408.pngSirCell25_4-1639072053807.png

 

SirCell25_5-1639072068585.pngSirCell25_6-1639072089547.png

 

Now, my tables:

Principal:

SirCell25_7-1639072128906.png

Fornecedores:

SirCell25_8-1639072147411.png

 

 

SirCell25
Frequent Visitor

Miguel,

 

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

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
Microsoft
Microsoft

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

 

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.   

 

miguelcas_0-1639150852909.png

 

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. 

 

miguelcas_1-1639151214341.png

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. 

 

miguelcas_2-1639151352927.png

 

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.

 

 

SirCell25
Frequent Visitor

Thank you brother! God bless you!

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Users online (3,255)