Power Platform Community Forum Thread Details

I am creating a flow to grant each person on a project secure access to their 1 assigned folder in Sharepoint, and send them a nicely formatted email containing the access link and any other info required. The people are a mix of internal and external. We can do this manually but it is very time-consuming.

It is working perfectly for internal people. Howerver, I cannot figure out how to extract the sharing link that external people need (the one that first takes them to the sharing validation webpage prompting them to enter the email address it was shared to, and then they are emailed a numerical passcode to enter before accessing the folder -subsequent use of the link goes directly to the folder if they choose 'stay signed in').

My excel table looks like this. The Folder_ID and Direct_access_link columns are populated by a "Get files (properties only)" action filtered to folders only.

Person_email	Type	Key	Folder_ID	Direct_access_link	Other_info_for_email	External sharing link
john@aaaaaa.com	Internal	1A	13390	https://AAAAAA.sharepoint.com/sites/AAAAA_Group2/Shared%20Documents/Automate%20Access%20Test/1A	Meeting date April 30, 2025
maya@aaaaaa.com	Internal	1B	13391	https://AAAAAA.sharepoint.com/sites/AAAAA_Group2/Shared%20Documents/Automate%20Access%20Test/1B	Please review these requests
ext_test@gmail.com	External	1C	13392	https://AAAAAA.sharepoint.com/sites/AAAAA_Group2/Shared%20Documents/Automate%20Access%20Test/1C	Zoom link for April 6, 2025, 1pm: ------------/93939339

I use power automate flow action "Grant access to an item or a folder" (Apply to each based on Folder_ID and Person_email) on this data, and it does 2 things

1. Grants direct access to the internal people. They can then use the Direct_access_link when it is passed into the "Send Email v2".

2. Creates a sharing link for the external people. The external people cannot access their folder with the Direct_access_link.

I can check this in Sharepoint which I look at "Manage access" for a folder, for example here is the external sharing link created:

How do I get this external sharing link that I see in the Sharepoint Manage Access window to be accessible to my PowerAutomate flow? I would like to use "Update Row" to place it in the External Sharing link column of my table, so I can just check if a person is internal or external as a condition, and then put the correct dynamic link and information in their email.

My research so far:

1. I found the "Shared with External Users" Report in the Sharepoint Site Settings which returns all items shared with external users, but no actual links. This is not automated, but if useful, I could run it and read it into Power Automate. There is a column called "AccessViaLinkID" that seems to have a GUID in it for the item that was shared with the external user, when a sharing link was created specifically for them. (as per here: https://learn.microsoft.com/en-us/sharepoint/sharing-reports), but this is not the same as any part of the link in the Manage Access window.

2. Found some posts online about using Rest or Graph API to get sharing urls which I do not think I have access to as a regular user without admin access.

Thank you for any help!

Categories:

Building flows