Answered

Send an HTTP request to SharePoint is not working (worked 2 days ago)

(1) Share

Report

Posted on by RABronn

Hi,
I have a flow that creates a document set. I'm following guides online since I don't know what I'm doing. My test flow worked on Wednesday, but does not work today (bad gateway error). I have tried creating a new (simplified) flow for testing. This is what I'm working with:

I managed to create this document set via flow on Wednesday (by testing the flow), so it was working initially.

How can I get it to work again?

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (1)

Verified answer

Expiscornovus 33,490 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

Hi @RABronn,

Have you tried it with a different document set name? Or did you try to create a document set with the same name again (in your screenshot the name is Test).

Every new document set should have it's own unique name. Try changing Test to Test2 to see if that makes a difference?

Was this reply helpful? Yes No
RABronn 58 on at

Like (1)

Report
Copy link

Link copied!

Hi @Expiscornovus

Thank you for your help. Yes, the document set name was different. My flow was slightly different to yours though, so I tried your version and it succeeded.

In the interest of making my flow more dynamic for different document set types, could you expand on the syntax for the Content Type StringId retrieved from your first HTTP request? The one that starts with "body(".

Was this reply helpful? Yes No
Expiscornovus 33,490 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!
Hi @RABronn,

Yes, sure. No problem.

Btw, that expression was also stored in the comments section of the action in my previous screenshot 😁

body('Send_an_HTTP_request_to_SharePoint')['value'][0]['StringId']

Was this reply helpful? Yes No
RABronn 58 on at

Like (1)

Report
Copy link

Link copied!

Hi @Expiscornovus

Ah, I see it now, thank you!

Was this reply helpful? Yes No
Salem4real 2 on at

Like (1)

Report
Copy link

Link copied!

Hi @Expiscornovus ,

Can you assist me with a similar issue?

Here's my scenario:

I have 2 lists in SharePoint. and a PowerApps

List 1:

Is used to collect data that's submitted by end users. It has many columns 4 of them are:

(Department name >> choice column with around 30 departments) and

(Status >> choice column as well with values like approved, rejected, canceled) and

(No Show >> single line of text and by using patch function from PowerApps it will contain whether true or false)

List 2:

Is a secondary list that has a column called department which contains the same values as the one in List 1. It also has many Number columns like Total requests, total approved requests, total rejected requests, total no show, etc..

I need a flow that collects the totals of approved requests, rejected requests, no show requests, etc.. for each department in List 1 and save them in List 2 under the same department name.

I was able to do it from PowerApps by using Sum(ForAll(Filter(.... and then patch the values in List 2 but due to high volume of requests which reached to +3000 per month that didn't work efficiently.

I tried this solution SharePoint list and calculating sums with flow - Forward Forever

but I couldn't get it work for my scenario

cc: @WarrenBelz

Was this reply helpful? Yes No