The Function "Add Column" has some invalid arguments

(0) Share

Report

Posted on by Ashok2

428

Hi All,

Trying below to add column in collection but getting error The Function "Add Column" has some invalid arguments

ClearCollect(POAGrantorSocietyChange,
 AddColumns(POAGrantorSocietyChange,"Grantor",LookUp(
 POAGrantorSocietyCollection,GrantorSociety=Dropdown4_1.Selected.Result))
);

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

eka24 20,925 on at

Like
a
(0)

Report
Copy link

Link copied!

Your LookUp does not have a return column. Check the end of the LookUp formula.

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

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
RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

@Ashok2

The formula looks good as long as you are expecting that Grantor will be a record.

So, the question would be, in the formula editor, there is most likely something that is underlined in red a little darker, look at that and see what the error is on that part.

When a formula has an inner issue (like in your LookUp) it will report that the outer function (in this case AddColumns) has invalid arguments.

I would focus on the LookUp function and see if you are comparing text to text (i.e. the GrantorSociety and the dropdown result).

I hope this is helpful for you.

Was this reply helpful? Yes No
Verified answer

v-albai-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Ashok2 ,
Do you want to add a column called “Grantor” into the collection POAGrantorSocietyChange?
If yes, we cannot use formula like this "ClearCollect(POAGrantorSocietyChange,
AddColumns(POAGrantorSocietyChange, XXX)". It is not allowed to ClearCollect a collection based on itself.
Instead, you can add a new record into this collection which has a value only for this new column “Grantor”. Then remove the new added record, this time, your collection will have this new column.

For example:
If you want this new column contains a record, you can try this:
Collect(POAGrantorSocietyChange,{Grantor:LookUp(POAGrantorSocietyCollection,GrantorSociety=Dropdown4_1.Selected.Result) }); Remove(POAGrantorSocietyChange,Last(POAGrantorSocietyChange)); UpdateIf(POAGrantorSocietyChange,true,{Grantor: LookUp(POAGrantorSocietyCollection,GrantorSociety=Dropdown4_1.Selected.Result)})

If you want this new column only contains text, you can try this(Using lookup function to return a column value, then update this value to Grantor column):
Collect(POAGrantorSocietyChange,{Grantor:”1”}); Remove(POAGrantorSocietyChange,Last(POAGrantorSocietyChange)); UpdateIf(POAGrantorSocietyChange,true,{Grantor: LookUp(POAGrantorSocietyCollection,GrantorSociety=Dropdown4_1.Selected.Result).Title})
Best regards,
Allen

Was this reply helpful? Yes No