web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps The Function "Add Colu...

Power Apps

Answered

The Function "Add Column" has some invalid arguments

(0) Share

Report

Report

Posted on by Erandi

265

Hi guys,

For below code, I am getting this error. colSPOPDBalanceHistory and colSPEmployee are created collections.

ClearCollect(

colUsageHistorySummery,

AddColumns(

colSPOPDBalanceHistory,

"EmployeeName",LookUp(colSPEmployee,EmployeeID = colSPOPDBalanceHistory[@EmployeeID],EmployeeName),

"Grade",LookUp(colSPEmployee,EmployeeID = colSPOPDBalanceHistory[@EmployeeID],Grade),

"OPDCategory",LookUp(colSPEmployee,EmployeeID = colSPOPDBalanceHistory[@EmployeeID],OPDCategory.Value)));

I didn't get what is the issue inside of this code.

Thanks

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

Verified answer

v-jefferni Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @Erandi ,

Could you please share a screenshot of the formula bar? Which part of the formula was throwing this error? Please try below formula instead first:

ClearCollect( colUsageHistorySummery, AddColumns( colSPOPDBalanceHistory As BH, "EmployeeName", LookUp(colSPEmployee,EmployeeID = BH.EmployeeID, EmployeeName), "Grade", LookUp(colSPEmployee,EmployeeID = BH.EmployeeID,Grade), "OPDCategory", LookUp(colSPEmployee,EmployeeID = BH.EmployeeID, OPDCategory.Value) ) );

Best regards,

Was this reply helpful? Yes No
Erandi 265 on at

Like
a
(0)

Report
Copy link

Link copied!

@v-jefferni Thank you very much,it is worked

Was this reply helpful? Yes No

Join the conversation