web

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

News and Announcements icon

Power Platform CommunityForums Power Apps Remove Values from a T...

Power Apps

Answered

Remove Values from a Table

(0) Share

Report

Report

Posted on by JeffGimo

221

Hi,

I am trying to remove specific number from unitNum.

I have another table that has this numbers. I want to remove these numbers from unitNum variable.

Is that possible? I have tried looking for solutions but I can't find similar problems.

Kind regards,

Jeff

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

Verified answer

mdevaney 29,991 Moderator on at

Like (0)

Report
Copy link

Link copied!
@JeffGimo
The main issue here is you are storing values in a variable when they would be better off stored inside a collection. To create a collection with the values "1" to "100" do this.

ClearCollect(unitNUM, ForAll(Sequence(100), Text(Value)));

Then to remove a specific number from unitNUM you can use this code. In my example the number "45" is being removed.

RemoveIf(unitNUM, Value="45")

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

Was this reply helpful? Yes No
JeffGimo 221 on at

Like (0)

Report
Copy link

Link copied!

Thank you so much this approach is much easier. Cheers!

Was this reply helpful? Yes No

Join the conversation