cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Gargoolgala
Resolver II
Resolver II

New Split function table

Hi - with the new split function it splits the data in to a table.  How do you access this table to use the data?

 

I was thinking to use it as a helper on working around the current limitation of powerapps not working with sharepoint multi-select choice options. e.g. select items in listbox and concat them to a text box which is saved in sharepoint.

 

Then when I open that record on a form to edit I am thinking I could use the split function to get the value and split it out and set it as the default value on load of the screen for the listbox - this way I am setting the values and they can be edited accordingly.

 

I just need help on how to use the split table and I suppose then how to set it as the default values for a list box.

 

Either that or if someone knows when choices will be compatible I may just wait as doing this would be a lot of work as I may have 100's of listbox's in my assessment form.

 

Any assistance is appreciated. 

9 REPLIES 9
v-monli-msft
Community Support
Community Support

Hi @Gargoolgala,

 

I have found some documentations, please check if they could help:

https://powerapps.microsoft.com/en-us/blog/powerapps-update-690/

https://community.powerapps.com/t5/PowerApps-Ideas/Function-to-split-a-string-into-a-table-with-resu...

https://powerapps.microsoft.com/sk-sk/tutorials/function-split/

 

Regards,

Mona

Community Support Team _ Mona Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Mona - I have found all of these links but none of them actually answer my question - thanks anyway

So, the split function itself returns a table object with one column of data labeled "Result".

 

You can use the name of the column (Result) to act on the data from the split in anyway you need.

 

For example, consider the following function:

 

Filter(Split("hey!dude!hey!","!"), Result <> "hey")

 

yields a table object:

 

Result

---------

"dude"

 

 

Does this make sense?

CarlosFigueira
Power Apps
Power Apps

While you can now use the Split function to break down your single value into multiple, the listbox currently doesn't support multiple selections by default.

 

Please vote up the idea at https://powerusers.microsoft.com/t5/PowerApps-Ideas/Listbox-Pre-Selection-of-Listbox-from-Existing-r... to increase the priority of that feature with the product team.

Carlos - thanks for pointing this out as I was trying to essentially set teh default of a listbox t othe split results which I see now is not supported.

 

This comes back to the issue of PowerApps not supporting Choices with multiple selections which I know is set as "Planned" - who knows when that means but for me it means PowerApps is useless for now as I need to use it for assessments/surveys with multi-select - of which I need to be able to come back to and edit.

 

I would hope the idea I up voted will be incorporated in to the Choice multi-select enhancement - I see it going hand in hand.

Yes, multi-select listbox (or better support for multi-select choice columns in Sharepoint) is a commonly asked feature. There is a workaround, using a gallery to implement the multi selection. I just wrote a blog post with more details about how this can be accomplished

 

Take a look at https://blogs.msdn.microsoft.com/carlosfigueira/2017/09/15/supporting-multi-valued-listboxes-in-powe... for more information.

 

Hope this helps!

Carlos,

 

thanks for this but I fall into the category of needing to use a scrolling canvas and datacards so this does not work for me.

 

The listbox and multiple choices I see has many votes and is right up there on the wish list but only set as planned - not sure how much longer I can wait for this essential feature before being forced into using a different app t ocreate the forms I need.

 

Any clue on when the required enhancements to listboxes will be???

 

Thanks

I posted yet another workaround for this scenario, this time one that works in forms - using different controls (such as checkboxes) to present the choices to the user. I'd expect something that will make this scenario easier to be released soon, but I don't know for sure when that will be.

Multi-select choice fields now supported with SharePoint lists.

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Solution Authors
Top Kudoed Authors
Users online (3,328)