Issue with Repeating tables

[biuser99]

Hello,

I have a Gallery in which there are few drop down fields to select values and I have used Patch with Collect function to save and create rows. However, after selecting values in first row drop downs and hitting save button a new row with drop down is created, but the selected values in first row have disappeared and are reset to initial values. Can someone explain how to overcome this issue?

Thank You

[v-monli-msft]

Hi @biuser99 ,

What is the your data source? 

Would you please share the formulas of the Items and Default property of the dropdown control? Also the Items property of gallery?

Did you have a refresh of the data source when patching the data source?

Regards,

Mona

[biuser99]

Hi Mona,

Thanks for the reply. I'm able to resolve dropdown value reset issue, but the selected dropdown values in gallery are not getting saved in the Sharepoint list. The main list which has the form data is being updated but the gallery values are not being saved to detail list.

Form1 (OnSuccess) code : 

ForAll(ImpactedAudienceCollection, Patch(ImpactedAudienceGroups,Defaults(ImpactedAudienceGroups),{ImpactedAudience:ImpactedAudiencegroup,Region:Regionitem,Market:Marketitem,Description:Description,BCODate:DateValue(BCO,"mm/dd/yyyy"),ID:Form1.LastSubmit.ID}))

Please advise.

Thank You

[v-monli-msft · Accepted solution]

Hi @biuser99 ,

Is this dropdown value for a choice column in SharePoint? In this Patch formula, which part is for this choice column?

If the parameter for choice column only contains the choice value, then it won't be saved to SharePoint. To Patch a choice column, the formula should be something like:

{choice:
 {'@odata.type':"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
  Value:Dropdown1.Selected.Value}
 }

Regards,

Mona