Error with Add column function

(0) Share

Report

Posted on by PratikBhat

I’m facing issue with Add columns function as i’m trying to create one dummy column which holds my ID which value and i want to concate that with ‘Sim-‘ as prefix , it is throwing error as expected identifier name

IMG_2796.jpeg

Your file is currently under scan for potential threats. Please wait while we review it for any viruses or malicious content.

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

Power Platform 1919 2,168 on at

Like (0)

Report
Copy link

Link copied!
Hi @PratikBhat,
please try this formula format,

code:
AddColumns( ForAll(Sequence(10,1,1),{ID: Value}), // replace with your actual datasource 'New ID', "Sim-" & ID )

Sample output Pic:

Was this reply helpful? Yes No
Suggested answer

mattavdven 125 on at

Like (0)

Report
Copy link

Link copied!
Hi @PratikBhat,

This error indicates an error in the naming of the column. The AddColumns function expects the following parameters:

Source: The table or source where the column should be added to.

Column: The unique column name

Expression: This provides the values in the column

Make sure the column parameter is not inside double quotes but just as a identifier. This will solve the identifier error.

Good luck!

Was this reply helpful? Yes No