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

Create/Update Sharepoint List using an Excel List using Flow

Hello, I am new to flow and was attemping to do something similar to this video - 
I would run it once and it would output Sort IDs 1-6 in sharepoint, but if I were to run it again it would out 1-6 again in the next 6 rows.  Any help or guidance would be appreciated!  Thanks!
 
1.png2.png3.png
1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Create/Update Sharepoint List using an Excel List using Flow

Hi @wnguyen23 ,

 

Could you provide more details about your problem?

According to the screenshot you provided, you want to determine if there is already an eligible item in SharePoint list. If it does not exist, create a new item.

 

It seems that the configuration of Flow is no problem. It is worth noting that if you use Title as the key column to filter items, you should fill Sort ID in Title field.

And Sort ID should be a non-null field with a unique value in Excel table.

 

Best Regards,

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

View solution in original post

4 REPLIES 4
Community Support Team
Community Support Team

Re: Create/Update Sharepoint List using an Excel List using Flow

Hi @wnguyen23 ,

 

Could you provide more details about your problem?

According to the screenshot you provided, you want to determine if there is already an eligible item in SharePoint list. If it does not exist, create a new item.

 

It seems that the configuration of Flow is no problem. It is worth noting that if you use Title as the key column to filter items, you should fill Sort ID in Title field.

And Sort ID should be a non-null field with a unique value in Excel table.

 

Best Regards,

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

View solution in original post

wnguyen23
Level: Powered On

Re: Create/Update Sharepoint List using an Excel List using Flow

output.png

So this is happening, I run the flow once and it'll output 1-6, but if I run it again it'll out 1-6 again in the next 6 rows.

Am I using Sort ID as the filter incorrectly?  Not too sure how to set non-null field with a unique value in Excel table also.

Community Support Team
Community Support Team

Re: Create/Update Sharepoint List using an Excel List using Flow

Hi @wnguyen23 ,

 

If the current configuration is consistent with the screenshot you provided earlier, you could try the following changes.

  • Use Filter array to filter out eligible items without configuring Filter Query.
  • Then use length() function to calculate the length of Filter array-body.

Image reference:

22.PNG

Please try again.

 

Best Regards,

Community Support Team _ Barry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
wnguyen23
Level: Powered On

Re: Create/Update Sharepoint List using an Excel List using Flow

@v-bacao-msft thanks looks like that worked!  Any idea why it'll create an empty row after the last entry?  

 And when I tried this Update Flow this occurs:3.png

2.png

Helpful resources

Announcements
firstImage

Microsoft Business Applications Virtual Launch Event

Watch the event on demand 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!

Top Kudoed Authors
Users Online
Currently online: 379 members 5,212 guests
Please welcome our newest community members: