FILTER(Template, [Template_ID] = tks) selects ALL rows, why?

[random9]

I tried to change only the rows with tks, but my action changed every Package_ID to "1".
How?

FILTER(Template, true) selects ALL rows.

FILTER(Template, [Template_ID] = tks) also selects ALL rows. How?

Select all rows that fit property

Change the Package_ID of those packages

[WillowMobileSys · Accepted solution]

---

@random9 wrote:

FILTER(Template, [Template_ID] = tks) also selects ALL rows. How?

---

What is the data type for Template_ID?  If it is a Ref column, are the values shown in your table the Row Keys?

I don't think it should make a difference but I always wrap text literals in quotes :

FILTER(Template, [Template_ID] = "tks")

Other than that, the values in your actions don't match your results so it is a bit confusing if these were the actual actions you used or some other actions that might actually have an issue.  Can you clarify?

[WillowMobileSys · Accepted solution]

---

@random9 wrote:

FILTER(Template, [Template_ID] = tks) also selects ALL rows. How?

---

What is the data type for Template_ID?  If it is a Ref column, are the values shown in your table the Row Keys?

I don't think it should make a difference but I always wrap text literals in quotes :

FILTER(Template, [Template_ID] = "tks")

Other than that, the values in your actions don't match your results so it is a bit confusing if these were the actual actions you used or some other actions that might actually have an issue.  Can you clarify?

[random9]

Good call for the type of Template_ID: It was a number in a different table, now I changed it to Text.

Quotes for literals don't make a difference. Thank you 🙂

[jaichith]

FILTER(Template, [Template_ID] = "tks")

Or

Select(Template, [Template_ID] = "tks")

[random9]

Select does not work. I did put the tks in quotes though.

[WillowMobileSys · Accepted solution]

SELECT will work...just not as written.  Need to insert the Row Key column before the comma.  

SELECT(Template[Row Key], [Template_ID] = "tks")

This is equivalent to the FILTER() 

[random9]

Again, thank you very much!