Skip to main content

Notifications

Power Automate - General Discussion
Answered

Use Vlookup inside a flow to identify a row

(0) ShareShare
ReportReport
Posted on by 413

Hello there.

I'm actually working with 2 lists that I have the need to sync. Let's call TAB1 the original data and TAB2 the copy. I use a column called "SyncID" to refer to TAB1 in TAB2.

I figured out how to sync the creation and the edit of a row, now what it's missing is when I delete a row in TAB1, the flow should delete it in TAB2 too.

 

Take for istance these examples:

 

TAB1
ID
20
30
40

 

 

TAB2 
IDSyncID
120
230
340

 

 

The problem is that the sharepoint flow that I use to delet an item wants the ID of that item. Nothing strange here. How can I tell to the flow that the ID is equal to the result of a VLOOKUP function comparing the SyncID of the TAB2 with the ID of the TAB1?

 

Thanks.

  • Verified answer
    narayan225 Profile Picture
    narayan225 2,425 on at
    Re: Use Vlookup inside a flow to identify a row

    @Calcioscacchi 

     

    Considering Tab1 and Tab2 are SharePoint lists, you can use when an item is deleted trigger to get the record details.

     

    Once you do that you can add another action to find the item whose sync id value is equal to the id of the item deleted from the first list.

     

    After that you can add a delete item action and pass the id number from the get items action.

     

    Hope this helps.

    Cheers!

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,666

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,996

Leaderboard