cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
TesDA
Responsive Resident
Responsive Resident

Select Error: Unable to evaluate template language expression '@item()?['Work_x0020_Location']' as JSON property name: the property with name '' already exists.'.

I have a select statement below. The data is coming from sql, so I can update the view to solve the problem there as well. Select Fail.jpg

(from code view)

select": {
            "@item()?['Client_x0020_Name']""Client Name",
            "@item()?['Position_x0020_Title']""Position Title",
            "@item()?['Open_x0020_Seat_x0020_Number']""Open Seat Number",
            "@item()?['Open_x0020_Seat_x0020_Status']""Open Seat Status",
            "@item()?['Priority']""Priority",
            "@item()?['Need_x0020_by_x0020_Date']""Need by Date",
            "@item()?['Open_x0020_Date']""Open Date",
            "@item()?['Contract_x0020_End_x0020_Date']""Contract End Date",
            "@item()?['Level']""Level",
            "@item()?['Work_x0020_Location']""Work Location  ",
            "@item()?['Clearance_x0020_Requirement']""Clearance Requirement",
            "@item()?['Contract_x0020_Type']""Contract Type",
            "@item()?['Functional_x0020_Skills']""Functional Skills",
            "@item()?['Strategic_x0020_Resource_x0020_Manager_x0020__x0028_SRM_x0029_']""Strategic Resource Manager (SRM)",
            "@item()?['US_x0020_Citizenship_x0020_Required']""US Citizenship Required",
            "@item()?['_x0023__x0020_of_x0020_Resources_x0020_Needed']""# of Resources Needed"
        }
 
I'm getting the following error that I don't know how to fix:
InvalidTemplate. The execution of template action 'Select_2' failed: The evaluation of 'query' action
'where' expression '{ "@item()?['Client_x0020_Name']": "Client Name", "@item()?['Position_x0020_Title']":
"Position Title", "@item()?['Open_x0020_Seat_x0020_Number']": "Open Seat Number",
"@item()?['Open_x0020_Seat_x0020_Status']": "Open Seat Status", "@item()?['Priority']": "Priority",
"@item()?['Need_x0020_by_x0020_Date']": "Need by Date", "@item()?['Open_x0020_Date']": "Open Date",
"@item()?['Contract_x0020_End_x0020_Date']": "Contract End Date", "@item()?['Level']": "Level",
"@item()?['Work_x0020_Location']": "Work Location ", "@item()?['Clearance_x0020_Requirement']":
"Clearance Requirement", "@item()?['Contract_x0020_Type']": "Contract Type",
"@item()?['Functional_x0020_Skills']": "Functional Skills",
"@item()?['Strategic_x0020_Resource_x0020_Manager_x0020__x0028_SRM_x0029_']":
"Strategic Resource Manager (SRM)", "@item()?['US_x0020_Citizenship_x0020_Required']":
"US Citizenship Required", "@item()?['_x0023__x0020_of_x0020_Resources_x0020_Needed']":
"# of Resources Needed" }'
failed: 'Unable to evaluate template language expression '@item()?['Work_x0020_Location']' as
JSON property name: the property with name '' already exists.'.
 
1 ACCEPTED SOLUTION

Accepted Solutions
TesDA
Responsive Resident
Responsive Resident

I had it backwards. The item() needs to go into the second select cell, not the first

View solution in original post

3 REPLIES 3
PrasadAthalye
Super User
Super User

I see a space in Work location mapping .. May be thats an issue?

 

"@item()?['Work_x0020_Location']""Work Location  ",

Please Like and Mark this as Answer if it resolves your Issue.

Power Automate Community
TesDA
Responsive Resident
Responsive Resident

@PrasadAthalye I deleted the space and it still didn't work.

TesDA
Responsive Resident
Responsive Resident

I had it backwards. The item() needs to go into the second select cell, not the first

View solution in original post

Helpful resources

Announcements
MPA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Top Solution Authors
Users online (1,183)