Announcements
Hi
I need to patch source using Collection data.
I have excel source S1 having columns A,B,C and I have Collection C1 having A,C where col A is common to both.
I need to patch column C from collection C1 to Source S1 column C based on common column A.
Please suggest!!
Thanks
Amit
http://fascinatingsql.blogspot.com/
https://youtu.be/Hoa7rkyUlzs
@amsrivas You could loop over collection C1 and Patch S1 for each matching value in column 'A' like this.
ForAll( C1, Patch( S1, LookUp(S1, A=C1[@A], {C: C1[@C]} ) )
---Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."
Hi @mdevaney ,
I have already tried the same however its not failing but not updating data as well.
@amsrivas How many rows in your Excel sheet?
Hi @mdevaney
There are about 20 Worksheet on my excel.
The sheet to which power App connected is having 70 rows however i have created table on excel to which Power App is refereeing having just 30 rows.
Note - 1. Apart from 30 rows (table created in excel) rest rows have excel formula as well.
2. I am able to patch Gallery Data to excel source.
@amsrivas
Does column A in your Excel sheet have a formula? If yes, we cannot compare to something with a formula. It must be a Value.
Your spreadsheet size is fine. No size issues there.
Can you show a screenshot of the spreadsheet and of the collection? I want to recreate on my side.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
11manish 342 Super User 2026 Season 2
M Bilal Khan 283
Mohsin Ali 221
