Unanswered

Unable to fetch the sharepoint folder metadata from flow

(0) Share

Report

Posted on by Madhuri

When I try to get the metadata of a SharePoint folder through the Flow, it returns empty strings for e-tag and file locator fields of the metadata.

I want to get the unique identifier of the folder so that I can create a shareable link from the flow to an anonymous user(outside the organization) which is not possible through the predefined actions in the flow.

Sharepoint generates a link to a particular email ID to access a SharePoint folder in this format -

https://test.sharepoint.com/:f:/s/TestInc/EtCo6EXyPHFOvgt-uUbhnLABsruKa5spqWs7kFZhQxVyYw?email=test@test.com&e=aasYGr

I want to get "EtCo6EXyPHFOvgt-uUbhnLABsruKa5spqWs7kFZhQxVyYw" this value from the metadata of the SharePoint folder.

I get the following output from the "Get folder metadata" (for SharePoint) action :

"" --> etag
"" --> file locator
%252fShared%2bDocuments%252fDocss%252ftest%2540test.com -->id

please let me know if there is any way out to get the metadata used in the link.

Thanks

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (0)

Pstork1 68,717 Most Valuable Professional on at

Like (0)

Report

The problem is that as you mentioned that link is generated for a specific email address when you share the folder. It does not represent the metadata of the folder. It is a custom link for a sharing request. What you want is the Create sharing link for a file or folder action in the SharePoint connector. That will generate the sharing link you want.
-------------------------------------------------------------------------

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

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

Like (0)

Report

Hi @Madhuri ,

Do you want to generate a sharing link for a specific folder?

I have made a test on my side, it seems that action Get folder metadata does not return dynamic content for Etag and File locator.

However, we could use action Create sharing link for a file or folder to generate a sharing link.

Please check the following workaround for a reference.

Then a link will be sent to user outside the organization.

Best regards,

Mabel

Was this reply helpful? Yes No
Madhuri 4 on at

Like (0)

Report

Hi @v-yamao-msft ,
Are you using OneDrive or OneDrive for Business?
I'm unable to use the Create sharing link for a file or folder (OneDrive for Business) action since we're not able to create a shareable link through Flow to an anonymous user (outside the organization). I get a 403 error.
Microsoft support says generating shareable links to users outside the organization is not possible through Flow due to security reasons of the organization.
But I'm able to generate the same shareable link to anonymous users directly from OneDrive for Business using the share option.
So, I'm trying to generate the link using the metadata. Please let me know if there's a way out to achieve this.

Thanks,
Madhuri

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

Like (0)

Report

Hi @Madhuri ,

In my previous post, I used SharePoint connector. But it is also working with OneDrive for Business.

I can use action “create sharing link for a file or folder” of OneDrive for Business to create a sharing link as well.

Do you mean that when you are using this action to create a sharing link, you got a 403 forbidden error?

By the way, OneDrive for Business doesn’t have the action “Get folder metadata”, which connector are you working with?

Best regards,

Mabel

Was this reply helpful? Yes No
Madhuri 4 on at

Like (0)

Report

Hi @v-yamao-msft ,

I have tried the "create a share link using path" action for both Sharepoint as well as the OneDrive for Business and I'm getting a 403 error.

I've contacted the IT team regarding this but they have given full permissions to this particular business account I'm using to create the flow as well as the OneDrive for Business.

Was this reply helpful? Yes No