Hi All,
Im trying use forms and flow together, when the form response has submitted the ID in excel on Splist should be updated by 1 after every new response submitted. However, i found that we can use the increment variable to acheive this, but while im trying to update the file after the response submitted, the variable is showing me same duplicate value.
Please see screen shots:
Flow1
Sharepoint List
Flow2
Please let me know what im i doing wrong and this has created a lot od duplication in my real data base.
Solved! Go to Solution.
@Tapesh I always have the increment number in a separate list. Then when a new response is submitted and the item is created you get the current increment value from that list, increment it by 1 using an add() expression and update the increment list so it's ready for the next item. There will only ever therefore be 1 item in that increment list.
Rob
Los Gallardos
If I've answered your question or solved your problem, please mark this question as answered. This helps others who have the same question find a solution quickly via the forum search. If you liked my response, please consider giving it a thumbs up. Thanks.
Proud to be a Flownaut!
@Tapesh I always have the increment number in a separate list. Then when a new response is submitted and the item is created you get the current increment value from that list, increment it by 1 using an add() expression and update the increment list so it's ready for the next item. There will only ever therefore be 1 item in that increment list.
Rob
Los Gallardos
If I've answered your question or solved your problem, please mark this question as answered. This helps others who have the same question find a solution quickly via the forum search. If you liked my response, please consider giving it a thumbs up. Thanks.
I m sorry i did not get you sir, what you meann to say ?
can you give me the demo ? if you can please
I tried add function not working i dont know what to do now
Proud to be a Flownaut!
Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!
User | Count |
---|---|
33 | |
15 | |
13 | |
13 | |
6 |
User | Count |
---|---|
40 | |
30 | |
25 | |
11 | |
11 |