Unanswered

Issue with creating links for SP folders on list items

(0) Share

Report

Posted on by CU17102214-0

Good Afternoon!

Yesterday, I edited a PA flow to fix an unrelated issue, saved, and afterwards the links created with "Create sharing link for a file or folder" SharePoint connector stopped working. When trying to troubleshoot with the run history, the "Update Item" SP Connector is sort of grayed out, but overall run was successful. We're on GCCH too. I've checked permissions for service account user for the connector and everything is appropriate. I even switched to my user, but it didn't make a difference. I've tried to build the link/URL manually, based on some online tutorials, but no luck. I even switched back to using the link generated with the aforementioned SP connector, but still no luck.

More specifics, the PA flow is triggered based on new items added to an SP list. The flow takes the metadata and attachments from the list item and creates a documents folder and copies the attachments to it and checks them it for version control. After that is done is when the "Create sharing link..." SP connector is used to build the link. Using View and Edit link type and People in my organization link scope, so it's a secure link. The same links were not working on email notifications sent out, but on newer test, they are working again, so main issue is now strictly with writing links to SP list items on hyperlink columns. Everything else seems to write fine with Update Item, except for the links. The link from Documents to List has always worked fine though. See attached screenshots to illustrate (From PA Flow, from SP List, and from error message when clicking link). NOTE: I was using a Compose object to pass the link during initial break/fix testing, but skipping it in current testing to see if it makes a difference.

Anyone have any thoughts on possible things to try or a resolution?

Please let me know of any questions/concerns.

Thank you.

Categories:

Process Advisor

All responses (2)

Answers (0)

creativeopinion 10,383 Super User 2025 Season 1 on at

Like (0)

Report

Issue with creating links for SP folders on list items

@CU17102214-0 I believe the logic of your flow needs to be adjusted. Apply to Each actions are added to your flow automatically when you are using dynamic content that is an array (hence the apply to each loop). If you haven't parsed your dynamic content properly, PA will automatically add the apply to each action as it will have to loop through each item in the array.

It's hard to offer any recommendations without seeing your full flow and the logic behind it. Toggle off the New Designer and click each action to expand it. Upload a screenshot of your flow in edit mode.

In the meantime, to help you better understand the Apply to Each action you might be interested in the first YT Tutorial linked below. Additionally, to learn how to work with SP List attachments, the second tutorial might be of interest.

3 Mistakes YOU 🫵 are Making with the Apply to Each Action in your Microsoft Power Automate Flow

In this video tutorial I’ll go over how to avoid these common mistakes when using the Apply to Each action in a Power Automate flow:
1️⃣ Looping through a Single Item
2️⃣ Creating Unnecessary Nested Loops
3️⃣ Looping through an Unfiltered Array

At the end of the video I share a few helpful insights when it comes to using the Apply to Each action in your flow.

IN THIS VIDEO:
✓ How to avoid the Apply to Each action with a single item array
✓ How to use the item() function to access dynamic content in an array
✓ How to prevent unnecessary nested Apply to Each action loops
✓ How to use the Select action
✓ How to convert an array to a string with the Select action
✓ How to use the Filter Query field
✓ How to count the number of items in an array
✓ How to use a condition control
✓ How to use the concurrency control
✓ How to set a top count
✓ How to use Compose actions for troubleshooting

----

How to Send SharePoint List Attachments 📎 via Email with Power Automate

In this Microsoft Power Automate tutorial, I’ll cover how to create a Power Automate flow to send SharePoint list attachments in an email. This flow will check the SharePoint list to see if an item is marked as Ready to Send and has attachments. I will also cover how to combine multiple attachments to send in a single email.

IN THIS VIDEO:

✓ How to attach a single SharePoint list attachment to an email
✓ How to use the Filter Query to Filter SharePoint List Items by a Single Choice Column
✓ How to use the Filter Array action to Filter SharePoint List Items that have an Attachment
✓ How to use turn on Pagination and Set a Threshold in the Get Items action
✓ How to us the Top Count field in the Get Items action
✓ How to use the Get Attachments Action
✓ How to avoid the Apply to Each Action
✓ How to use the Get File Content Action
✓ How to Edit an Expression
✓ How to use the Compose Action
✓ How to Get Multiple SharePoint Attachments
✓ How to use the Append to Array Variable Action

Hope this helps!

Consider giving me a ❤️ if you liked my response!

👉 Level up your Power Automate skills by checking out my tutorials on YouTube
👉 Tips and Tricks on TikTok and Instagram
CU17102214-0 2 on at

Like (0)

Report

Issue with creating links for SP folders on list items

The answer to the post below matches with how I created my folder link, using same object/connector for link creation and applying it to list item with Update Item connector. Since we're GCCH, I've resolved that weird things happen in that environment, but just doesn't make sense. Unfortunately, I have nearly a full day involved in troubleshooting and researching this issue and very frustrated. I was thinking that maybe some sort of PA update was pushed out, but I haven't found specific information on those possible updates. I even used ChatGPT to research, but most of the returned links were from LinkedIn, and only one came from MS. Needle in a haystack unfortunately!
https://community.powerplatform.com/forums/thread/details/?threadid=c2a52b1a-1d53-4760-82be-4ca63770c8c1

I'm attaching a screenshot from Run History to illustrate where Update Item is grayed out, so I cannot really tell what happened or didn't. Definitely hard to troubleshoot. Is there another or better way to troubleshoot flows when things like this happen?

NOTE: The For each and For each 1 loops are required (and automatically get created) due to multi-value fields associated with the list item. First loop is for the ProductLine field and second loop is for the SelfCertifyDepts field.

7U4oJqQV6l.png