Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Automate - Building Flows
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

  • Verified answer
    Ellis Karim Profile Picture
    11,092 Super User 2025 Season 1 on at
    Re: select statment invalid template

    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

Michael Gernaey – Community Spotlight

We are honored to recognize Michael Gernaey as our June 2025 Community…

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 566 Super User 2025 Season 1

#2
David_MA Profile Picture

David_MA 516 Super User 2025 Season 1

#3
stampcoin Profile Picture

stampcoin 492