Error: Cannot use record values in this context

[Daemetius]

Hello, 

I have an issue where I've been stuck for weeks and hoping to see if someone can help or had this before.

So I am trying to create a comments gallery within a parent record. E.g: A comment section from an idea posted by a user. 

The filter function I was told is good to use since I have lookup fields in my sharepoint lists used as data sources. 

Filter(Comments, IdeasGallery.Selected.ID in TargetID) but I get an error under "TargetID" saying "Invalid argument type. Cannot use record values in this context"

To get a better picture of what I'm trying to do. 

I have a Sharepoint list called "Ideas" and another list called "Comments". I created two lookup fields in the Comment's list called TargetID and TargetID: Subject.

TargetID points to the ID field in the "Ideas" sharepoint list showing the corresponding ID while the TargetID: Subject field shows the corresponding title of the Idea. 

So I have:

The Ideas Sharepoint List

The Comments Sharepoint List

The Comments list shows the TargetID: Subject, which is the subject that is tied to the TargetID. The TargetID is the ID taken from the Ideas Sharepoint list. 

What I am looking for is that for example in the comments list, the TargetID, 16 is repeated and has different comments for the same idea. I need to filter it in the PowerApps gallery so that only the comments for that idea are only shown.

Any help is greatly appreciated.

[Sienna]

I'm sure this will work

Filter(Comments, TargetID=IdeasGallery.Selected.ID)

[Daemetius]

---

@Sienna wrote:

I'm sure this will work

Filter(Comments, TargetID=IdeasGallery.Selected.ID)

---

The = operator gives an error stating "Invalid argument type"

Just in case: I'm adding the filter function on the CommentGallery "Items" field, since I added a "Comments Gallery" on the DetailScreen of the record. 

[Sienna]

Can you also try

Filter(Comments, Value(TargetID)=Value(IdeasGallery.Selected.ID))

Just in case your IDs are not formated as numbers

[Daemetius]

---

@Sienna wrote:

Can you also try

Filter(Comments, Value(TargetID)=Value(IdeasGallery.Selected.ID))

Just in case your IDs are not formated as numbers

---

I get two errors underlined "Value(TargetID)"

1. Expected text or numeric value (When mousing over TargetID)

2. The function "Value" has some invalid arguments

TargetID is not numeric, it's Lookup type in the Comments table. Is there away to turn it numeric or text? I can only think of having calculated column

[Anonymous]

I don't have much experience with Sharepoint Lists but I read some posts in the community that suggests you have to use the Value property of the column in some cases (e.g. selections, foreign keys, etc.).

Have you tried this?

Filter(Comments, TargetID.Value = IdeasGallery.Selected.ID)

[Sienna]

I'm not sharepoint expert at any point so I'm afraid I can't help you with this. The IDs should numeric or at least same type if you won't be using <> and I guess they should be transfer in SP. I don't think you can do it in powerapps if Value() doesn't work. Sorry

[Daemetius]

---

@Anonymous wrote:

I don't have much experience with Sharepoint Lists but I read some posts in the community that suggests you have to use the Value property of the column in some cases (e.g. selections, foreign keys, etc.).

Have you tried this?

Filter(Comments, TargetID.Value = IdeasGallery.Selected.ID)

---

It's been tried but no avail. 

[Anonymous · Accepted solution]

Did it produce the same error? Note that Value is not a function unlike previously suggested, but a property now.

TargetID seems to be a record. If you enter a period (.) after TargetID, there should be some suggestions. Some of those would be the actual fields of the record. If there are, what are they?

And I'm gonna take a wild guess and have you try this:

Filter(Comments, TargetID.ID = IdeasGallery.Selected.ID)

[Daemetius]

---

@Daemetius wrote:

---

@Anonymous wrote:

I don't have much experience with Sharepoint Lists but I read some posts in the community that suggests you have to use the Value property of the column in some cases (e.g. selections, foreign keys, etc.).

Have you tried this?

Filter(Comments, TargetID.Value = IdeasGallery.Selected.ID)

---

It's been tried but no avail. 

---

Ok, no error this time, but the CommentsGallery is empty so that's something at least.