Unanswered

Submit Form and ThisItem doesn't update

(0) Share

Report

Posted on by senna

189

I have a canvas app, very basic run off a SP list, when I submit the form I stay on the form page and the SP list is updated but "ThisItem.XXXX.Value" will not get updated. I have some logic for thisitem but that logic doesn't get updated as thisItem seems to stay on the value from when the form loaded.

Any suggestions on refreshing it?

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (0)

v-qiaqi@microsoft.com on at

Like (0)

Report

Hi @CiaranCampbell,

More details are needed about "ThisItem.XXXX.Value" will not get updated.

Which control and which property you set for this "ThisItem.XXXX.Value"

Was this reply helpful? Yes No
Ramole Super User 2024 Season 1 on at

Like (0)

Report

Hi @CiaranCampbell
Are referring a lookup column or Choice field? if in that case check your Update of the Data Card, check what you have and make sure the datacardvalue name you should have something like this DataCardValue.Selected

Was this reply helpful? Yes No
senna 189 on at

Like (0)

Report

Thank you @Ramole & @v-qiaqi-msft
Here is an example, its a choice field in SP list called Status, for test here i have a label in the field that shows what the ThisItem.status.Value is.
1. When I open form it is New Application;
2. In the DefaultSelectedItems for this dropdown i have some logic like;
If(
DataCardValue39.Selected.Value="Yes",
LookUp(
Choices([@myList].status),
Value = "Equipment Ordered"
)
)
3. I change "DataCardValue39.Selected.Value" to be Yes and click button with SubmitForm(MyForm) on select
4. My SP List is now has correct Status
5. The value for "ThisItem.status.Value" still stays at New Application;
This is update for my card, it is correct because my list is correct

I need the form to be refreshed in some way but do not want to have the user navigate away and back to form again

Was this reply helpful? Yes No
v-qiaqi@microsoft.com on at

Like (0)

Report
Hi @CiaranCampbell,

I think you could set the following formula for the OnSuccess property of the edit form:

ResetForm(FormName)

Remember to set the DefaultMode of your form as Edit.

Was this reply helpful? Yes No
senna 189 on at

Like (0)

Report

Thank you @v-qiaqi-msft but resetForm does not update the value of ThisItem.status.Value

Was this reply helpful? Yes No
v-qiaqi@microsoft.com on at

Like (0)

Report
HI @CiaranCampbell,

Well, you need to check how you set the Item property of your edit form.

You could retrieve the latest status value by the formula you set for the Item property of your edit form.

if you set the property of your edit form as Gallery.Selected, then you could set the Label text property with:

Gallery.Selected.Status.Value

Was this reply helpful? Yes No