cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper II
Helper II

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
Highlighted
Community Support
Community Support

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
Highlighted
Community Support
Community Support

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

Highlighted
Helper II
Helper II

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.

Highlighted
Community Support
Community Support

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.
Highlighted
Helper II
Helper II

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

Now Live: Power Virtual Agents Community!

We are excited to announce the launch of Power Virtual Agents Community. Check it out now!

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

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

Top Solution Authors
Users online (6,799)