Lookup multiple indexes in Forall

(0) Share

Report

Posted on by AnthonyD

559

Hi guys,

So i have a Power Automate flow that re runs in a forall loop. The Flow saves documents to a Onedrive folder. It runs the amount of times there is a file that has to be saved to a Onedrive folder.

On the screenshot below i have inline commentary of what is going wrong and what i want it to do.

More information of the current code and how it behaves:

Training 1
- 1 file
Training 2
- 2 files
Training 3
- 1 file

4 files have to be saved

Result of the run: 3 files got saved

2021_09_27_11_35_10_2021_09_27T09_16_00.8265830Z.csv_OneDrive.png

As you can see The 2nd attachment of Training 2 did not get saved because the lookup always picks the 1st Id it finds.

What is the way to make this work?

Best Regards,

Anthony

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

C-Papa 1,836 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi, look at the below screen shot, i think the comma should be replaced with ).

Was this reply helpful? Yes No
Verified answer

AnthonyD 559 on at

Like
a
(0)

Report
Copy link

Link copied!
Seems like i was looking for a very difficult formula while all i had to do was:

ForAll( Filter( Attachments, cref8_TrainingAttachments.cref8_name in galTrainings.AllItems.cref8_name ) As A, ExportCevoraFiles.Run( A.'Attachment Id', A.Attachment.FileName, varFileLink.foldername ) );

Best Regards,
Anthony

Was this reply helpful? Yes No