You’re offline. This is a read only version of the page.
359
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.
Its is possible to update multi choice columns, there's an article here explaining how
https://365basics.com/microsoft-flow-populate-a-multi-choice-field-in-sharepoint/
It does allow for multiple selection, so that seems to be cause of the issue that I was having with making this. Thank you for your help!
Hi @ngreen ,
If the Choice column allow multiple selection?
If the Choice column allow multiple selection, I affraid that there is no any way to achieve your needs.
If the Choice column don't allow multiple selection, you could update the Choice column by Enter Custom value and enter the dynamic content of the correspoinding Choice column, and the flow should as screenshot below:
Best regards,
Alice
Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Share
Report
All responses (
Answers (
