Invalid Argument Type in nested ForAll

(0) Share

Report

Posted on by Etienne Leneveu

Hi,

Trying to create a nested ForAll with filters,

First ForAll filters a collection, containing some Items (with itemkey = No) depending on an item category (Standard Sales Code),

Second ForAll Filters the Item Table in order to retrieve Item characteristics for each item populated in the first ForAll. Was thinking to use the item Key 'No' to be abble to filter and disambiguating using the First Collection Name as prefix. But when doing this i always get a message "Invalid argument type". (have also tried using lookup but also getting same message).

Any idea what could be the trick to solve this?

Regards

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (0)

Etienne Leneveu 11 on at

Like (0)

Report

I finally achieved to get the exepected result,

I created an additionnal collection (named tempStandardSalesLines), where i'm doing filetring on the base collection.

This works fine, however think a bit annoying to duplicate collection just for filtering. Maybe someone has a better idea?

Was this reply helpful? Yes No
eka24 20,923 on at

Like (0)

Report

Try and wrap the error with Value:
Value (No)=LocalstandardSales
Or
No=Value(LocalstandardSales)

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Was this reply helpful? Yes No
Etienne Leneveu 11 on at

Like (0)

Report

Hi Eka 24,

Tried both options but none is succesful.

Was this reply helpful? Yes No
v-bofeng-msft on at

Like (1)

Report

Hi @EtienneFr :
Firstly, let me explain why the code not work.
The point is LocalStandardSalesLines[@No] is a one-column table It has nothing to do with your circulation body (Filter(Loca……)).
Secondly, Congratulations on solving this problem yourself. In addition, I have a new idea.
The difference between the two solutions is how to disambiguate:
My code:
ForAll(
RenameColumns(
    Filter(
        LocalStandardSalesLines;
        Standard_Sales_Code=ThisItem.Code
    );
    "No";
   "Noo"
);
ForAll(
Filter(
localItems;
No=Noo
);Collect(……
I think you should be able to understand what I mean.
I think this link will help you a lot:
AddColumns, DropColumns, RenameColumns, and ShowColumns functions in Power Apps
Best Regards,
Bof

Was this reply helpful? Yes No
Etienne Leneveu 11 on at

Like (0)

Report

Thanks for the tip, I'll definitively have a look into it.

Was this reply helpful? Yes No