Greetings,
I'm new to the Power Platform family and have basically next to no experience in Automate's flows. That being said, I'm in an internship right now that has me on a project for Power Pages and we've reached a milestone were we're starting to automate processes on the website. The goal I want to touch on in this question is something I thought would be relatively simple: I have three tables on this website, two that receive responses from a form that create a new row with Name and Email along with the date the row was created on, and the third that acts as a masterlist containing the dates on which each form was submitted for that user, ideally.
Form 1 automation works fine, when it detects a new row added to it, it adds a new row to the Masterlist Form with a name, email, and date of the submission. However, Form 2's automation needs to UPDATE that existing row in the Masterlist which seems to be far less simple. I believe the issue is that I don't know how to tell the flow to find a specific row in the Masterlist to update with the new date of submission. My current, and non-functional, approach was simply have a trigger that recognized a new row being added to Form 2, and an Update a row action that uses the Email from the submission as the Row ID for the Masterlist which would then update the respective column with the date. This approach just simply doesn't work no matter what I do, leading me to believe I'm trying to solve of a bomb problem with a wooden sword.
Any advice would be massively appreciated!
