How to get filtered gallery items to Edit form for editing one by one

(0) Share

Report

Posted on by AshwiniBhandari

Hello,

I have a gallery control and Edit form control. Currently the controls have these functions:

Gallery Control:

Items: 'Work progress tracker'

OnSelect: Set(var,ThisItem)

Edit Form Control:

Data source: 'Work progress tracker'

Item: var

OnSuccess:

Set(var,First(SortByColumns(Filter('Work progress tracker',ID > var.ID),"ID",Ascending)))

I am able to edit the items for the above functions.

However, if suppose I add dropdowns Priority and Progress to filter Gallery items. How can I get only these items to edit?

Thank you.

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Ethan_009 4,838 Moderator on at

Like (0)

Report

Hi @AshwiniBhandari ,
I'm confused between 2 things whether you want to filter gallery based on dropdown values or you want to edit those dropdown fields and rest as ReadOnly.

Well for 1st (You want use the dropdown to filter the gallery)

SortByColumns(
Filter(
'Work progress tracker',
ID > var.ID,
IsBlank(Priority.SelectedItems.Value) || IsEmpty(Priority.SelectedItems) || priority(field name) in Priority.SelectedItems,
IsBlank(Progress.SelectedItems.Value) || IsEmpty(Progress.SelectedItems) || progress(field name) in Progress.SelectedItems
),
"createdon",
Ascending
)

For the 2nd one,
Change the DisplayMode property for that fields

Hope this helps.

Was this reply helpful? Yes No
AshwiniBhandari 97 on at

Like (0)

Report

Hi @Ethan_R , Thank your for your response.

My problem is not filtering the gallery items. As you can see from the second screenshot I am already filtering gallery items with below function:

Filter('Work progress tracker',(Priority.Value = Dropdown2_2.Selected.Value || Dropdown2_2.Selected.Value = Blank()) && (Dropdown2_1.Selected.Value = Blank() || Progress.Value = Dropdown2_2.Selected.Value))

My exact issue is after filtering I want to edit only those 5 items from edit form one by one. Is this achievable?

Was this reply helpful? Yes No
Ethan_009 4,838 Moderator on at

Like (0)

Report

Hi @AshwiniBhandari ,
You can add Item property of the edit form to Gallery1.Selected.
This will help you select filtered record data into the form so you can edit.
All you need is to click the gallery record tile.
Hope this helps.

Was this reply helpful? Yes No
AshwiniBhandari 97 on at

Like (0)

Report

Hi @Ethan_R

Still does not answer my question. I have a blog for my first case here.
And I want to extend it further for filtered items in Gallery control. I hope this will help.

Was this reply helpful? Yes No
Verified answer

AshwiniBhandari 97 on at

Like (0)

Report
I have found a solution for the second case (second screenshot) and this is how I fixed it:

Gallery Control:
Items property:

Filter( 'Work progress tracker', (Priority.Value = Dropdown2_3.Selected.Value || Dropdown2_3.Selected.Value = Blank()) && (Dropdown2_4.Selected.Value = Blank() || Progress.Value = Dropdown2_4.Selected.Value) )

OnSelect property:

Set(var,ThisItem); Collect(ItemsInGallery,Gallery4_1.AllItems)

Refresh button:
OnSelect property

Reset(Dropdown2_4); Reset(Dropdown2_3); Clear(ItemsInGallery);

Edit form:
DataSource property:

ItemsInGallery

Item property:

var

OnSuccess property:

Set( var, First( SortByColumns( Filter( ItemsInGallery, ID > var.ID ), "ID", Ascending ) ) )

And some tweaks on the OnSubmit property of the submit form got me going.

Was this reply helpful? Yes No