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
PA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Power Query PA Forum 768x460.png

Check it out!

Did you know that you can visit the Power Query Forum in Power BI and now Power Apps

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

R2 (Green) 768 x 460px.png

Microsoft Dynamics 365 & Power Platform User Professionals

DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.

Users online (2,886)