Unanswered

From sharepoint library to sharepoint list

(0) Share

Report

Posted on by StephaneVedren

HI,
I'm trying to make a flow to push in sharepoint list some field of sharepoint library.
I have a sharepoint library with a Word template which include some properties form library columns.
So, when someone create new Word file in this library, I want to push these data in a sharepoint list.
Normaly it work fine... but when someone clic on "new" "element" sharepoint create automaticaly the new word file with all properties empty, so the item create in sharepoint list is... empty. I try to add a "timer" but it is difficult to master the time each user will get to fulfill his word file, and of course if the file is modified later, it is not taken into account.
I try with the "when a file is create or modify" connector I think is the good way but actually the flow create a new item for all new file and all word automatique saving...
I use the triggers "When a file is created or modified (properties only)" > "Get file properties" > "Get items" > Condition If item already exist or not > "Update item" or "create item"
Do you think it's the good way? how can I discriminate the Item? I have never Make Odata filter and I don't understand how it work.

Thanks a lot.

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (0)

PieterVeenstra 13 on at

Like (0)

Report

hi @StephaneVedren,

Why not just trigger the flow on creation and modification? That way you can create the item or update an existing item in your list. Yoiu would just need to check in your list if the macthing item already exists or not.

Was this reply helpful? Yes No
StephaneVedren 44 on at

Like (0)

Report

Hi pieter,
Thank you pieter for your answer, I think in fact that we must trigger the flow on creation and modification, but after, I use "Get file properties" and "Get items" of my Sharepoint List. But I don't no how can I check if the matching item already exist. I test with condition, on the ID but it creates a new item for each item does not have the good ID...

that's why Iwill need help.

Best regards

Stéphane

Was this reply helpful? Yes No
PieterVeenstra 13 on at

Like (0)

Report

I would put a unique id from the library into the list item.

So for example you could add an additonal field to the list and call this DocId. When you create the list item set DocId for the item to the ID of the document. Then before you ceate the list itme query the list item and check if there is a list item with DocId matching that of the document triggering the item creation.

Was this reply helpful? Yes No