cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Kudo Kingpin
Kudo Kingpin

Split - Accessing specific row (by index)

I have a comma separated list which I split into a table with the Split() function. But I'm not certain how I can access a row directly by index? Something like this would be logical (where CurrentIndex is a variable somewhere else in the screen):

 

Split(AxisXLabels; ",")[CurrentIndex]

 

Any advice?

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Power Apps
Power Apps

Re: Split - Accessing specific row (by index)

Currently there is no function to access directly an item by a specific index - you can consider creating a new feature request in the PowerApps Ideas board for this.

 

Notice that you already can do that, using a pair of FirstN and Last functions: to access the N-th item in a table, you can use the following expression:

Last(FirstN(table, N))

In your case, you can get the value as

Last(FirstN(Split(AxisXLabels; ","); CurrentIndex))

View solution in original post

8 REPLIES 8
Highlighted
Power Apps
Power Apps

Re: Split - Accessing specific row (by index)

Currently there is no function to access directly an item by a specific index - you can consider creating a new feature request in the PowerApps Ideas board for this.

 

Notice that you already can do that, using a pair of FirstN and Last functions: to access the N-th item in a table, you can use the following expression:

Last(FirstN(table, N))

In your case, you can get the value as

Last(FirstN(Split(AxisXLabels; ","); CurrentIndex))

View solution in original post

Highlighted
Kudo Kingpin
Kudo Kingpin

Re: Split - Accessing specific row (by index)

Thanks for the workaround 🙂 I did a LookUp to work around this, but your idea is better/shorter for my use.

 

Actually someone already proposed an index based approach to collection/tables and it was declined:

 

https://powerusers.microsoft.com/t5/PowerApps-Ideas/Collection-indexer-Collection-index/idi-p/2591

Highlighted
Advocate II
Advocate II

Re: Split - Accessing specific row (by index)

Thanks for the solution. Seeminly complex problem with a simple solution. Thanks 

Highlighted
Advocate III
Advocate III

Re: Split - Accessing specific row (by index)

I don't understand this, can someone give a complete example? I have a collection that has one column and four rows. The column is called "ID", so it looks like this:

ID
2
8

10

15

 

I would like to access the value in the third row, 10. However, this syntax:

Last(FirstN(colLabelChangeIDs,2))

does not work. The error says: 
"The property expects text values. But this rule produces incompatible record values".

 

I have seen this error a lot and understand that it has to do with records vs. single values. 

 

However, the description of "FirstN" is so laughably inadequate in the Microsoft "documentation" it's impossible to understand how it works.

 

 

Highlighted
Power Apps
Power Apps

Re: Split - Accessing specific row (by index)

If you have that expression in a Label, then you need to access the ID property of your collection:

Last(FirstN(colLabelChangeIDs,2)).ID

Notice that this will show you the value in the second row, not the third one (as the first element has index 1). To show the third ID from your collection (i.e., the number 10), you'd use this expression:

Last(FirstN(colLabelChangeIDs, 3)).ID

Hope this helps.

Highlighted
Advocate IV
Advocate IV

Re: Split - Accessing specific row (by index)

I notice this doesn't work for me.

I tried to pull appart a string   "69, 85, 101, 0.8"  to feed the parts into the RGBA funtion to color a label alike.

 

To get something usable, I had to add the .Result and use the Value function, even though the strings comming out of the Split seemed appropriate input. 

 

RGBA(
Value( First( Split( FocusBorder.Text,",") ).Result ),
Value( Last( FirstN( Split( FocusBorder.Text,","), 2) ).Result ),
Value( Last( FirstN( Split( FocusBorder.Text,","), 3) ).Result ),
Value( Last( Split( FocusBorder.Text,",") ).Result )
)

 

Thanks for the  Last( FirstN( array , N) )   trick!!

Highlighted
Advocate III
Advocate III

Re: Split - Accessing specific row (by index)

Brilliant workaround! @CarlosFigueira  Thanks.  Works for my needs.


Last(FirstN(table, N))

 

Highlighted
Frequent Visitor

Re: Split - Accessing specific row (by index)

I have done By this Logic

Select(Parent);RemoveIf(ProductList, Index = Gallery2.Selected.Index);

 

Clear(collection2);

ForAll(ProductList,
Collect(collection2,
{
Index: CountRows(collection2)+1,
Comments: Comments,
SalesPrice: SalesPrice,
Discount: Discount,
Quantity: Quantity,
Height: Height,
Width: Width,
Color: Color,
ProfileSet: ProfileSet,
Product: Product,
Group: Group
}
)
);
Clear(ProductList);
ForAll(collection2,
Collect(ProductList,
{
Index: Index,
Comments: Comments,
SalesPrice: SalesPrice,
Discount: Discount,
Quantity: Quantity,
Height: Height,
Width: Width,
Color: Color,
ProfileSet: ProfileSet,
Product: Product,
Group: Group
}
)
);
Set(ValueToIncrement, CountRows(ProductList));

wrote: -Jayprakash Birla

Helpful resources

Announcements
secondImage

New Return to Workplace

Reopen responsibly, monitor intelligently, and protect continuously with solutions for a safer work environment.

August 2020 CYST Challenge

Check out the winners of the recent 'Can You Solve These?' community challenge!

Experience what’s next for Power Apps

Join us for an in-depth look at the new Power Apps features and capabilities at the free Microsoft Business Applications Launch Event.

Check this Out

Helpful information

Featuring samples like Return to the Workplace and Emergency Response Applications

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Users online (3,637)