Answered

Loop through 2 collections using ForAll to Patch a record

(0) Share

Report

Posted on by NicolleAbrahams

Hi I would like to know if it is possibel to loop through two collections at once then Patch the result. For example I have tried the follwoing but have had no luck.

ForAll(Attachments.Attachments As Document && col_IDs As varPatchedItem,

Patch( 'Data Source', Defaults('Data Source'), {Title: Document.Name, ItemID: varPatchedItem}))

Any help would be greatly appreciated!

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

PowerAddict 7,316 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

What are you trying to achieve here? Do you want to loop through every single record in col_ID for each attachment?

---
If you like this reply, please give kudos (Thumbs Up). And if this solves your problem, please mark this reply as a solution by selecting Accept as Solution. This makes it easier for others to find answers to similar questions.

Thanks!

Hardit Bhatia

Microsoft Business Applications MVP

Microsoft Certified Trainer MCT

Blog | Twitter | LinkedIn | Facebook | YouTube | Email

Was this reply helpful? Yes No
NicolleAbrahams 75 on at

Like (0)

Report
Copy link

Link copied!

No I'd like to loop throught them simultaneously i.e: For loop 1 print the first value in each collection, for the 2nd loop use the 2nd value in each collection, for the 3rd loop use the 3rd value in each collection and so on.

Was this reply helpful? Yes No
Verified answer

WarrenBelz 155,463 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!
Hi @NicolleAbrahams ,

Note that the last .Value may be different depending on the name of the field containing the ItemID in colIDs. Also I am assuming there are enough ItemIDs for the number of attachments.

Patch( 'Data Source', ForAll( Sequence( CountRows(Attachments.Attachments) ), { Title: Index( Attachments.Attachments, Value ).Name, ItemID: Index( colIDs, Value ).Value } ) )

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.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No
NicolleAbrahams 75 on at

Like (0)

Report
Copy link

Link copied!

This worked thank you so much!

Was this reply helpful? Yes No