cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Regular Visitor

PATCH doesn't recognize data in a SP LIST

Please Help!

 

I have searched for the last 3 weeks for the answer and I have not been successful

I already checked the syntax and it is correct

 

Patch(FAMILY_TREE ;ID = CAMBIO_SUPER.ID;{SUPER_365: CAMBIO_SUPER.SUPER_365})

 

The problem is that when I use the PATCH function, my SP list appears empty, without any data, even though I have gotten all the information from there to create the collection of data that I want to modify.

 

The list of SP "FAMILY_TREE" appears without information.

 

This only happens when I want to use the PATCH function 🤔

 

Please help me, I'm already late with a delivery because of this problem 😥

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted

@DValle ,

@RandyHayes tagged me on this due to Timezone.

Try this

ForAll(
   CAMBIO_SUPER As Cambio;
   Patch(
      FAMILY_TREE; 
      {ID:Cambio.ID};
      {SUPER_365: Cambio.SUPER_365}
   )
)

 

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

View solution in original post

6 REPLIES 6
Highlighted
Super User III
Super User III

@DValle 

Please consider changing your patch Formula to the following:

Patch(FAMILY_TREE ; LookUp(FAMILY_TREE, ID = CAMBIO_SUPER.ID);{SUPER_365: CAMBIO_SUPER.SUPER_365})

You need to specify the record as the second parameter in the Patch.

 

I hope this is helpful for you. 

_____________________________________________________________________________________
Digging it? - Click on the Thumbs Up. Solved your problem? - Click on Accept as Solution. Others seeking the same answers will be happy you did.
Check out my PowerApps Videos too!
Highlighted

The formula seams to be ok with the syntax, thank you for that but...

 

...the error continues to appear, it does not recognize me that the FAMILY_TREE list has info, and if it does, I have already checked it in SP even in powerapps and if it has info, it is only here, that the info "disappears"

 

with info

DValle_1-1602637218541.png

 

without info

DValle_0-1602636950223.png

 

Highlighted

@DValle 

Your Search function indicates that you are trying to search two columns - "ROD" and "MM_365" for the full name of the current user.  However, you are only receiving a delegation warning there.

 

Your Patch indicates that you have an ID column in the CAMBIO_SUPER record...what is that?  Where is that coming from?  It does not appear to be valid.

_____________________________________________________________________________________
Digging it? - Click on the Thumbs Up. Solved your problem? - Click on Accept as Solution. Others seeking the same answers will be happy you did.
Check out my PowerApps Videos too!
Highlighted

Ok,

 

1. From  Family_tree I take the records that I need with the search, 

2. Then I put this selected records in a collection named Cambio_super,

3. After that, in a Gallery, I use this collection to change a column named Super_365, I check and in the collection the change it's ok, I have only the recods that I need and the changes that I need to make

4. And then I return the data from the collection to Family_tree ==> this is where is the problem 😞

 

All data came from family_tree

 

 

Highlighted

@DValle ,

@RandyHayes tagged me on this due to Timezone.

Try this

ForAll(
   CAMBIO_SUPER As Cambio;
   Patch(
      FAMILY_TREE; 
      {ID:Cambio.ID};
      {SUPER_365: Cambio.SUPER_365}
   )
)

 

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

View solution in original post

Highlighted

Thank you sir, it works at the very first time!

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

News & Announcements

Community Blog

Stay up tp date on the latest blogs and activities in the community News & Announcements.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Community Highlights

Community Highlights

Check out the Power Platform Community Highlights

Top Solution Authors
Top Kudoed Authors
Users online (9,506)