web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Remove white space fro...
Power Apps
Answered

Remove white space from Table data (Large data set)

(0) ShareShare
ReportReport
Posted on by

Hi,

Below is the logic by which I'm removing white spaces from this table, but I'm getting delegation warning by using both (Trim and Substitute).

DBTS7_0-1670303049575.png

is there any other way to remove white spaces and sort the gallery items? I don't want to use collections for this.

 

Thanks

Categories:
I have the same question (0)
  • Verified answer
    cha_cha Profile Picture
    4,932 Moderator on at

    Hello @DBTS7 

     

    Use AddColumns 

    Warning: If there is a Form that changes its value using Gallery, it will affect it.

    Sort(AddColumns(Filter(YourTable,Id=User().Email),"TrimmedData",Substitute(__________)), TrimmedData, Ascending)

     

    Another way is probably just clean your Source Data.


      ✔️
    Just in case my response helped you solve your problem, please mark/accept this as a SOLUTION This helps community members if they experience a similar issue in the future.

     

      🔗
    🕸bistek.space  🐦 @cha_bistek  📺 @BisTekSpace 
  • cha_cha Profile Picture
    4,932 Moderator on at

    Hello @DBTS7 

     

    Use AddColumns 

    Warning: If there is a Form that changes its value using Gallery, it will affect it.

    Sort(AddColumns(Filter(YourTable,Id=User().Email),"TrimmedData",Substitute(__________)), TrimmedData, Ascending)

     

    Another way is probably just clean your Source Data.


      ✔️
    Just in case my response helped you solve your problem, please mark/accept this as a SOLUTION This helps community members if they experience a similar issue in the future.

     

      🔗
    🕸bistek.space  🐦 @cha_bistek  📺 @BisTekSpace 
  • MarcelLehmann Profile Picture
    378 on at

    U could use the solution of @cha_cha but u also could ignore the delegation warning.

     

    Cause the inner filter is closed so u'll have the 'delegation warning' just for the response response. I use often filter in filter... The first filter(s) shouldn't have the warnings but if u know you'll get then under 500 (to 200 records ... U could change that) back it doesn't matter.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 380 Most Valuable Professional

#2
Kalathiya Profile Picture

Kalathiya 340

#3
MS.Ragavendar Profile Picture

MS.Ragavendar 333 Super User 2025 Season 2

Last 30 days Overall leaderboard