Answered

Update a Variable to ThisItem after Submit form

(0) Share

Report

Posted on by diannottismh

I am trying to update a variable after submitting an edit form. I am looking for something like "OnSuccess:UpdateContext({Variable:ThisItem})" or "OnSuccess:UpdateContext({Variable:LookUp('[dbo].[Table]',ClientID=EditForm.LastSubmit.ClientID)})"

The ClientID is a required unique key in an Azure database.

I already have a variable that updates a display form with "OnSuccess:UpdateContext({Variable2:EditForm.LastSubmit})", but this language does not update the item which other parts of the app rely on.

Thanks for any help.

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Meneghino 6,949 on at

Like (2)

Report
Copy link

Link copied!
I don't use forms, but your second proposed piece of code should work (except it may be slow but can probably be speeded up)
If you need to use the value in other screens of the app then you need to use a global variable like this:
OnSuccess = Set(Variable, LookUp('[dbo].[Table]',ClientID=EditForm.LastSubmit.ClientID))
If this is not what you are looking for, please be more specifc about the issue you are having.

Was this reply helpful? Yes No
v-micsh-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @diannottismh,

Do you need any further help on this?

As @Meneghino suggested, please switch updatecontext() function to Set() function, if you would like teh variable to work under other screens.

For the function reference, please check:

Set() function in PowerApps

Understand variables in PowerApps

Regards,

Michael

Was this reply helpful? Yes No
Verified answer

diannottismh 37 on at

Like (0)

Report
Copy link

Link copied!

I added an "If" statement to the onsuccess statement only updating the variable if the record was a new record. This worked. For some reason the update variable did not work when it could be either a new record or an existing record.

Thanks for the help

Was this reply helpful? Yes No
duncant 278 on at

Like (0)

Report
Copy link

Link copied!

What would that look like?

Was this reply helpful? Yes No