Answered

Remove white space from Table data (Large data set)

(0) Share

Report

Posted on by DBTS7

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).

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:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

cha_cha 4,932 Moderator on at

Like (0)

Report
Copy link

Link copied!
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

Was this reply helpful? Yes No
cha_cha 4,932 Moderator on at

Like (0)

Report
Copy link

Link copied!
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

Was this reply helpful? Yes No
MarcelLehmann 378 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No