Add a link in a list to a document created by flow

(0) Share

Report

Posted on by Victoria

199

I have a flow which creates a word doc and pdf from items in a sharepoint list using a word template document.

I would like to use flow to put a link to the newly created pdf file back in the list item.

I cannot use 'when an item is modified or created' as a trigger without creating a flow loop.

I was thinking of using another flow with a recurrance trigger to do this once a day but this means we would lose the modification history because this would be overwritten by flow each day.

Is there a way to add a condition so that flow can differentiate and only run when the modification is made by a user rather than flow?

Thanks Vicki

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (0)

yashag2255 24,769 Super User 2024 Season 1 on at

Like (1)

Report

Hi @Victoria

So the column that will have the value of the newly created document (the url) will be empty when the item will be created right? In that case, you could use an if condition to check if there was some data in the url column and if no then trigger the flow and if yes, do not trigger the flow (some conditions around specific columns to avoid getting into an infinite loop should help)

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

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

Like (0)

Report

Hi @Victoria,

Based on your description of your requirements, here are some flow configuration details for your reference:

Step1: You could add a Yes/No type column called UpdateSwitch, and set the default value as Yes. Switch it to Yes if a user needs to update every time.
Step2: Create a condition under the trigger of the flow you created, and judge the column UpdateSwitch whether it is Yes.
-If true, continue the next steps.
-If false, do nothing.
Step3: After adding a link in a list to a document, update the item set UpdateSwitch value as No.

Or you can determine whether to create and update time by adding a condition is the same,
-If the same, is a new item
-If not the same, it is the previously created files.
So that you can avoid subsequent updates in the new item of the item to trigger the flow again, but this method is only suitable for the new item if it needs to frequently update the list, do not recommend to do so, this method is presented here for reference.
I hope it can help you. If you still have questions, please contact us.

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

Was this reply helpful? Yes No