web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / select statment invali...
Power Automate
Answered

select statment invalid template

(0) ShareShare
ReportReport
Posted on by

Hi,

im having a wierd situation with a select statement, it works for the first 3 items but fail for all the others

select syntax:

"<tr><td>@{item()['ID']}</td><td>@{item()['Title']}</td><td>@{item()['O365_x0020_Service']['Value']}</td><td>@{item()['Groupowner']['Value']}</td><td>@{item()['Status']['Value']}</td><td>@{item()['Priority']['Value']}</td></tr>"

 

the error text:

Perez_0-1660575429790.png

 

the thing is that the property service does exist andf identified correctly for the first three records, but fails for all the others.

 

any idea?

 

thanks,

Eyal

Categories:
I have the same question (0)
  • Verified answer
    Ellis Karim Profile Picture
    12,027 Super User 2026 Season 1 on at

    Hi @Perez 

     

    Please try replacing: 

    item()['O365_x0020_Service']['Value']

    with

    item()?['O365_x0020_Service']?['Value']

     

    Snag_affa905.png

    If the property item()?['O365_x0020_Service'] or item()?['O365_x0020_Service']?['Value'] is missing, instead of stopping with an error, the expression  item()?['O365_x0020_Service']?['Value'] will return the value null and the flow should continue:

    Snag_b02d3ef.png


    Ellis
    ____________________________________
    If I have answered your question, please mark the post as Solved.
    If you like my response, please give it a Thumbs Up.

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the March Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Haque Profile Picture

Haque 604

#2
Valantis Profile Picture

Valantis 502

#3
Vish WR Profile Picture

Vish WR 417

Last 30 days Overall leaderboard