SOLVED

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

%3CLINGO-SUB%20id%3D%22lingo-sub-1482609%22%20slang%3D%22en-US%22%3ERecord%20responses%20from%20Form%20to%20SharePoint%20List%20%26amp%3B%20Apply%20Auto-Increment%20number%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1482609%22%20slang%3D%22en-US%22%3E%3CP%3EHello%3C%2FP%3E%3CP%3EI%20have%20spent%20a%20couple%20of%20days%20trawling%20through%20other%20conversations%20that%20are%20related%20to%20my%20query%2C%20but%20I%20can't%20find%20the%20answer%20I'm%20looking%20for.%3C%2FP%3E%3CP%3EI%20have%20a%20decent%20amount%20of%20experience%20with%20SharePoint%20and%20have%20set%20up%20some%20simple%20flows%20but%20this%20is%20the%20first%20time%20I've%20attempted%20something%20complicated%20and%20I'm%20hoping%20there's%20a%20simple%20solution%20that%20I'm%20just%20not%20seeing...%3C%2FP%3E%3CP%3EI%20have%20a%20SharePoint%20List%20set%20up%20called%20%22Improvement%20Register%22%20that%20is%20used%20to%20manage%20improvements%20as%20part%20of%20our%20quality%20system.%20Suggested%20Improvements%20are%20submitted%20via%20a%20simple%20Form.%3C%2FP%3E%3CP%3EInitially%2C%20I%20set%20up%20an%20automated%20Flow%20to%20record%20responses%20from%20the%20Form%20to%20the%20List%2C%20which%20worked%20fine.%3C%2FP%3E%3CP%3EThis%20is%20the%20Flow%20for%20reference%3A%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22kdrusetta_0-1592882288617.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F200319iEF444449C3C347D2%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22kdrusetta_0-1592882288617.png%22%20alt%3D%22kdrusetta_0-1592882288617.png%22%20%2F%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22kdrusetta_1-1592882363978.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F200321i01192CB6CD1A4B8A%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22kdrusetta_1-1592882363978.png%22%20alt%3D%22kdrusetta_1-1592882363978.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3ELast%20step%20is%20an%20email%20notification%20to%20the%20management%20team%20that%20the%20item%20has%20been%20created.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20addition%20to%20this%2C%20each%20item%20(i.e.%20Suggestion)%20needs%20to%20be%20allocated%20a%20unique%20ID%20in%20the%20form%20of%20%22IMPXXXX%22.%20I%20followed%20the%20instructions%20provided%20by%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F174092%22%20target%3D%22_blank%22%3E%40Rob%20Elliott%3C%2FA%3E%26nbsp%3B%26nbsp%3Bin%20this%20post%3A%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fsharepoint%2Fauto-increment-number-field-in-a-sharepoint-list%2Fm-p%2F1141477%2Fthread-id%2F37988%22%20target%3D%22_blank%22%3Ehttps%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fsharepoint%2Fauto-increment-number-field-in-a-sharepoint-list%2Fm-p%2F1141477%2Fthread-id%2F37988%3C%2FA%3E%26nbsp%3Bto%20set%20up%20the%20auto-increment%20number.%20This%20flow%20works%20fine%20when%20I%20add%20an%20item%20directly%20into%20the%20List%20via%20SharePoint.%20But%2C%20when%20an%20item%20is%20added%20through%20the%20Form%2C%20this%20flow%20doesn't%20work.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20sure%20I'm%20missing%20a%20simple%20step%20to%20connect%20the%20two%20but%20I'm%20just%20not%20experienced%20enough%20with%20Flow%20to%20see%20it.%20Any%20assistance%20anyone%20can%20offer%20would%20be%20greatly%20appreciated!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECheers%3C%2FP%3E%3CP%3EKerry%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1482609%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EMicrosoft%20Flow%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1483107%22%20slang%3D%22en-US%22%3ERe%3A%20Record%20responses%20from%20Form%20to%20SharePoint%20List%20%26amp%3B%20Apply%20Auto-Increment%20number%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1483107%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Kerry%20(%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F700457%22%20target%3D%22_blank%22%3E%40kdrusetta%3C%2FA%3E)%2C%20what%20does%20your%20flow%20look%20like%20for%20the%20second%20part%2C%20i.e.%20adding%20the%20increment%20number%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERob%3CBR%20%2F%3ELos%20Gallardos%3CBR%20%2F%3E%3CFONT%20size%3D%222%22%20color%3D%22%23006400%22%3EMicrosoft%20Power%20Automate%20Community%20Super%20Use%3C%2FFONT%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1485188%22%20slang%3D%22en-US%22%3ERe%3A%20Record%20responses%20from%20Form%20to%20SharePoint%20List%20%26amp%3B%20Apply%20Auto-Increment%20number%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1485188%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Rob%20(%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F174092%22%20target%3D%22_blank%22%3E%40Rob%20Elliott%3C%2FA%3E)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHere%20are%20screenshots%20of%20the%20increment%20number%20flow%3A%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22kdrusetta_0-1592971502978.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F200648i6D6CDE55EE94B37A%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22kdrusetta_0-1592971502978.png%22%20alt%3D%22kdrusetta_0-1592971502978.png%22%20%2F%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22kdrusetta_1-1592975906462.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F200656iB878E830EE222240%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22kdrusetta_1-1592975906462.png%22%20alt%3D%22kdrusetta_1-1592975906462.png%22%20%2F%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22kdrusetta_2-1592976016279.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F200657i488DED6D868F84EE%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22kdrusetta_2-1592976016279.png%22%20alt%3D%22kdrusetta_2-1592976016279.png%22%20%2F%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22kdrusetta_3-1592976097045.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F200658i3059578F5F55104C%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22kdrusetta_3-1592976097045.png%22%20alt%3D%22kdrusetta_3-1592976097045.png%22%20%2F%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22kdrusetta_4-1592976157629.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F200659iF75BA83FF007AF6B%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22kdrusetta_4-1592976157629.png%22%20alt%3D%22kdrusetta_4-1592976157629.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHere%20are%20the%20failed%20run%20details%3A%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22kdrusetta_8-1592976544760.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F200663iC6E77DDBA1365D31%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22kdrusetta_8-1592976544760.png%22%20alt%3D%22kdrusetta_8-1592976544760.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22kdrusetta_5-1592976337910.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F200660iA8C9891E3C2CDBA3%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22kdrusetta_5-1592976337910.png%22%20alt%3D%22kdrusetta_5-1592976337910.png%22%20%2F%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22kdrusetta_6-1592976432211.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F200661i191EE4CF908B039D%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22kdrusetta_6-1592976432211.png%22%20alt%3D%22kdrusetta_6-1592976432211.png%22%20%2F%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22kdrusetta_7-1592976475978.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F200662i02D0F19E2E78DF30%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22kdrusetta_7-1592976475978.png%22%20alt%3D%22kdrusetta_7-1592976475978.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20that%20helpful%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECheers%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EKerry%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1564056%22%20slang%3D%22en-US%22%3ERe%3A%20Record%20responses%20from%20Form%20to%20SharePoint%20List%20%26amp%3B%20Apply%20Auto-Increment%20number%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1564056%22%20slang%3D%22en-US%22%3E%3CP%3EFor%20anyone%20that%20might%20be%20having%20the%20same%20problem%2C%20I%20found%20the%20solution.%20A%20very%20simple%20error%20on%20my%20part%20-%20I%20had%20not%20made%20the%20connection%20to%20the%20Increment%20list!%3C%2FP%3E%3CP%3EAll%20working%20like%20a%20dream%20now%20%3A)%3C%2Fimg%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New 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 @Rob Elliott  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
Highlighted

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

Highlighted

Hi Rob (@Rob Elliott)

 

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

Highlighted
Best Response confirmed by kdrusetta (New 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 :)