Hello,
I have a SharePoint Online list to track visitors who sign-in to a community center. On their first visit, they fill out a PowerApp form that has them choose their visitor affiliation from specified choices that populate from the SharePoint list's choice column. When the guests return, we don't ask them to select their affiliation again; however, I feel like that could be useful data, so I'm trying to create a Flow that would trigger whenever an entry is created and the "new or returning" column is set to returning. My issue is that I am having trouble with the part of pulling the initial visit's affiliation into the returning visit's choice column entry. Each visitor gets assigned a unique Guest ID that sticks with them for each visit, so I'm trying to have it look for the submitted returning visitor's guest ID and then go to the initial "new" status record and pull that choice column value and toss it into the "returning" status record every time they come back.
