web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Using specific records...
Power Automate
Unanswered

Using specific records in Excel file

(0) ShareShare
ReportReport
Posted on by

Hi.

 

I'm not sure if this is the correct place to ask questions.

I have just started using Flow and struggling with validating data. I need to:

1. Load an excel file (All rows) - This is done

2. Condition: If variable1 (for example) exists in the Email column in the above loaded Excel file. - Not done

       true: Get RowID - not done

       false: insert record - This is done

 

If it wasn't clear enough, I need help with the parts that say "Not done".

 

Many thanks

Kingsley

Categories:
I have the same question (0)
  • v-yamao-msft Profile Picture
    Microsoft Employee on at

    Hi @Kingsley_James ,

     

    Do you want to check if a record exists in an Excel table, if yes, get row id from the Excel, if not, insert a row in the Excel table.

    Please check if the following scenario will work for you.

    When an item is created in SharePoint list, check if it already exists in Excel table, if yes, get the corresponding row, if not, insert the item in the Excel table.

    Add the trigger When an item is created.

    Initialize a String variable named as Rows.

    Get rows from the Excel table.

    Add an apply to each, get value from the action Get rows, then add Append to string variable action within the Apply to each, select dynamic content name for the Value field.

    Note: name is one of the column in my Excel table.

    Under the Apply to each, add a Condition to check if variable Rows contains Title from the trigger.

    Under if yes branch, add Condition2 to find out the specific row with Title is equal to name. Then Get row under if yes branch.

    Under if no branch, insert row in the Excel table.

    Images for your reference.

    1.PNG2.PNG

     

    Best regards,

    Mabel

     

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
David_MA Profile Picture

David_MA 262 Super User 2026 Season 1

#2
Haque Profile Picture

Haque 227

#3
Expiscornovus Profile Picture

Expiscornovus 225 Most Valuable Professional

Last 30 days Overall leaderboard