Removing extra text

(0) Share

Report

Posted on by PowerAppsUser99

All,

I am inserting data into my SharePoint list from SQL table.

I have this field "Office". I would like to remove the extra text in these values.

For example:
- I want only these values shown. Is it possible to filter it by the text "office?

"Elmwood Park office"

"Elmwood Park Office"

"New York Office"

Categories:

Building flows

I have the same question (0)

All responses (6)

Answers (0)

trad 152 on at

Like (0)

Report

Is the office string that you want always the last of a comma delimited list like you've shown? You might be able to do something like last(split(<office value>,',')) to get the string.

Was this reply helpful? Yes No
Kaif_Siddique 2,108 Super User 2024 Season 1 on at

Like (0)

Report

Hi @PowerAppsUser99 ,

Try to split the value with comma.
--> last(split(Text,','))

If I have answered your question, please mark my post as Solved.
If you like my response, please give it a Thumbs Up.

Regards
Kaif

Was this reply helpful? Yes No
PowerAppsUser99 73 on at

Like (0)

Report

It is either in the front or in the back. It will never be in the middle

would this still work?
last(split(<office value>,','))

Was this reply helpful? Yes No
PowerAppsUser99 73 on at

Like (0)

Report

It is either in the front or in the back. It will never be in the middle

would this still work?
last(split(<office value>,','))

Was this reply helpful? Yes No
grantjenkins 11,063 Moderator on at

Like (0)

Report
If your data is coming back as a string of words seperated by a comma then you could try the following.

See full flow below. I'll go into the actions.

Data is a Compose action that contains the data. This would be the property you already have.

Filter array splits the data by comma, then checks to see if a lowercase version of each item contains 'office'. This will cater for uppercase, lowercase, mixed case, etc. The expressions used are below:
//From - you would replace outputs('Data') with your property split(outputs('Data'), ',') //Filter toLower(item())

Compose retrieves the first item from the Filter array and trims any leading/trailing spaces giving you what you're after. The expression used is:
trim(first(body('Filter_array')))

This should give you the result regardless of where it is in the string.

----------------------------------------------------------------------
If I've answered your question, please mark the post as Solved.
If you like my response, please consider giving it a Thumbs Up.

Was this reply helpful? Yes No
PowerAppsUser99 73 on at

Like (0)

Report

Thank you this did work. I had one more question.

So I have some records with blank/null offices. Can I skip these or remove the blank records?

Was this reply helpful? Yes No