Method to check if a Document Set in SharePoint Online exist based on a metadata value

(0) Share

Report

Posted on by PowerTegga

Hi, all.

I'm having trouble finding the right method. What I want to acomplish:

1. Files is created in a SharePoint Document library A under a folder named with a GUID

2. It should check if a document set in Document library B with a value in column GUID is the same as the GUID in the folder name in 1.

I thought maybe a "Send an HTTP request to SharePoint" would work, but I only get "Bad gateway": "Operation is not allowed because it exceeds the list view threshold enabled by the system administrator"

Is there other (better) ways to filter Document sets based on metadata in a column?

Categories:

Building flows

I have the same question (0)

All responses (6)

Answers (1)

annajhaveri 8,531 Most Valuable Professional on at

Like (0)

Report

Hello @PowerTegga ,

So you want to get Document Sets from Library B by applying filter based on GUID column?

Was this reply helpful? Yes No
PowerTegga 77 on at

Like (0)

Report

If there is a Document set in B with a GUID same as the name of the folder (GUID) in A, then I want to move all the files from the folder in A to the Document set in B 🙂

I now how to do everything except the check if the Document set with a special GUID exist. I've tried to hard code with a GUID wich I know exist in a column for Document set, but I still get the "Bad gateway" message.

Was this reply helpful? Yes No
annajhaveri 8,531 Most Valuable Professional on at

Like (0)

Report

Hello @PowerTegga ,

You need to configure the Send HTTP action as shown in below screenshot. Also please note what is the internal name of your GUID column, please go to Library settings, click on GUID column, and then see URL in browser and get the value after "Field=" form the URL, that should give you internal name of the field, and use that internal name in the URL filter.

Was this reply helpful? Yes No
PowerTegga 77 on at

Like (0)

Report

Thanks for your reply.

I did almost the same, but changed to the headers you have there:

I still get the "Bad gateway" message.

Anyhow, I think I've found another method to do what I want the flow to do (by using another SharePoint list in the system). It creates a few more steps, but I think it will work.

Was this reply helpful? Yes No
Verified answer

annajhaveri 8,531 Most Valuable Professional on at

Like (0)

Report

oh i overlooked your error, you are getting threshold error, so it looks like your list has over 5000 items, is the GUID column indexed?

Was this reply helpful? Yes No
PowerTegga 77 on at

Like (1)

Report

That was the problem. I indexed the column and now its working.

Thanks a lot, @annajhaveri 🙂

Was this reply helpful? Yes No