Adaptive Card use with table or array data

@Mark Zigadlo
the important thing is understands data being returned by the action. You can use developer.blackbaud.com API Reference for the specific API call to understand.

if the dynamic content you are trying to add is within an array/list of values, you will get Apply to each from flow automatically. The way to handle is to make a concious decision on if are you expecting always only ONE value or MANY values. Even after using the method below (Filter Array).

after getting a list of notes for constituent, you can use “filter array” action to filter the notes by note type equals to the type you want. filter array will always return an array, since it cannot foresee if there will or will not be only ONE match based on your filter. So if you were to select dynamic content from the filter array action, flow will still put the action you are adding dynamic content from filter array into an apply to each. So the question is now more “business” related, are you expecting ONLY one note of the type you want, or are you expecting MANY. If you know there can ONLY be ONE, then you can use the first() expression to get the first item in the list of item. first() will intake the “body” of the filter array, and then specify the specific property you want. For example: first(body('Filter_Array_Action_Name'))?['summary']

if you are going to access multiple properties of this filtered note, then you can use a Parse JSON with the first(body('Filter_Array_Action_Name')) as the Content. and provide the Schema using sample. this way, your subsequent action can use the dynamic content from the Parse JSON action without having flow putting apply to each automatically.

If you expect there are MANY note that match, then you will need to determine how you want to display the multiple note's information (in a table, in a factset, or concatenated into a string), how you plan to display will affect how you will code to get the info.