Answered

Getting "'ThisItem' isn't recognized" in a formula

(0) Share

Report

Posted on by JF000001

I have an Edit Form, for which I am trying to update a column (MyColumn) with a value upon submitting the said Form. I have the following formula in OnSelect. Meanwhile, I obtain an error stating 'ThisItem' isn't recognized. Why is this? How can I reference the current record?

SubmitForm(MyFormEdit); Patch(MyTable,ThisItem,{MyColumn:"MyValue"}); Navigate(ScrMain);

Categories:

Building Power Apps

All responses (5)

Answers (1)

Sort by

Verified answer

WarrenBelz 156,536 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @JF000001 ,

It depends where your button is situated (if not inside the Form, ThisItem has no relevance). You are however better putting the Patch on the OnSuccess of the Form after submission.

Patch( MyTable, {ID: Self.LastSubmit.ID}, {MyColumn:"MyValue"} ); Navigate(ScrMain);

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps
JF000001 36 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you very much @WarrenBelz This is working, and solves part of my issue. I had another related question if I may. I am trying to update the field above, not with a hard-coded value as specified initially, but with the value of another column from the same table, which is a LookUp column, consisting of a relationship to another table. How can I get the value of that Lookup? Thank you again.
WarrenBelz 156,536 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @JF000001 ,

Just replace "MyValue" with

Self.LastSubmit.LookupColumnName.Value

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps
JF000001 36 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you @WarrenBelz I had actually tried this, but I am receiving the following two errors with this formula. This column consists of a lookup/relationship to another table. (Just to specify, 'MyColumn', is of type Text).

The type of this argument 'MyColumn' does not match the expected type Text. Found type Error.
Name isn't valid. 'Value' isn't recognized.
WarrenBelz 156,536 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

@JF000001 ,

What is your data source here ?