Skip to main content

Notifications

Power Automate - General Discussion
Answered

Power automate combine sharepoint list with excel file data

(0) ShareShare
ReportReport
Posted on by 147

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:

DateVendorVendor nameArticle
04.09.2023vendor1vendor 1123
04.09.2023vendor1vendor 1234
04.09.2023vendor2vendor 2345
04.09.2023vendor2vendor 24455
04.09.2023vendor4vendor 4123
04.09.2023vendor4vendor 4345

 

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.

  • slvedva Profile Picture
    slvedva 147 on at
    Re: Power automate combine sharepoint list with excel file data

    Thanks! It's work as expected.

  • Verified answer
    Re: Power automate combine sharepoint list with excel file data

    Hi @slvedva ,

     

    We made a sample for you.

    SharePoint List:

    vhanytianmsft_0-1693879527507.png

    Excel:

    vhanytianmsft_1-1693879547418.png

     

    Flow:

      Overview:

     

    vhanytianmsft_2-1693879590294.png

    vhanytianmsft_3-1693879618530.png

    contains(variables('Distanct'),outputs('Compose'))

    vhanytianmsft_4-1693879673806.png

    contains(outputs('Compose_2'),outputs('Compose_3'))

    vhanytianmsft_5-1693879925648.png

    vhanytianmsft_6-1693879993113.png


    Hope this will help you,

    Best Regards,
    Tina

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,508

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,839

Leaderboard