Hi,
As I am new in Power Automate, but I need create one specific process, I hope, that someone can help me in this topic.
I need build one process in power automate, where I combine sharepoint list and data from excel.
1. In sharepoint list I have list with vendors (vendor id, vendor email)
2. In excel file I have several columns with data - one column contain vendor id (for one vendor id can be several rows)
Now I want to understand, how correctly build the power automate flow, that system will send message only to these vendors, which contain data in excel file.
Example in sharepoint I have:
vendor1 - vendor1@test.lv
vendor2 - vendor2@test.lv
vendor3 - vendor3@test.lv
Example in excel I have:
Date | Vendor | Vendor name | Article |
04.09.2023 | vendor1 | vendor 1 | 123 |
04.09.2023 | vendor1 | vendor 1 | 234 |
04.09.2023 | vendor2 | vendor 2 | 345 |
04.09.2023 | vendor2 | vendor 2 | 4455 |
04.09.2023 | vendor4 | vendor 4 | 123 |
04.09.2023 | vendor4 | vendor 4 | 345 |
After this example, system should send out 1 message to vendor1 to email vendor1@test.lv and 1 message to vendor2 to email vendor2@test.lv with default message - "It's work".
P.S. System don't need send any message to vendor3, because in excel file no any data for this vendor. And system don't need take care about vendor4, because it's not in the vendor list.
Thanks! It's work as expected.
Hi @slvedva ,
We made a sample for you.
SharePoint List:
Excel:
Flow:
Overview:
contains(variables('Distanct'),outputs('Compose'))
contains(outputs('Compose_2'),outputs('Compose_3'))
Hope this will help you,
Best Regards,
Tina