cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Lucas_Ignatius
Helper V
Helper V

Split Command DropDown using SharePoint

I need help , when using "Split" command it not work.

Split Command.jpg

 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
v-xiaochen-msft
Community Support
Community Support

Hi @Lucas_Ignatius ,

 

So, I don't know what your needs are.

Where does your data come from?

If it comes from a sharepoint list, then which record's Title value do you want to split?

 

I assume that your data source is a sharepoint list, and you want to split the Title of the first record.

I did the test for you.

 

1\ This is my list 'LIST99'.

v-xiaochen-msft_0-1616037182201.png

 

 

2\ Add a dropdown control and set its Items property to:

 

Split(First(LIST99).Title, ",")

 

 

3\ The result is as follows:

v-xiaochen-msft_1-1616037456058.png

 

In addition, If you want to use gallery control to achieve a dynamic effect, you could try this operation.

1\ Add a gallery control 'Gallery1' and set its Items property to:

 

LIST99

 

 

2\ Add a dropdown control and set its Items property to:

Split(Gallery1.Selected.Title, ",")

 

3\ The result is as follows:

AAA.gif

Best Regards,
Wearsky
If my post helps, then please consider Accept it as the solution to help others. Thanks.

 

 

View solution in original post

5 REPLIES 5
v-xiaochen-msft
Community Support
Community Support

Hi @Lucas_Ignatius ,

 

ThisItem can only be used in controls such as gallery and form...

So, you created a dropdown control in a screen, the control does not know what "thisitem" is.

 

Best Regards,
Wearsky

If my post helps, then please consider Accept it as the solution to help others. Thanks.

So, for only drop down what command can I use?

or can you suggest any idea?

Thanks

v-xiaochen-msft
Community Support
Community Support

Hi @Lucas_Ignatius ,

 

So, I don't know what your needs are.

Where does your data come from?

If it comes from a sharepoint list, then which record's Title value do you want to split?

 

I assume that your data source is a sharepoint list, and you want to split the Title of the first record.

I did the test for you.

 

1\ This is my list 'LIST99'.

v-xiaochen-msft_0-1616037182201.png

 

 

2\ Add a dropdown control and set its Items property to:

 

Split(First(LIST99).Title, ",")

 

 

3\ The result is as follows:

v-xiaochen-msft_1-1616037456058.png

 

In addition, If you want to use gallery control to achieve a dynamic effect, you could try this operation.

1\ Add a gallery control 'Gallery1' and set its Items property to:

 

LIST99

 

 

2\ Add a dropdown control and set its Items property to:

Split(Gallery1.Selected.Title, ",")

 

3\ The result is as follows:

AAA.gif

Best Regards,
Wearsky
If my post helps, then please consider Accept it as the solution to help others. Thanks.

 

 

View solution in original post

I choose option number 1, because that's all I need, And thanks for your help for option number 2 next will be I can use.

And I've problem there is warning Icon, but the data is okay. Why this happen? There is limitation ?

Split Command 2.JPG

 

v-xiaochen-msft
Community Support
Community Support

Hi @Lucas_Ignatius ,

 

The First() function will not have any bad effect on your application performance.

This is just a warning.

 

(If you have a large amount of data, although some formulas will have delegation warnings and have some impact on the results, the delegation warnings generated by first() will not cause any impact. So please rest assured to use this formula )

If you want to learn more about delegation warnings, I suggest you go here

 

Best Regards,
Wearsky
If my post helps, then please consider Accept it as the solution to help others. Thanks.

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,075)