Re: MS Lists/Power Automate - Two forms to update one record
Hi @BeerTrooper ,
So far, it seems to not be possible to achieve it with Lists forms, as by default it always create a new List record.
A possible (but not perfect) workaround would be to work with a MS Forms for columns 11 to 14, so you can handle the submissions in Power Automate and update the correct List item.
The only inconvenient here is that you would need to ask for an unique identifier into this second form, like the List Item ID or any other value that makes sense in your context. You need it because, as of today, it's not possible to set dynamic values to MS Forms.
Another possible solution is to work with Power Apps, but it may have some license requirements. The advantages of this approach is that you can handle dynamic IDs, so the user would not need to enter the ID in the Form submission, and you have a lot of room for customization.
Let me know if it works for you or if you need any additional help!
-------------------------------------------------------------------------
If this is the answer for your question, please mark the post as Solved.
If this answer helps you in any way, please give it a like.
http://digitalmill.net/
https://www.linkedin.com/in/raphael-haus-zaneti/
