Answered

Update sharepoint items or create new from Excel file

(0) Share

Report

Posted on by Gochix

1,935 Moderator

I would like to ask for some help to update the SharePoint list from the Excel table stored in SharePoint Document Library.

What is the idea:

Manual trigger button - > Check the excel table if Title matches the SharePoint item title. If yes then Update, if no the create new item.
Flow should also check for blank rows in excel Table and ignore them when updating SharePoint list.

Progress so far:

Condition: length(body('Get_items')?['value'])

And for some reason I can't update the columns I want. I'm trying to update the Price column from excel table but can't select any other than SharePoint values here...

So the main achievement would be to be able to update price, and to only try update ( apply to each ) those rows from excel that match SP list item. Otherwise if I have 1000 empty rows, it will try to loop through them anyway.

Any help would be appreciated. I did search within the forum but I couldn't get answers on these issues.

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (1)

Gochix 1,935 Moderator on at

Like (0)

Report
So far I've managed to get the flow to update the SharePoint List item if exist, create if doesn't.
However, I'm trying to increment PartID number by 1 every time I create new item.

Tried this tutorial : TUTORIAL

but when trying to implement inside my flow then PartId is increased either by + 2 or +3 or highest PartID is not found and PartID for new item is set to 1 therefore messing my List.

Any help would be apperciated. Here is my current flow:

Condition expression :
length(body('Get_items')?['value'])

Was this reply helpful? Yes No
Verified answer

v-bofeng-msft on at

Like (0)

Report

Hi @Gochix ,

You could try this way to get the largest PartID,

Best Regards,

Bof

Was this reply helpful? Yes No
Gochix 1,935 Moderator on at

Like (0)

Report

@v-bofeng-msft , thank you. As simple as that but works like a charm.

Was this reply helpful? Yes No
v-bofeng-msft on at

Like (0)

Report

Hi @Gochix ,

Sorry I missed something important, the expression should be:

last(sort(body('Select')))

Best Regards,

bof

Was this reply helpful? Yes No