Unanswered

Refreshing form data

(0) Share

Report

Posted on by MJGreyling

161

Good day,
I have a a gallery where a user selects an item. The OnSelect property of the button then Navigates to a form screen where some of the data in the form is prepopulated form the previous screen.

The user completes one entry and then the data is patched to sharepoint: Patch(CSNonMovingParts, LookUp(CSNonMovingParts, Title=DataCardValue28.Text), {SVO: DataCardValue1.Text, 'Requested by': User().Email, 'Requested on': Now(), Status: "Requested"})

However, I am adding the user name and the date the form was submitted to sharepoint. What I'd like to see is that the form is refreshed and that the two fields REQUESTED BY and REQUESTED ON now contain data and that the field STATUS now say REQUESTED and not AVAILABLE .

U have tried everything I could find that was suggested including setting the OnSuccess property of the edit form to REFRESH(SHAREPOINTLIST NAME) but it doesn't work.

Any ideas?

Categories:

Building Power Apps

I have the same question (0)

All responses (13)

Answers (1)

Digital 1,207 on at

Like (0)

Report
What is in the Items property of your form?

Try putting a lookup to the datasource in the items property of your form so it is always looking up the latest record.

For example:

LookUp(CSNonMovingParts, ID=varSelectedID)

Where varSelectedID is the ID of the currently selected record. You can set this in the Gallery OnSelect.

Was this reply helpful? Yes No
MJGreyling 161 on at

Like (0)

Report

The Item property of the form has: selectedId in. This I had to do to get the form to populate the data coming from the gallery.

I thought if I took your suggestion and put it in the OnSuccess Property it would work BUT i get Incompatible types: (It does the same if I do it in the ITEM property)

Was this reply helpful? Yes No
Digital 1,207 on at

Like (0)

Report
You could try setting a variable in the gallery on select e.g.

Set(varSelectedItem,ThisItem)

Then in the Form's OnSuccess

Set(varSelectedItem,Form1.LastSubmit)

Was this reply helpful? Yes No
MJGreyling 161 on at

Like (0)

Report
In the OnSelect property of the Gallery the variable selectId was already set:
Navigate(Screen1, ScreenTransition.Fade); Set(selectedId, ThisItem)

So in the OnSucces property of the Form I have:
Set(selectedId,EditForm3.LastSubmit)

still doesn't refresh the form data.

Was this reply helpful? Yes No
Digital 1,207 on at

Like (0)

Report
In OnSuccess try looking up the submitted record in the datasource...

Set(selectedId,LookUp(YourSPL,ID = EditForm3.LastSubmit.ID))

Was this reply helpful? Yes No
MJGreyling 161 on at

Like (0)

Report
Lol. I am realy thinking this is impossible to do.
No, didn't work. The record updates in SP but not on the form.

Set(selectedId,LookUp(CSNonMovingParts,ID = EditForm3.LastSubmit.ID))

Was this reply helpful? Yes No
WarrenBelz 153,040 Most Valuable Professional on at

Like (0)

Report
Hi @MJGreyling ,

@Digital is on the right track, but the critical item which you have not included is the Item of the Form.

If you have the OnSuccess as

Set(selectedId,Self.LastSubmit.ID)

and the Item of the Form

LookUp( CSNonMovingParts, ID = selectedId )

it will display the record in its current state after the form submission.

Was this reply helpful? Yes No
MJGreyling 161 on at

Like (0)

Report
Set(selectedId, Self.LastSubmit.ID)
So for the above I get an incompatible type error from the formula

And the same for this:
LookUp(CSNonMovingParts,ID = selectedId)

Was this reply helpful? Yes No
WarrenBelz 153,040 Most Valuable Professional on at

Like (0)

Report
@MJGreyling ,

That is probably because you have selectedId defined elsewhere is a Record - forget about that one and use this

OnSuccess

Set(gblID,Self.LastSubmit.ID)

and the Item of the Form

LookUp( CSNonMovingParts, ID = gblID )

It has to work - I use it on many of my forms to show new records immediately after creation in edit or view mode on the same form.

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.

Was this reply helpful? Yes No
MJGreyling 161 on at

Like (0)

Report
Ok. I'm gonna give up on this now. It has become to frustrating.
Your suggestion has taken me back to square 1.
Now the form does not populate at all. 😄

The selectId is defined in gallery, under the OnSelect property
Navigate(Screen1, ScreenTransition.Fade); Set(selectId, ThisItem)
Im gonna take a brake from this. it is driving me nuts.

Was this reply helpful? Yes No