Unanswered

Display last line from a multiline column from SP list

(0) Share

Report

Posted on by Angiellyn01

Hi, I'm new to PowerApps and I'm trying to build a gallery that display lists of project updates. i have a SharePoint column in multiline, i want to display the last line inside the column in my gallery. I used this formula Right(ThisItem.'Date for next step',55). my problem is the of characters are moving and because im not sure how many characters will there be in the last line i couldn't figure how to do it..

This is how my SP List column looks like:

and this is how i would like to show it up on my PowerApps:

please help... thank you in advance..

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

rb 835 Super User 2024 Season 1 on at

Like (1)

Report
Hey @Angiellyn01,

You can use Split() when working with multiple lines of text, to turn them in to a table of lines, then all you need to do is get the last record in the Table! Eg:
Last(Split(ThisItem.'Date for next step', Char(10))).Result

Was this reply helpful? Yes No
Angiellyn01 15 on at

Like (1)

Report

@metsshan omg! that works perfectly for my current need.. thank you so much!!!

Was this reply helpful? Yes No