How would you go about this if you wanted to extract the value whilst keeping it associated it to columns? For example, if the Value is football, then return the row with football and all of the other column data? If the row does not equal football, skip that row, but the next row it finds equal to football, keep all the data in the row
Hello, Great tutorial. I want save the choice values in excel sheet I am using "add row into a table" connector, in the column field: I have entered body('Select'), but in excel values are copying like [" Football","Rugby"] is there any way i can only copy Football, Rugby into my sheet?
Hi! I'm using the create csv table action to transfer most of my other columns. can I just apply your step to get multiple choice field after the csv table action? thanks a lot!
Hi @abm thank you for this video very informative. 1 question I have which I can’t seem to find the answer too. In the condition you type “Rugby” or “Football” to see if it contains these. How would I go about using dynamic content? I want this to trigger an email based on a users input - if the input matches one that is already on the list an email will get sent to all those with the same choice. For example I choose football & Rugby. The condition sees that these already exist on the list and will email those with this choice to let them know someone else has also chosen these fields.. does that make sense?
@@abm4975 hey thanks for coming back. It comes from user input. A user will select choices from a multiple select choice field. I want the flow to get items and see if there is a match in the list already and then email all those that have pre selected those choices
Hi Ethan Thanks for your reply. In flow trigger action steps there is a manual trigger, click on add an input. Here you can define multiple inputs, but that means user need to enter the values before the flow run. Later down the action steps you can utilise these input dynamically to compare under the IF condition. Is that helpful? If not, please let know your thoughts around this. Thanks
thanks for this solution , I could replicate it , but my output is printing the multiple times. e.g I have t items in the field like laptop Mobile. so the output will be Laptop,Mobile,Laptop Mobile. The out is getting print the number of item in the field
@abm - Thank you for this great video. Your approach to multi-select choice fields is by far the simplest solution I've found on the web. This will really help me a lot with my Flows.
Great tutorial and best way to deal with multi choice column values! Thank you! Question, after the Join, how could I compare the value of the Join output with a value from another share point list? In the video you manually type the value “o/s” in the if condition but what it I just want to grab all values at once instead of one by one?
Hi Thanks for the support. So after the join you will have a string of values separated by commas. So to compare the whole value from another SharePoint list you need to add Get Items and set the filter query with column name eq 'output from the join'. Thanks
Your solution worked but I'm experience a big difference in run time. Prior to adding the select and join functions, it took my flow an hour to run. Now its 4 hours. Any idea what could be causing this and is there a solution to reduce the run time?
@@abm4975 Hello there! Thank you for sharing your solution. I was wondering if you could help me with a question I have. Based on this solution, I built a flow that automatically triggers whenever an item is modified on a specific SharePoint list. At present, the list contains over 4000 records, and it takes quite a while for the flow to run. The Select and Join steps in particular seem to be taking up most of the time. I suspect this is because the flow is reviewing all 4000+ records in the list. In my case, the flow checks four different multiple-choice columns, which means there are four different Selects and Joins. Is there any way to limit the "Select" step to only review the modified record rather than checking all of them? Any assistance would be greatly appreciated.
How would you go about this if you wanted to extract the value whilst keeping it associated it to columns?
For example, if the Value is football, then return the row with football and all of the other column data?
If the row does not equal football, skip that row, but the next row it finds equal to football, keep all the data in the row
Great tutorial, quick question Sir, how do I add the output to the email? I cannot find the Compose, it is showing under Apply to each
Under the Dynamics Content search for 'Output'. You will be able to see the compose output.
Hello,
Great tutorial. I want save the choice values in excel sheet I am using "add row into a table" connector, in the column field: I have entered body('Select'), but in excel values are copying like [" Football","Rugby"] is there any way i can only copy Football, Rugby into my sheet?
Hi
Use the replace() expression to remove '[' ,']','"' characters.
Thanks
Hi! I'm using the create csv table action to transfer most of my other columns. can I just apply your step to get multiple choice field after the csv table action? thanks a lot!
Yes it should be possible.
This doesn't work if the value you are looking for is contained in one of the other choices.
Yes agreed but then you need to think about what's the appropriate condition you could use. There are other comparison operations you could apply.
Man , you just solved a huge problem i had with that line of text, thank you!!!
Thanks a lot for your support !!!
Hi @abm thank you for this video very informative.
1 question I have which I can’t seem to find the answer too. In the condition you type “Rugby” or “Football” to see if it contains these. How would I go about using dynamic content? I want this to trigger an email based on a users input - if the input matches one that is already on the list an email will get sent to all those with the same choice. For example I choose football & Rugby. The condition sees that these already exist on the list and will email those with this choice to let them know someone else has also chosen these fields.. does that make sense?
Hi Ethan
Thanks for the support. Great question. Where does the dynamic content values come from?
Thanks
@@abm4975 hey thanks for coming back. It comes from user input.
A user will select choices from a multiple select choice field.
I want the flow to get items and see if there is a match in the list already and then email all those that have pre selected those choices
Hi Ethan
Thanks for your reply. In flow trigger action steps there is a manual trigger, click on add an input. Here you can define multiple inputs, but that means user need to enter the values before the flow run. Later down the action steps you can utilise these input dynamically to compare under the IF condition. Is that helpful? If not, please let know your thoughts around this.
Thanks
thanks for this solution , I could replicate it , but my output is printing the multiple times. e.g I have t items in the field like laptop Mobile. so the output will be Laptop,Mobile,Laptop Mobile. The out is getting print the number of item in the field
Hi
Looks like you having some issues with the mapping? Check my video again.
Thanks
expression for the mapping of select wont work for me, it requires a key to be mapped
Hi
Without seeing your flow its difficult to give you an answer. Looks like you may not have the right mapping.
Thanks
@abm - Thank you for this great video. Your approach to multi-select choice fields is by far the simplest solution I've found on the web. This will really help me a lot with my Flows.
Hi Wendy
Thanks a lot for the support and comments.
Great tutorial and best way to deal with multi choice column values! Thank you!
Question, after the Join, how could I compare the value of the Join output with a value from another share point list? In the video you manually type the value “o/s” in the if condition but what it I just want to grab all values at once instead of one by one?
Hi
Thanks for the support. So after the join you will have a string of values separated by commas. So to compare the whole value from another SharePoint list you need to add Get Items and set the filter query with column name eq 'output from the join'.
Thanks
Your solution worked but I'm experience a big difference in run time. Prior to adding the select and join functions, it took my flow an hour to run. Now its 4 hours. Any idea what could be causing this and is there a solution to reduce the run time?
Hi
How many records you having?
Thanks
@@abm4975 I resolved the issue, there was a typo. I have almost 5000 records
Fantastic
@@abm4975 Hello there! Thank you for sharing your solution. I was wondering if you could help me with a question I have. Based on this solution, I built a flow that automatically triggers whenever an item is modified on a specific SharePoint list. At present, the list contains over 4000 records, and it takes quite a while for the flow to run. The Select and Join steps in particular seem to be taking up most of the time. I suspect this is because the flow is reviewing all 4000+ records in the list. In my case, the flow checks four different multiple-choice columns, which means there are four different Selects and Joins.
Is there any way to limit the "Select" step to only review the modified record rather than checking all of them? Any assistance would be greatly appreciated.
Hi
Are you running this daily then look for modified on date to filter against from SharePoint. That might do the trick.
Thanks