Answered

Expected identifier Name error

(0) Share

Report

Posted on by KT-05050446-0

I have been trying to work around a code, but power app keeps on throwing error around it, essentially is a code that supposed to filter emails from a drop-down box. The code is as below:

// Step 1: Create a collection of distinct employee names
ClearCollect(
    TempDistinct,
    Distinct(
        Filter(AllRequests, Approver.Email = User().Email),
        Employee.DisplayName
    )
);
// Step 2: Rename the Result column to EmployeeName
ClearCollect(
    colEmployeeNames,
    RenameColumns(TempDistinct, "Result", "EmployeeName")
);
// Step 3: Sort the collection
ClearCollect(
    colSortedEmployeeNames,
    Sort(colEmployeeNames, EmployeeName, SortOrder.Ascending)
);
// Step 4: Add "All" to the collection at the beginning
ClearCollect(
    colSortedEmployeeNames,
    {EmployeeName: "All"}
);
Collect(
    colSortedEmployeeNames,
    Sort(colEmployeeNames, EmployeeName, Ascending)
);
 
 
Help with this will be appreciated. Thanks 

Categories:

Building Power Apps

Picture1.png

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

MS.Ragavendar 4,984 Super User 2025 Season 2 on at

Like (0)

Report

@KT-05050446-0,

Try in the below format as shown.

🏷️ Please tag me @MS.Ragavendar if you still have any queries related to the solution or issue persists.

✅ Please click Accept as solution if my post helped you solve your issue and help others who will face the similar issue in future.

❤️ Please consider giving it a Like, If the approach was useful in other ways.

Was this reply helpful? Yes No
KT-05050446-0 6 on at

Like (1)

Report

@MS.Ragavendar thank you for the code provided, but with the provided code, it means ill have to add an item for every item i have.

I have managed to resolve the issue by avoiding the result formula, instead done this:

// Step 1: Create a collection of distinct employee names

ClearCollect(

colEmployeeNames,

Sort(

Distinct(

Filter(AllRequests, Approver.Email = User().Email),

Employee.DisplayName

),

Value,

SortOrder.Ascending

)

);

// Step 2: Add "All" to the beginning of the collection

ClearCollect(

colEmployeeNamesWithAll,

Table({ Value: "All" })

);

Collect(

colEmployeeNamesWithAll,

colEmployeeNames

);

Was this reply helpful? Yes No