Solved: Can I add an Edit Form into a gallery?

Anonymous · ‎11-04-2016

Hi everybody.

Can I add an Edit Form into a gallery?

I have a Table [Id, Team, Active] and I want to change Active fields directly from Gallery. Is it possible???

Thank in advance.

Meneghino · ‎11-07-2016

Yes you can and easily, no need to use forms.

What kind of flield is Active? Is a true/false? In the rest of my reply I will assume it is.

Here is one idea:

1) Insert a toggle control in the gallery and set its Default property to ThisItem.Active

2) Set the toggle's OnChange property to Patch(YourDataSource, ThisItem, {Active: !ThisItem.Active}) or Patch(YourDataSource, ThisItem, {Active: ThisItem.Toggle1.Value}) or something like it

That is it!

Please let me know if this works and if not, what issues you encounter.

View solution in original post

v-yamao-msft · ‎11-06-2016

Hi Moises_martinez,

Gallery is a control that contains other controls and shows a set of data. We can use it browse for a record. If you want to edit and create a new record, an Edit Form would be needed. So it may not be possible to edit the fields directly from a gallery.

You could add two screens on your App, then add a Gallery control on Screen1, an Edit Form control on Screen2. Then you could show all the data on the Gallery and edit the data on the Edit Form.

I have seen an article about “Understand data forms in Microsoft PowerApps”, hope this could be a reference for you:
https://powerapps.microsoft.com/en-us/tutorials/working-with-forms/

Best regards,
Mabel Mao

Community Support Team _ Mabel Mao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Meneghino · ‎11-07-2016

Yes you can and easily, no need to use forms.

What kind of flield is Active? Is a true/false? In the rest of my reply I will assume it is.

Here is one idea:

1) Insert a toggle control in the gallery and set its Default property to ThisItem.Active

2) Set the toggle's OnChange property to Patch(YourDataSource, ThisItem, {Active: !ThisItem.Active}) or Patch(YourDataSource, ThisItem, {Active: ThisItem.Toggle1.Value}) or something like it

That is it!

Please let me know if this works and if not, what issues you encounter.

Anonymous · ‎11-07-2016

It's great!!! Thank for your idea!!!

leyburn19 · ‎01-07-2018

Is that solution delegable? I have found that once I exceed the 500 record limit UpdateIF fails and Patch only works when adding new records

Meneghino · ‎01-10-2018

hi @leyburn19

I believe it is delegable if your data source is delegable.

What is your data source?

Anonymous · ‎01-10-2018

This patch function on a slider seem to be working fine on a Sharepoint list, but I have not tested with a large list.

OnChange = Patch(Timeforing, First(Filter(Timeforing, ID=ThisItem.ID )), {Innsendt:true} )

- "Timeforing" is the Sharepoint list

- "Innsendt" is the boolean field that is set to true

(I have not been able to let the slider show the actual value of the field, but the "Send Inn" slider removes the item from the list intentionally by filtering, so it is not a problem.)

Filter for the browsegallery that only shows records for the logged on user where Innsendt=false:

Filter(Timeforing, Author.Email = 'Office365-brukere'.MyProfile().Mail && Innsendt=false)

Anonymous · ‎03-03-2018

I don't seem to be able to add control to my SoftView gallery. The control stays outside of the gallery. Do you have any idea? Thanks in advance.

leyburn19 · ‎03-03-2018

It is a sharepoint list which has many issues with delegation. That has been improved with et manually raise to 2000. A work around for this is to have a hidden form with matching control based on te Gallery.selecet. The fields defaults on the form set to match variables which have the results of the controls in the gallery. The only issue is the gallery row must also have a submit form step