cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Community Support
Community Support

Re: Getting error in Patch function and collections

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

 

Highlighted
Helper I
Helper I

Re: Getting error in Patch function and collections

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

Highlighted
Community Support
Community Support

Re: Getting error in Patch function and collections

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

 

Highlighted
Helper I
Helper I

Re: Getting error in Patch function and collections

How to retrieve the data into edit form 

Highlighted
Community Support
Community Support

Re: Getting error in Patch function and collections

Hi @ychaitanya5g 

 

Could you share more details with your need?

Sik

Highlighted
Helper I
Helper I

Re: Getting error in Patch function and collections

I want to edit the the item which I submitted

 

Highlighted
Community Support
Community Support

Re: Getting error in Patch function and collections

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

Highlighted
Helper I
Helper I

Re: Getting error in Patch function and collections

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

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Find your favorite faces from the community presenting at the Power Platform Community Conference!

Watch Now

Experience what’s next for Power Apps

See the latest Power Apps innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (4,985)