Unanswered

Refresh a form not working

(0) Share

Report

Posted on by MKPA

I have a form which "datasource" is a sharepoint list and "Item" is a varRecord (variable programmed as AllGallery.Selected).

The form is an edit form, however all components are set to DisplayMode.View except for one which is set to "Edit": Attachments. Under attachments I have a "Save" button which has this code under "OnSelect":

Patch(
'Sharepoint_list_name';
LookUp('Sharepoint_list_name'; 'Column (ID)'=varRecord.ID);
Form1.Updates
);;
Notify("Saved";NotificationType.Success;2000)

This button works well and actually changes the attachments in existing record in my sharepoint list. But when I click it, the new added attachments still appear on the list as "Unsaved". They are in fact saved and if I come back to first screen and navigate to screen with my form/or just refresh the page, it will synchronize and display as saved.

I wanted to add a Refresh icon in the top left corner, which a user can click and see if the attachments actually got saved or not. But adding the icon and putting "Refresh('Sharepoint_list_name')" doesn't work. Putting refresh into my "Save" button after "Notify" also doesn't work.

Is there a way to do this?

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (0)

Sort by

MudassarSZ365 591 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @MKPA ,
Place this code on the on select Property of the Save Button
Patch( 'Sharepoint_list_name', LookUp('Sharepoint_list_name', 'Column (ID)' = varRecord.ID), Form1.Updates ); Notify("Saved", NotificationType.Success, 2000); Refresh('Sharepoint_list_name'); // Refresh the SharePoint list to get the latest data ResetForm(Form1); // Reset the form to clear any unsaved data EditForm(Form1); // Switch the form back to edit mode if needed
Place this the code on the onselect property of the refresh button
Refresh('Sharepoint_list_name'); ResetForm(Form1); EditForm(Form1); // Or ViewForm(Form1) if you want to switch back to view mode.
Place this code on the Items property of the form
Set(varRecord, LookUp('Sharepoint_list_name', 'Column (ID)' = varRecord.ID));
If this solution is helpful to you, then please accept it. 😊

Was this reply helpful? Yes No
MKPA 49 on at

Like
a
(0)

Report
Copy link

Link copied!

Error

Was this reply helpful? Yes No
MKPA 49 on at

Like
a
(0)

Report
Copy link

Link copied!

@MudassarSZ365 Unfortunately, this doesn't work. The save button now doesn't save my data and then just resets it to the way it was previously.

I'll give you an example:
I have 3 attachments. I delete one of them. I click "Save" and I can see the deleted attachment popping right back up.

I deleted the "reset form" part of the code on both save and refresh button and the result is the same as it worked before - save button saves the form, refresh button doesn't refresh it.

Was this reply helpful? Yes No
MudassarSZ365 591 on at

Like
a
(0)

Report
Copy link

Link copied!
@MKPA ,
for save button use this code
Patch( 'Sharepoint_list_name', LookUp('Sharepoint_list_name', 'Column (ID)' = varRecord.ID), Form1.Updates ); Notify("Saved", NotificationType.Success, 2000); Refresh('Sharepoint_list_name');
for refresh button use this
Refresh('Sharepoint_list_name');
on items property of the button use this code
If( IsEmpty(varRecord), Defaults('Sharepoint_list_name'), LookUp('Sharepoint_list_name', 'Column (ID)' = varRecord.ID) )

Was this reply helpful? Yes No
MKPA 49 on at

Like
a
(0)

Report
Copy link

Link copied!

@MudassarSZ365
Item property of a button? I don't have anything like this.

edit: I think you meant item property of a form.

Was this reply helpful? Yes No
MudassarSZ365 591 on at

Like
a
(1)

Report
Copy link

Link copied!

@MKPA ,
sorry items property of form

Was this reply helpful? Yes No