Unanswered

Prevent Patch command from refreshing Gallery's

(0) Share

Report

Posted on by Community Power Pla...

I have a PowerApp running that has some complicated dropdowns that are working great thanks to help from @RandyHayes

The issue I'm running into now is that when we update an item in the 2nd gallery( taskgallery), it updates the item, then refreshes the app.

Example:

Selected Function = "Employee Experience" - Selected Process = "Change Enablement" … Add to Comments field:

After clicking the Save Icon, the App returns to the default gallery view:

At times the users need to update multiple Tasks that are listed.
The first dropdown(Dropdown_Function) formula is:
Sort(GroupBy( GroupBy( GroupBy( AddColumns(ndworkplan, "txtFunction", Function.Value), "txtFunction", "Subprocess","Milestone_x0020_ID", "Process", "Milestone_x0020_Name", "Task_x0020_ID"),"txtFunction","Process", "Milestones"), "txtFunction", "Processes" ),txtFunction,Ascending)

The 2nd dropdown( Dropdown_Process) formula is: Sort(Dropdown_Function.Selected.Processes,Process,Ascending)

The First Gallery (MilestoneGallery) has items = Dropdown_Process.Selected.Milestones

The 2nd gallery (TaskGallery) has Items = MilestoneGallery.Selected.Task_x0020_ID

and OnSelect = Set(CurrentSelectedITem, ThisItem)

The "Save" Icon has OnSelect = Patch(ndworkplan,CurrentSelectedITem, {Comments: CommentGal.Text}))
and it updates the comments field as expected, but also refreshes the entire view...

So the user is forced to go back through the steps to find the milestone and tasks they want to update.

Is there a way to prevent the App from refreshing after saving one task item?

Categories:

Building Power Apps

I have the same question (0)

All responses (11)

Answers (2)

v-yutliu-msft on at

Like (0)

Report
Hi @Anonymous ,

Do you mean that if you update a new record, gallery1 and gallery2's item sorting will change?

I suggest you sort them according to the submitted time.

Then, if you submit a new item, the latest record will be the first too.

Set the gallery1's Items:

SortByColumns(
AddColumns(Dropdown_Process.Selected.Milestones,
"lastmodified",
First(SortByColumns(Milestone_x0020_ID,"Modified",Descending)).Modified),
"lastmodified",Descending
)

Set the gallery2's Items:

SortByColumns(MilestoneGallery.Selected.Task_x0020_ID,"Modified",Descending)

Best regards,

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Maybe this will help clear up the issue..
Users go to the app and select a Function and process from the drop downs.
Then user select a Milestone from the 1st Gallery (MilestoneGallery), which displays all tasks associated to that Milestone in the 2nd gallery(TaskGallery).
They can then update those tasks directly in that gallery.
But, as soon as they click the Save Button, the entire application "Resets" back to the defualt view.
The Changes are saved, but now the end user needs to go back through all those steps to update other tasks for that Milestone.
Some of these Milestones have 10+ task associated with them, so I'd like to make it so they can save one task, then scroll down, update a 2nd task, save, etc. until they are done updating all the tasks for that Milestone.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Hey,

just a wee question, do your dropdowns have Reset feild false?

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Yes, both Dropdowns have Reset = False

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Just thought I'd check in to see if any one has any thoughts?

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Hi @RandyHayes are you able to provide any insight on this?

Thanks,

@Anonymous

Was this reply helpful? Yes No
Verified answer

RandyHayes 76,297 Super User 2024 Season 1 on at

Like (1)

Report
@Anonymous

Are you still having trouble with this?

Your problem is that you are updating the collection ndworkplan in your Save formula. Since your first dropdown is based on that collection, it will tend to reevaluate the list and then all the associate items will change because, you have not mentioned any of your default properties, and I am guessing those are not set.

So...you can do one for at least two things.

1) change your first dropdown to be based on a collection instead. A collection is a snapshot in time, so it will not change unless you change it.

Consider putting a formula such as this in your OnVisible action of your screen (BTW - not even addressing that I believe your GroupBy logic might be a bit backward, but let's go with it at this point):

ClearCollect(colFunctions, Sort(
GroupBy(
GroupBy(
GroupBy(
AddColumns(ndworkplan, "txtFunction", Function.Value),
"txtFunction",
"Subprocess",
"Milestone_x0020_ID",
"Process",
"Milestone_x0020_Name",
"Task_x0020_ID"),
"txtFunction",
"Process",
"Milestones"),
"txtFunction",
"Processes" ),
txtFunction,
Ascending
) )

Then set the Items property of your first dropdown to colFunctions

2) Set defaults - set a variable on each of the OnChange/OnSelect actions of the dropdowns and the galleries that capture the current value and then assign that variable in the default property of the control.

Ex. if Function is a dropdown control (not a combobox), then in the OnChange action : UpdateContext({lclCurrentFunction : yourDropDown.Selected.Value}) Then in the Default property of the Function DropDown, put in this formula : lclCurrentFunction

Repeat this on the other controls with their own variables and then they will at least retain their selected item if the underlying collection is patched.

I hope this is helpful for you.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Thanks, I'll take a look today to see if this works.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

@RandyHayes I've tried your first idea but now when I try to save I get "Unknown error" and no explanation when running or testing what the "Unknown error" is.
The Formula for the Save button is:
Patch(ndworkplan,CurrentSelectedITem, {Comments: CommentGal.Text}, {'Task Name': TaskNameGal.Text}, {'Start Date': StartDateGal.SelectedDate}, {'Due Date': DueDateGal.SelectedDate}, {'Percent Complete': PercentGal}, {Owner: OwnerGal.Text})

Where "Gal" is the field name for the current Gallery.
I'll see if I can walk through your 2nd idea tomorrow.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

@RandyHayes Never mind on my last post.. "Percent Complete" was casuing an issue due to invild type( even though the formula never errored out until I tested it)..

Going to go back and re-add your first idea.

Was this reply helpful? Yes No