cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Kingsley_James
Level: Powered On

Using specific records in Excel file

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

1 REPLY 1
Community Support Team
Community Support Team

Re: Using specific records in Excel file

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

 

Community Support Team _ Mabel Mao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
firstImage

Microsoft Business Applications Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

Power Platform 2019 Release Wave 2 Plan

Power Platform 2019 Release Wave 2 Plan

Features releasing from October 2019 through March 2020

thirdimage

Flow Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

fifthimage

Microsoft Learn

Learn how to build the business apps that you need

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Flow Community Video Gallery!

Users Online
Currently online: 122 members 4,584 guests
Please welcome our newest community members: