Getting error in Patch function and collections

[ychaitanya5g]

Hi Team,

I am getting error while inserting this code in OnSuccess function in powerapps  form

ForAll(Descriptioncollection,Patch('Des of Items',Defaults('Des of Items'),{'Description of I:DescriptionItem,Items of Desc:DesItems,MID:Form2.LastSubmit.ID}))

If colons are added in between items it is not showing any errors but 

ForAll(Descriptioncollection,Patch('Des of Items',Defaults('Des of Items'),{'Description of I':DescriptionItem,'Items of Desc':DesItems,MID:Form2.LastSubmit.ID}))

values are not updating in the list

[v-siky-msft]

Hi @ychaitanya5g,

OK. So 'Description of I' is a Text column, 'Items of Desc' and MID are Number columns, right?

Do these two codes work?

Patch('Des of Items',Defaults('Des of Items'),{'Description of I':"Test",'Items of Desc':1,MID:1})

Patch('Des of Items',First('Des of Items'),{'Description of I':"Test",'Items of Desc':1,MID:1})

Sik

[ychaitanya5g]

Yah, It is working while submitting button used in the custom button

[v-siky-msft]

Hi @ychaitanya5g ,

I am trying to reproduce your scenario, and the ForAll/Patch codes work well.

Could you please debug your code via trigger ForAll/Patch codes by a button to see if the issue is from EditForm?

Please set codes to a button OnSelect property, and hardcode the MID value.

If the codes work well triggered by button, please share more details about the Form, go to refresh the SharePoint connection and re-create the EditForm.

Hope this helps.

Sik

[ychaitanya5g]

How to retrieve the data into edit form 

[v-siky-msft]

Hi @ychaitanya5g 

Could you share more details with your need?

Sik

[ychaitanya5g]

I want to edit the the item which I submitted

[v-siky-msft]

Hi @ychaitanya5g ,

Modify the Items property of EditForm:

Last('Table Name') // get the last record

or use LookUp function to get specific record.

Reference: https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-filter-lookup 

Sik

[ychaitanya5g]

In the above link we can fetch the data but not from specified details.