You turned an already very good video and upped your game for an even better one with multiple use cases. Thanks for such a clear explanation (twice!).
Great video! But what if I wanted to use metadata columns on my SharePoint list from that form? Term store tags can be better across a site collection for consistent and managed data. But is it worth the effort to do something like what you did from a form? Is it even possible?
Setting managed metadata columns is pretty much the same as setting choice columns. If it's a single-select column, you just need to feed it the value. If it's a multi-select, it needs to be an array of the values in the appropriate format.
@cvkealey exact matched values from form choice to column metadata choices, letter for letter, or is there something else funky with the metadata tags because they are no longer simple choice pills and are in the term store library?
@@chriswho6794 Actually, it's a bit more complicated. The instructions here should help get you there, though: tomriha.com/how-to-update-sharepoint-managed-metadata-column-power-automate/
In the select multi select step of your tutorial, I found that I do not have an "expression" option. I have "Function" and "Dynamic content". I was able to find the json code under function, and that seems to be the same, but after that, it will not let me pull dynamic content in the From field, within the json parentheses. It says no dynamic content is available. Is there a work around? What can I type to hard code it in?
Function (the fx button/icon) is the same as expression. For the purpose of this video, the data in a multi select choice question response is just a one column array of the selected options. What is it you want to do with those values?
@@cvkealey Thank you so much for responding! I have a multi choice question on my form that I am trying to parse over to my Sharepoint list. I am trying to enter the Multi select plain option from dynamic content, within the Json function. When I enter the json function, json(value), no dynamic content is populating for me to put in the value field. It says dynamic content not available. It will let me type into the editor, can I manually type something in the value area to make it work?
@@ltimestwo It might be best to post a message in the Power Automate Community (powerusers.microsoft.com/t5/Building-Flows/bd-p/BuildingFlows) with some screenshots of your flow. You can tag me there (@ChadVKealey) and I'll take a look.
Hi Chad its a very useful video! I couldnt find the advanced options to single select plain value or multi select plain value, as I can only see the advanced parameters thats all so my list only shows an array of values. How do I make it into many pop up values like the one in the video?:)
Hi Chad! Unfortunately, I didn't find an email address on the About page. Is there any way to contact you and discuss possible collaboration on the content? Thank you.
Do you mean how do you enable that in the Form? If so, you just click the "Add "Other" option" link below your choice question in the form. Or, do you mean how do you get the value to send to SharePoint? I show how to get the value right here: ruclips.net/video/-3CvB3Cq69o/видео.html.
@@cvkealey Thank you for your reply. But when I try to add or type a text response (under other) when filling a form response (like in 2.13 min in your ruclips.net/video/-3CvB3Cq69o/видео.html) , it doesn't allow me to do it (its just a selction). How does it work on your end?
@@ChamilaRupasinghe-w8r It's a setting on the question in the form. As a user filling out the form, you cannot enable it. Someone with editing access to the form needs to enable the "Other" option in that question.
This is amazing, thank you so much!
You turned an already very good video and upped your game for an even better one with multiple use cases. Thanks for such a clear explanation (twice!).
Great video! But what if I wanted to use metadata columns on my SharePoint list from that form? Term store tags can be better across a site collection for consistent and managed data. But is it worth the effort to do something like what you did from a form? Is it even possible?
Setting managed metadata columns is pretty much the same as setting choice columns. If it's a single-select column, you just need to feed it the value. If it's a multi-select, it needs to be an array of the values in the appropriate format.
@cvkealey exact matched values from form choice to column metadata choices, letter for letter, or is there something else funky with the metadata tags because they are no longer simple choice pills and are in the term store library?
@@chriswho6794 Actually, it's a bit more complicated. The instructions here should help get you there, though: tomriha.com/how-to-update-sharepoint-managed-metadata-column-power-automate/
In the select multi select step of your tutorial, I found that I do not have an "expression" option. I have "Function" and "Dynamic content". I was able to find the json code under function, and that seems to be the same, but after that, it will not let me pull dynamic content in the From field, within the json parentheses. It says no dynamic content is available. Is there a work around? What can I type to hard code it in?
Function (the fx button/icon) is the same as expression. For the purpose of this video, the data in a multi select choice question response is just a one column array of the selected options. What is it you want to do with those values?
@@cvkealey Thank you so much for responding! I have a multi choice question on my form that I am trying to parse over to my Sharepoint list. I am trying to enter the Multi select plain option from dynamic content, within the Json function. When I enter the json function, json(value), no dynamic content is populating for me to put in the value field. It says dynamic content not available. It will let me type into the editor, can I manually type something in the value area to make it work?
@@ltimestwo So, when you go to the Dynamic Content, you're not seeing the outputs from the "Get response details action" in your flow?
@@ltimestwo It might be best to post a message in the Power Automate Community (powerusers.microsoft.com/t5/Building-Flows/bd-p/BuildingFlows) with some screenshots of your flow. You can tag me there (@ChadVKealey) and I'll take a look.
Hi Chad its a very useful video! I couldnt find the advanced options to single select plain value or multi select plain value, as I can only see the advanced parameters thats all so my list only shows an array of values. How do I make it into many pop up values like the one in the video?:)
Where are you looking for the advanced options? In your form? In Power Automate? In the list or column settings?
@@cvkealey looking for it in Power Automate
If you're using the new editor, "advanced options" is now "advanced parameters". Click the "Show all" button to view them.
Hi Chad! Unfortunately, I didn't find an email address on the About page. Is there any way to contact you and discuss possible collaboration on the content? Thank you.
I'm not sure what sort of "collaboration" you mean. However, I'm on LinkedIn, so you can look me up there and ask to connect.
Great presentation. how do I get a choice "other" which I can type text?
Do you mean how do you enable that in the Form? If so, you just click the "Add "Other" option" link below your choice question in the form. Or, do you mean how do you get the value to send to SharePoint? I show how to get the value right here: ruclips.net/video/-3CvB3Cq69o/видео.html.
@@cvkealey Thank you for your reply. But when I try to add or type a text response (under other) when filling a form response (like in 2.13 min in your ruclips.net/video/-3CvB3Cq69o/видео.html) , it doesn't allow me to do it (its just a selction). How does it work on your end?
@@ChamilaRupasinghe-w8r It's a setting on the question in the form. As a user filling out the form, you cannot enable it. Someone with editing access to the form needs to enable the "Other" option in that question.
@@cvkealey I think I got it. Thanks a million!