Power Platform Community Forum Thread Details

Hi, I have Gallery1 to show versions of my record items and Myyntihinnasto Gallery to show needed data for each Gallery1 item. When I create a new version to Gallery1 it should first collect all rows from Myyntihinnasto Gallery and create new version to Gallery1 and insert all rows on Myyntihinnasto to new Gallery1 item. Now it creates a new version to Gallery1 and first row of Myyntihinnasto with 4 times. How should I filter that my collection will pick up only needed rows?

ClearCollect(Myyntitaulu;Filter('[dbo].[Myyntihinnasto]'; VersionID = Gallery1.Selected.VersionID));;ForAll(Myyntitaulu;Patch('[dbo].[Myyntihinnasto]'; Defaults('[dbo].[Myyntihinnasto]'); { Kpl: Value(DataCardValue89.Text);PintaAla:Value(DataCardValue90.Text); MHEURm2:Value(DataCardValue87.Text); Tyyppi: DataCardValue91.Text;VersionID:Value(TextInput29.Text);TonttiID:Gallery2.Selected.Tunnus } ))