Trim - last text

(0) Share

Report

Posted on by kinghnvn

Hi Experts,

I have the following text string

Text = Concat(selectedDesks, Title, ", ")

Desk 5, Desk 5, Desk 4, Desk 5, Desk 5, Desk 4, Desk 4, Desk 4, Desk 3, Desk 3, Desk 2, Desk 4, Desk 4, Desk 2, Desk 5, Desk 4, Desk 4, Desk 4, Desk 4, Desk 2, Desk 2, Desk 9

How can I get last text?

Result is Desk 9

Thanks.

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

CU-18081211-6 9,270 Moderator on at

Like (1)

Report
Copy link

Link copied!

@kinghnvn ,

It depends on the type of the SharePoint column you want to save the data.

If it is a simple text, then the formula above is enough. If is a choice or a lookup column then you can use

LookUp(Choices(TableName.ColumnName),Value=Last(selectedDesk).Title))

Was this reply helpful? Yes No
kinghnvn on at

Like (0)

Report
Copy link

Link copied!

yes. that's right. thank you so much!

Was this reply helpful? Yes No
kinghnvn on at

Like (0)

Report
Copy link

Link copied!

@gabibalaban

It works fine. thanks.
Do you know how can save last desk title to SharePoint when click on Confirm button?

Was this reply helpful? Yes No
timl 36,558 Super User 2025 Season 2 on at

Like (1)

Report
Copy link

Link copied!
@kinghnvn

You could maybe just try to retrieve the last value from selectedDesks like so:

Last(selectedDesks).Title

Was this reply helpful? Yes No
Verified answer

CU-18081211-6 9,270 Moderator on at

Like (1)

Report
Copy link

Link copied!
@kinghnvn ,

Last(selectedDesks).Title

Hope it helps !

Was this reply helpful? Yes No