Forum Discussion
Solved
Adding multiple values in an excel column from a list
Dear all,
I have a excel table where one of the column can contain several values (let's say separated by a ; or , or any other delimiter) that when in editing mode should be picked up from a list of fixed value ... no duplicates are allowed.
Seems that creating that require a little bit of VB and since I am no expert in that was wondering whether someone from that beautiful community could possibly provide a spreadsheet with an example of such 'multiple selections' column.
If no VB script is required to do that, even better!
That'd be awesome!
Thks in advance
ConnM yes you can do this but it can't pick up the list description so you will need to have a column in your list for the subtitle text. But the advantage of that is that the text can then be different for each item. My column for the subtitle is called Note.
{ "elmType": "div", "attributes": { "class": "ms-bgColor-themePrimary ms-fontColor-white" }, "children": [ { "elmType": "div", "style": { "margin": "10px", "width": "100%", "border": "none", "padding": "10px", "display": "=if([$Title] == '' , 'none' , 'flex')", "flex-direction": "column" }, "children": [ { "elmType": "div", "txtContent": "[$Title]", "style": { "text-align": "left" }, "attributes": { "class": "ms-fontSize-28 ms-fontWeight-bold" } }, { "elmType": "div", "txtContent": "[$Note]", "style": { "text-align": "left", "display": "=if([$Note] == '' , 'none' , '')" }, "attributes": { "class": "ms-fontSize-16" } } ] } ] }This is the result:
Rob
Los Gallardos
Microsoft Power Automate Community Super User.
Principal Consultant, SharePoint and Power Platform WSP Global (and classic 1967 Morris Traveller driver)
2 Replies
- Thanks a lot
