Not all submitted forms trigger flow - some do, some don't

(0) Share

Report

Posted on by miguelcostadst

Hi all,

So I'm having this issue in which I'm out of ideas of what the cause might be. Some forms don't trigger my flow.

I have a power app that lists the registered people into an event based on their submitted form.

The flow registers them into a sharepoint list, where my power app gets the info from.

But some of them weren't registered....

So... my sharepoint has 2 lists, one for the guest list and another for events.

Guest list is the list of people that submitted the form, and the event list is a list of events that controls the registered people with 2 columns, one with the limit of participants and another with a counter, that counts people as they submit the form.

I made several tests and all of them worked perfectly, it gets their info from the form, gets the event item from sharepoint with the count value, if the count is less then the limit, it increments the count and registers them into the guest list.

But when the form went live to all my company's workers, there were 408 submitted forms, they all show on guest list, but the counter of the sharepoint item was 385....when it should be 408. The limit was 400, so it should have stopped at 400, but it didn't I had to stop it manually....

I made a small test with an event with 5 people limit, and worked fine, in the 6th submitted form it didn't register.

I thought it could be some problem with concurrency, so I set it to only 1 process at a time and made another test.

I submitted 210 forms, really fast to try to make a worst case scenario, and the counter stopped at 98 of the submitted forms, but this time it only registered 98 people on the guest list. The flow didn't ran the other times.

My flow is quite big, it does other things, so I can't take a screenshot to show everything, but the most important steps are the following:

- triggers when a form is submitted;

- assigns the info to some variables;

- gets the event item from sharepoint and checks if the count is less than the limit

- if less:

- increments the count of event's registered people;

- creates item on guest list with the form data.

- if equal or bigger:

- sends an email saying the limit was reached.

any help would be very appreciated 🙂

Categories:

Using flows

I have the same question (0)

All responses (4)

Answers (0)

wyattdave 410 Moderator on at

Like (0)

Report

Its difficult to understand without seeing the flow, but a quick check is pagination, have you turned that on and set the threshold higher (I wrote a blog about it here https://dev.to/wyattdave/understanding-pagination-in-power-automate-4igh ). As without it it will only grab the first 100 records of the list.

If this isnt the issue are you able to check the logs to see where in the flow the process didnt go as expected.

>--------------------------------------------
If this helped solve your question please mark it as the solution.

I also do a weekly Power Platform blog at https://dev.to/wyattdave

Was this reply helpful? Yes No
miguelcostadst 32 on at

Like (0)

Report

These are the settings which I ran the test with 210 form submissons, and only 98 registered guests on sharepoint.
There are no logs, the total count of flows are 98, the flow didn't execute the other 112 times.

The first "real test", with 408 submissons and 385 registered, the setting was turned off, it was the default settings...

I will insert several screenshots to show the flow.

Was this reply helpful? Yes No
wyattdave 410 Moderator on at

Like (0)

Report

Sorry I get you,

So the form is not even triggering, I see you have not trigger conditions and concurrency limit is set (this should not be the cause).
I'm guessing the flow run list is empty (no waiting runs as if you use a lot of api calls the flow could be throttled, ie if you are using more than 40k actions per day).

It sounds like you might need to raise a support ticket with Microsoft as except for trigger conditions or throttling it should run every time.

>--------------------------------------------
If this helped solve your question please mark it as the solution.

I also do a weekly Power Platform blog at https://dev.to/wyattdave

Was this reply helpful? Yes No
miguelcostadst 32 on at

Like (1)

Report

Thank you, I will create a ticket with microsoft in the meantime

Was this reply helpful? Yes No