web

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

News and Announcements icon

Power Platform CommunityForums Power Apps How to modify/add a Ta...

Power Apps

Answered

How to modify/add a Table entry?

(0) Share

Report

Report

Posted on by Berat Cakir Microsoft Employee

Say, I create a Table in a global variable via:

Set(MyTable, Table({Name: "John", Age: 30}))

Question 1: How do I modify the age of John? Following doesn't work at all, nor did Patch()

UpdateContext({MyTable: {Name: "John", Age: 32}})

Question 2: How do I create a new entry if a person does not exist? (Name here acts as an UID)

UpdateContext({MyTable: {Name: "Tim", Age: 19}})

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

Verified answer

timl 37,283 Super User 2026 Season 2 on at

Like
a
(1)

Report
Copy link

Link copied!
@Berat-Cakir

It's not possible to update and modify the items in a table variable in the way that you want.

Unless there's any specific reason for you to use a table variable, it would be easier for you to store the values in a collection.

Here's how to create the collection:

ClearCollect(colYourTable, {Name: "John", Age: 30})

Here's how to update a record:

UpdateIf( colYourTable, Name="John", {Age:32} )

Here's how to add a new record:

Patch( colYourTable, Defaults(colYourTable), {Name: "Tim", Age: 19} )

Was this reply helpful? Yes No
Berat Cakir Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Many thanks! That would work too 🙂

Was this reply helpful? Yes No

Join the conversation