Unanswered

Select last record in gallery and perform action

(0) Share

Report

Posted on by lumberjacklurch

443

I have a customized form that has a gallery, and in each row/record has a button that saves the item/row to a collection. The collection is patched after the above form is submitted. There is a chance that a user will not click on the button in the gallery before submitting the form. If that happens, the information that should go along with the form is not captured. I want to mitigate this possibility by selecting the last record's button before the form is submitted. I tried the below...

Select(Last(ItemDetailGalleryNew.Selected.Button_NewSave))

It didn't work though. Got the following errors:

The function 'Last' has some invalid arguments.

The function 'Select' has some invalid arguments.

UpdateContext cannot be used on rules belonging to global controls

Really don't understand that last one...

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (0)

lumberjacklurch 443 on at

Like (0)

Report

Got one more error:

Invalid argument type (Control). Expecting a Table value instead

Was this reply helpful? Yes No
lumberjacklurch 443 on at

Like (0)

Report

I need to clarify, the button is not actually a button. It is an icon. The disk icon, to be specific.

Was this reply helpful? Yes No
v-yutliu-msft on at

Like (0)

Report

Hi @lumberjacklurch ,
Do you have a gallery and an edit form and set the form's item to gallery.selected?
Could you describe more clearly about your app or show me screen shoots about it?
I'm a little confuse about your description.

Best regards,
Community Support Team _ Phoebe Liu

Was this reply helpful? Yes No
lumberjacklurch 443 on at

Like (0)

Report

@v-yutliu-msft,
Here's a screenshot of the customized form.

Was this reply helpful? Yes No
yashag2255 24,769 Super User 2024 Season 1 on at

Like (0)

Report

Hi @lumberjacklurch

Can you please share the formula that you have used on the save icon?

Also, do you want to update the collection even if the form is not submitted?

Was this reply helpful? Yes No
lumberjacklurch 443 on at

Like (0)

Report

@yashag2255,
Here's the code for the Save icon:

Update(col_ItemDetailNew, ThisItem, {ItemName: NewItemVal.Text, ItemDescription: NewDescripVal.Text, ItemQuantity: Value(NewQuantityVal.Text)});
Collect(col_ItemDetailNew, {ItemName: "", ItemDescription: "", ItemQuantity: 0})

Here's the relevant code from the OnSave property:

Set(var_ColRowCount, CountRows(col_ItemDetailNew));
Set(var_GalRowCount, CountRows(ItemDetailGalleryNew.AllItems));

If(var_ColRowCount=1 || !IsBlank(Last(ItemDetailGalleryNew.AllItems).ItemName), Notify("Cannot submit request. Items not saved. Click disk icon to save items, then click Save.", NotificationType.Error),

SubmitForm(SalesRequestFormNew);

Set(var_NewLastSubmitID, SalesRequestFormNew.LastSubmit.ID);
Set(var_NewLastSubmitTitle, SalesRequestFormNew.LastSubmit.DepartmentName & "-" & var_NewLastSubmitID);

RemoveIf(col_ItemDetailNew, IsBlank(ItemName) && IsBlank(ItemDescription) && ItemQuantity=0);

ForAll(col_ItemDetailNew,
Patch('Sales Item List', Defaults('Sales Item List'), {'Item Name': ItemName, 'Item Description': ItemDescription, 'Item Quantity': ItemQuantity, 'Request ID': var_NewLastSubmitID, Title: var_NewLastSubmitTitle}))

Was this reply helpful? Yes No
lumberjacklurch 443 on at

Like (0)

Report

@yashag2255,
I think I should give a bit more detail on this.
I have a list where people will be submitting sales requests via a customized form. The customized form has two parts: an edit form and a gallery. The edit form is where departmental and contact information is put in, and the gallery is where the list of items for sale are put in. When the form is submitted, a new sales request item is created in the request list and the list/collection of items is patched to an item list that is linked to the request via the request's ID. Now, when a user is inputing the list of items for sale (in the gallery), they have to click the Save icon so that their entry/item is saved to a collection (ItemDetailNew). The collection is when is patched. I am trying to make the form account for any possibilities. One of those possibilities is a user may fill out the form, enter their first item, click the save icon, enter a second item, but not click the save icon again. So if they click Save, only their first item is patched to the items list for their request. I need to know if there is a way to see if the second (or third, or fourth) line in the gallery is populate, but is not in the collection. Then to not allow the app to go any further until the save icon is clicked.
I hope this clears up my objective. Let me know if I'm unclear on any parts, or if you need more info.

Was this reply helpful? Yes No