The goal is to get all Notes associated with a Knowledge Article and put them in a file. I've posted all the expressions I've tried and no values return. I CAN see the annotation details in the Outputs after the List action but cannot return any values for any of the annotation fields using an expression and they aren't listed in the Dynamic content. I've tried several saves and exiting and coming back. Please help, I know this must be a simple solution or maybe this isn't possible, either way I would like to know!
There is no 'NavigationProperty' for the Annotation table in the Output, only knowledgearticle_Annotations@odata.navigationLink .
Filter rows: specified knowledage article & filter out null annotations
(knowledgearticleid eq '[removed for privacy]') and (knowledgearticle_Annotations/any(o1:(o1/annotationid ne null)))
Expand query: knowledgearticle_Annotations($select=notetext,annotationid,_createdby_value,createdon,subject,versionnumber)
None of these Expressions work when I put them in the Value of the HTML table:
- item()?['notetext']
- item()?['_regardingobjectid_value@OData.Community.Display.V1.FormattedValue'] item()?['notetext@OData.Community.Display.V1.FormattedValue'] item()?['annotations/notetext']
- item()?['knowledgearticle_Annotations/regardingobjectid_value/notetext']
- item()?['knowledgearticle_Annotations/notetext']
- items('Apply to each')?['notetext@OData.Community.Display.V1.FormattedValue']
I have looked at several posts in the community/google/youtube but they haven't helped resolve my issue 😞
