ForAll (Collect()) Syntax Problem

(0) Share

Report

Posted on by ocdc2008

Hello,

I'm struggling with the following code:

ForAll(invoices,Collect(invWorkOrders,Filter('[dbo].[WorkOrder]',InvoiceID=ID)));

The steps:

1) Collect the invoices related to the current billing cycle

2) For each invoice, collect all of the WorkOrders based on the WorkOrder.InvoiceID = invoices.ID.

I cannot figure out how to get the syntax to work in order to reference the invoices.ID of the current loop iteration in the ForAll. I've seen something like [@ID] before, but I can't find any record of that on the forum.

How do I reference the current record values in invoices in the above example?

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (1)

Sort by

Christopher S Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @ocdc2008 ,

Can you please share with me the exact error message that you are receiving?

Best Regards

Was this reply helpful? Yes No
ocdc2008 64 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello,

I am not receiving an error message. The syntax seems to be valid, but I'm thinking the formula is confused as to what which :ID I am attempting to reference.

My guess is it thinks I am trying to say pull records when ['dbo'].['WorkOrder'].InvoiceID = ['dbo'].['WorkOrder'].ID as opposed to what I want: ['dbo'].['WorkOrder'].InvoiceID = ThisInvoiceFromTheLoop.ID

Was this reply helpful? Yes No
Verified answer

WarrenBelz 156,425 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @ocdc2008 ,
A bit of a guess here, but try the below - I am suspecting '[dbo].[WorkOrder]' also has an ID and there is some Ambiguity. There is nothing wrong with your code syntax.
ForAll( RenameColumns( invoices, "ID", "ID1" ), Collect( invWorkOrders, Filter( '[dbo].[WorkOrder]', InvoiceID=ID1 ) ) )

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.

Was this reply helpful? Yes No
ocdc2008 64 on at

Like
a
(0)

Report
Copy link

Link copied!

@WarrenBelz

This worked! It seems like a bit of a work around when there should be built in syntax for specificity, but this will do!

Thank you.

Was this reply helpful? Yes No
WarrenBelz 156,425 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @ocdc2008 ,
Yes there is disambiguation syntax available, but when coming from a collection, renaming is always reliable.

Was this reply helpful? Yes No
ocdc2008 64 on at

Like
a
(0)

Report
Copy link

Link copied!

@WarrenBelz Thanks for providing both options. Very helpful.

Was this reply helpful? Yes No