SOLVED

Record responses from Form to SharePoint List & Apply Auto-Increment number

Copper Contributor

Hello

I have spent a couple of days trawling through other conversations that are related to my query, but I can't find the answer I'm looking for.

I have a decent amount of experience with SharePoint and have set up some simple flows but this is the first time I've attempted something complicated and I'm hoping there's a simple solution that I'm just not seeing...

I have a SharePoint List set up called "Improvement Register" that is used to manage improvements as part of our quality system. Suggested Improvements are submitted via a simple Form.

Initially, I set up an automated Flow to record responses from the Form to the List, which worked fine.

This is the Flow for reference:

kdrusetta_0-1592882288617.pngkdrusetta_1-1592882363978.png

Last step is an email notification to the management team that the item has been created.

 

In addition to this, each item (i.e. Suggestion) needs to be allocated a unique ID in the form of "IMPXXXX". I followed the instructions provided by @RobElliott  in this post: https://techcommunity.microsoft.com/t5/sharepoint/auto-increment-number-field-in-a-sharepoint-list/m... to set up the auto-increment number. This flow works fine when I add an item directly into the List via SharePoint. But, when an item is added through the Form, this flow doesn't work. 

 

I'm sure I'm missing a simple step to connect the two but I'm just not experienced enough with Flow to see it. Any assistance anyone can offer would be greatly appreciated!

 

Cheers

Kerry

 

3 Replies

Hi Kerry (@kdrusetta), what does your flow look like for the second part, i.e. adding the increment number?

 

Rob
Los Gallardos
Microsoft Power Automate Community Super Use

Hi Rob (@RobElliott)

 

Here are screenshots of the increment number flow:

kdrusetta_0-1592971502978.pngkdrusetta_1-1592975906462.pngkdrusetta_2-1592976016279.pngkdrusetta_3-1592976097045.pngkdrusetta_4-1592976157629.png

 

Here are the failed run details:

kdrusetta_8-1592976544760.png

 

kdrusetta_5-1592976337910.pngkdrusetta_6-1592976432211.pngkdrusetta_7-1592976475978.png

 

Is that helpful?

 

Cheers

 

Kerry

best response confirmed by kdrusetta (Copper Contributor)
Solution

For anyone that might be having the same problem, I found the solution. A very simple error on my part - I had not made the connection to the Increment list!

All working like a dream now :)

1 best response

Accepted Solutions
best response confirmed by kdrusetta (Copper Contributor)
Solution

For anyone that might be having the same problem, I found the solution. A very simple error on my part - I had not made the connection to the Increment list!

All working like a dream now :)

View solution in original post