web

You’re offline. This is a read only version of the page.

Power Platform CommunityForums Power Apps - Building Power Apps PowerApps remove last ...

Power Apps - Building Power Apps

Answered

PowerApps remove last part of string

Like (0) Share

Report

Report

Posted on 1 Mar 2023 16:43:36 by Krentor

70

Hello,

in PowerApps forms, i have a string /sites/SkoleniSFRB/Reporty/DataSP/01.jpg. I need to remove part 01.jpg so string remains.

Can please someone help me?

Thank you.

Categories:

Using Apps Using Formulas

I have the same question (0)

All responses Img

All responses (4)

Answers Img

Answers (1)

Krentor 70 on 01 Mar 2023 at 16:57:21

Like (1)

Report

Re: PowerApps remove last part of string

Thank you very much! That helped me. Love this community.

Regards,
Jakub

Was this reply helpful? Yes No
TheRobRush 11,123 Moderator on 01 Mar 2023 at 16:53:19

Like (0)

Report

Re: PowerApps remove last part of string

Use the method I outlined in my response, it will work regardless of the file name, or length of rest of fullpathname etc.

Was this reply helpful? Yes No
JmeBrey 55 on 01 Mar 2023 at 16:49:03

Like (1)

Report
Re: PowerApps remove last part of string

Yes , a few ways to achieve this - you will have to select which is the best option for you, for example if the string can end with different file names, you may need to adjust the formula accordingly.

Substitute("/sites/SkoleniSFRB/Reporty/DataSP/01.jpg", "/01.jpg", "")

Replace("/sites/SkoleniSFRB/Reporty/DataSP/01.jpg", Right("/sites/SkoleniSFRB/Reporty/DataSP/01.jpg", 6), "")

This formula uses the "Right" function to extract the last 6 characters (which is the length of "01.jpg"), and then uses the "Replace" function to replace those characters with an empty string, effectively removing them from the original string

Left("/sites/SkoleniSFRB/Reporty/DataSP/01.jpg", Len("/sites/SkoleniSFRB/Reporty/DataSP/01.jpg")-6)

This final one is good if you want to remove everything after the last "/" regardless what the text is
Concat(Split("/sites/SkoleniSFRB/Reporty/DataSP/01.jpg", "/"), "/", CountRows(Split("/sites/SkoleniSFRB/Reporty/DataSP/01.jpg", "/"))-1)

Was this reply helpful? Yes No
Verified answer

TheRobRush 11,123 Moderator on 01 Mar 2023 at 16:47:26

Like (1)

Report
Re: PowerApps remove last part of string

where Label10 is our string

Concat(FirstN(Split(Label10.Text,"/"),CountRows(Split(Label10.Text,"/"))-1),Result,"/")&"/"

Was this reply helpful? Yes No