SharePoint Update Item Will Not Add Link to List Item

[PVLove]

Hello Community,

I have a flow that I've created to add a link to a SharePoint list item after a file is created and added to a SharePoint document library. The flow is creating the link, but not updating the SharePoint list. I'm using a variable for the 'Link to Item' and I've used just the dynamic 'Link to Item' for the URL in the list item and neither will update the list. Any assistance is deeply appreciated, I've been working on this flow for the past month, and it will not update the list. Screenshots of the Flow and Run are below.

Thanks for any assistance,

Patti

Initial Flow -

Flow ItemFlow ItemFlow ItemFlow Item

Completed Flow -

Flow RunFlow RunFlow RunFlow RunFlow Run

[creativeopinion]

@PVLove The Get Files (properties only) action in your flow is redundant. To update a file property you need to use the Update file properties action.

You can simplify your flow it by doing the following:

Hope this helps!

If I helped you solve your problem—please mark my post as a solution ✅.
Consider giving me a 👍 if you liked my response!

👉Watch my tutorials on YouTube
👉Tips and Tricks on TikTok

[PVLove]

@creativeopinion ,

Thanks for the quick reply!  I need a link in the SharePoint LIST to the file in the document library.

I added an 'Update File Properties' action to the flow and it created a link in the library, but it's still not adding that link to the corresponding item in the list.  What else do I need to do to update the list item?

Thanks,

Patti

[creativeopinion]

@PVLove I apologize—totally missed that.

In your flow, you are using the Get Items action. Because you are filtering on the ID column (which will essentially return a single item).

You should use the Get Item action instead. However, do you have an item in your List with the ID of 88?

When does the list item get created? Before or after the file has been created. Another thing to note is that because you are using the When a file is created or modified trigger, your flow will trigger when a file is created and if it's modified. 

[PVLove]

@creativeopinion 

I have a PowerApps form that creates the list item when the form is submitted and a second flow that is triggered from PowerApps that creates the corresponding file.  I'm using a test list and library and, unfortunately, the ID column numbers do not match.  I created multiple list items while testing the app before I created and started testing the flow that creates the file from PowerApps.  I assumed filtering the ID numbers in the Get Items would match the list item with the corresponding file.  I'll replace the Get Items with the Get Item action and see what happens and I'll send you an update.

Thank you for your patience!

Patti

[PVLove]

@creativeopinion 

The Get Item action will not work for me and the Get Items/Update Item combo will not update the list.  I don't know what else to do to make this flow work.

Patti

[creativeopinion]

@PVLove Thx for the additional context. That helps. 

Is it possible to combine your flow that creates a list item and the file into one? Rather than two separate flows? The issue with the secondary flow that is triggered when the File is created could cause issues since it will also be triggered if/when the file is modified.

By combining the flow into one, when you create the list item, you'll be able to pull the item ID which you can then store in a custom column of your document library. This way you are able to reference the corresponding SP list item to the file that has been created.

[PVLove]

@creativeopinion 

I'll give that a try and see how far I get.  I'm afraid of 'breaking' that flow, lol.  Thank you so very much for your help and patience.

Patti

[creativeopinion]

@PVLove I can understand the hesitation. However, I wouldn't recommend you editing your existing flow anyway. Create a copy of it and switch the trigger to a manual trigger. Test and build your flow first before making any changes to something that is already working (or that you've already implemented).

[PVLove]

@creativeopinion 

I've tried to recreate the flow and no matter what trigger I use it will not update the list item with the link.  I tried a different approach, updating the list item with the 'Send an HTTP request to SharePoint.'  It creates the link and updates the list item but does not include the file in the link.  So close, but not quite there.  Screenshots of the new flow are below.  I'm pretty sure my JSON is not correct, but again, I'm not sure what it should be.

Patti

FlowFlow ResultsList Item

[creativeopinion]

@PVLove You can refer to this section of one of my YT Tutorials which goes over how to customize the Link text using the Send HTTP Request action. 

You need to use the Link to Item dynamic content from the When a file is created (properties only) action. Because you also have a Get Items action in your flow—you need to ensure you are selecting the correct dynamic content.

Hope this helps!

If I helped you solve your problem—please mark my post as a solution ✅.
Consider giving me a 👍 if you liked my response!

👉 Watch my tutorials on YouTube
👉 Tips and Tricks on TikTok

[PVLove]

@creativeopinion 

Thank you for the video!  I followed your instructions exactly.  However, when I add the Get Items ID to the 'POST' HTTP request Power Automate puts the HTTP request in an Apply to Each and the flow does not add the link to the list.  I added a random number to the Uri, _api/web/lists/GetByTitle(‘TESTDSISeparationMain’)/items(1) to test the outcome.  The flow failed, but as you can see in the screenshot it is creating the link.  How can I add the Get Items ID to the HTTP 'POST' request and stop it from being put into an Apply to Each?

Thanks!

Patti

Apply to Each w/Get Item IDHTTP Request w/o Get Item ID

[creativeopinion]

@PVLove It should not put the Send HTTP Request into an Apply to Each action. I suspect you are selecting the incorrect Link to Item dynamic content. Instead of selecting the dynamic content associated with the trigger of your flow, you are most likely selecting the dynamic content associated with the Get Items action. 

You can confirm this by hovering over the dynamic content label. It should indicate it's from the trigger.

Hope this helps!

[PVLove]

@creativeopinion 

Thank you for your patience.  I'm so sorry I haven't been able to resolve this with your help/suggestions.  I selected the trigger ID (When a file is created (properties only) instead of the Get Items ID.  The HTTP-Add Link, 'POST' failed with the trigger ID instead of moving to an Apply to Each.  My screenshots of the error messages are below.

Patti

Trigger IDTrigger ID w/SharePoint ListTrigger ID w/Document Library

[creativeopinion]

@PVLove The Send an HTTP Request action is being used to update the SharePoint List. By selecting the ID from the flow trigger (When a file is created)—you're referencing the incorrect ID.

The variable isn't necessary in your flow. You can reduce the number of actions by inserting the Link to item from the flow trigger (When a file is created).

[PVLove]

@creativeopinion 

Thank you once again!  I removed the variable and changed the ID's to the trigger ID and now the flow is failing.  It's creating the link, but does not like the trigger ID.

[PVLove · Accepted solution]

@creativeopinion 

I found some missing single and double quotes in the JSON and fixed those and changed the list to the document library in both the 'GetType' and 'AddLink' requests and it's working!!  It's adding the link to the document library instead of the list, but I can still use that in my PowerApps.  Thank you again for your help and most of all your patience.

Patti

Working Flow