cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ngreen
Resolver I
Resolver I

Flow to Update SharePoint Choice column data

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.

1 ACCEPTED SOLUTION

Accepted Solutions
v-alzhan-msft
Community Support
Community Support

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:

1.png

 

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.

View solution in original post

3 REPLIES 3
v-alzhan-msft
Community Support
Community Support

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:

1.png

 

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.

@v-alzhan-msft 

 

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!

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/

Helpful resources

Announcements
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Users online (1,530)