Pulling rating information in Power Automate

Hillel Rosenzweig
Hillel Rosenzweig
Name Dropper Facilitator 1 September 2024 Monthly Challenge
in SKY Developer General Discussions

Hello! I'm having trouble with a flow I'm working on. I'm trying to pull the description of a rating and list it in an emails sent to co-workers. I've tried a the value of the rating into an append array,, but it didn't return what I expected. I want it to just return one rating description. What am I missing?

1fdb72ba8727f11f1f3e83265472dd64-huge-im
flow snippet
df6ee9c0a3d7bbbcf6fc47c1fdbc55de-huge-im
record
A screenshot of a computer AI-generated content may be incorrect.
what the email returned
Tagged:

Comments

  • Carol Grant
    Carol Grant
    Seventh Anniversary Kudos 5 First Reply Name Dropper

    Hi- it looks like you are pulling from the rating table not your Filter Array for Ratings. So it's returning all ratings. You need to use the Rating Description under the Filtered Array Ratings section instead.

  • Alex Wong
    Alex Wong Community All-Star
    Ninth Anniversary Kudos 5 Facilitator 3 Raiser's Edge NXT Fall 2025 Product Update Briefing Badge

    Rating returned is an array of ratings. First you want to filter array to get the one you want (i.e. filter by source or category, etc). Filter array returns all items that matches in an array, so even if you expect only ONE rating from filter array, you will still be working with an array of ONE item, you will need use to "first()" expression to get the one rating from the array.

    first(body('Filter_Array_Ratings'))?['value']

Categories