You’re offline. This is a read only version of the page.
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.
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))
It works fine. thanks.
Do you know how can save last desk title to SharePoint when click on Confirm button?
Share
Report
All responses (
Answers (
9,261
