Quick Loop Help!

(0) Share

Report

Posted on by TheBest355

Good afternoon,

Fellow PowerApp Masters!

I have a basic question but cannot get my head around it.

I have a collection.

All I want to do is remove the comma for any values that have a comma at the end of the string.

I tried the below based on online research but it does not work.

ForAll(myFinalDivanData2,
        If(Right(DivOutput = ",",-1), Len(DivOutput),-1));
 
Any ideas, how to remove the commas from the DivOutput Columnn which has 7,7,7,
 
Your help is much appreciated I know it is simple but tried different ways but they don't work.
 
Thanks,
 
OS

Categories:

General Questions

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

timl 35,805 Super User 2025 Season 2 on at

Like (2)

Report
Quick Loop Help!

Hi TheBest355

This formula will strip all trailing commas from the DivOutput column.

UpdateIf( myFinalDivanData2, true, { DivOutput: If( Right(DivOutput, 1) = ",", Left(DivOutput, Len(DivOutput) - 1), DivOutput ) } )

Was this reply helpful? Yes No
TheBest355 59 on at

Like (1)

Report

Quick Loop Help!

Thank you so much :)

Was this reply helpful? Yes No