Power Platform Community Forum Thread Details

Hi all..

I have issue with this formula:

ForAll(
Iter2,
Collect(InvCountingJnlLineColl,
ShowColumns(
Filter(
InventoryCountingJournalLines,
StartsWith('Item number', Value) && JournalNumber=DD_Selectjournal.SelectedText.Journal
)
,
"JournalNumber", "InventorySiteId", "WarehouseId", "WarehouseLocationId", "ItemNumber", "ItemBatchNumber", "CountedQuantity", "LineNumber"
)
)
);

I'm trying to filter the Colletion with 2 condition which is:
StartsWith('Item number', Value) && JournalNumber=DD_Selectjournal.SelectedText.Journal

But it doesn't seems working, because it not showing the data, also there's no error message appear about it.
What i do wrong?

Please help.

Thanks,

pytbyt

Categories:

Building Power Apps

Hi @PytByt ,

Can you confirm that is there any data meet these 2 conditions?

I have made test on your formula, it work well. So I think there may be something wrong with your parameter of functions in your formulas.

Annotation 2019-10-16 142337.png

If there are some datas meet these conditions, could you do more explaination on your formulas?

1. Which table do the 'Item number' and "JournalNumber“ belong to? InventoryCountingJournalLines or Iter2?

2. What is DD_Selectjournal ? Dropdown ? Does the selection of the dropdown satisfy this condition?

3. Are columns in Iter2 referenced in your formula?

You can test part of the formula separately to see what the problem is, also you can hardcode the JournalNumber to check if your issue is due to dropdown.

Looking forward to your detailed reply.

Best regards,

Sik