Answered

ID field Value to copy to another field in the same list

(0) Share

Report

Posted on by OsmandFernando

Dear Experts,

Finally, I found a solution to have more than 2000 records in my collections. Thank you @WarrenBelz for the Solution

Now I have a new concern where I need support. I have several lists that are updating with Patch functions. So I can not apply the Onsuccess formula in the above solution. How can I get the ID field value to my Shadow ID field with Patch maybe after creating the record via patch?

Thank you Osmand

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (3)

Sort by

Verified answer

eka24 20,925 on at

Like (1)

Report
Copy link

Link copied!

Try
Patch( ChequesReceived,
First( Filter( ChequesReceived, ID= 72 ) ), { ShadowID: 72 } )

If you are using textboxes;
Patch( ChequesReceived,
First( Filter( ChequesReceived, ID= Textbox1.Text) ), { ShadowID: Textbox1.Text} )

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Was this reply helpful? Yes No
v-xida-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!
Hi @OsmandFernando ,

Do you want to copy the Value from the ID column into the MyShadowID column?

Based on the needs that you mentioned, I think the OnSuccess property of the Edit form and the Patch function could achieve your needs.

Please add the following formula within the OnSuccess property of the Edit form (EditForm1) to following:

Patch( // add this Patch formula to modify the MyShadowID column value 'Cheques Received', EditForm1.LastSubmit, { MyShadowID: EditForm1.LastSubmit.ID } ); Back()

Please take a try with above solution, then check if the issue is solved.

Best regards,

Was this reply helpful? Yes No
OsmandFernando on at

Like (0)

Report
Copy link

Link copied!

@v-xida-msft @eka24 Thank you for your replies I really appreciate it.

In my case I do not have a form, I am using the patch to update a list from a different form. I think I am almost there using your idea Now I want t get the last ID to a label to apply the solution of @eka24 . When I try to get the Last ID to a label it tells me "Expected Text Value" following is the screen shot

Thanks,
Osmand

Was this reply helpful? Yes No
Verified answer

v-xida-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!
Hi @OsmandFernando ,

I think there is something wrong with your formula, you should modify your formula as below (set the Text property of a Label to following):

Last(SalesDetails_1).ID

Please try it, check if it could help in your scenario.

Best regards,

Was this reply helpful? Yes No
Verified answer

eka24 20,925 on at

Like (1)

Report
Copy link

Link copied!

Try
Last(SalesDetails_).ID
------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Was this reply helpful? Yes No
OsmandFernando on at

Like (0)

Report
Copy link

Link copied!

@eka24 @v-xida-msft Thank you to both. Your combination helped me to solve the issue. Now I can have the shadow ID even not having the form. Then to have the collection without limiting to 2000 rows. This is a great milestone for me.

Osmand

Was this reply helpful? Yes No
v-xida-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @OsmandFernando ,

If the solution I provided above also help in your scenario, please consider go ahead to click "Accept as Solution" to identify my reply as helpful.

Best regards,

Was this reply helpful? Yes No