Hi Community,
I am trying to generate a flow to send an email with an image loaded in a sharepoint column of image type, but the "Compose" step gives me the following error.
Does anyone know how it could be solved?.
Thanks for youre help¡.
Check if the expected property Foto1 exists in the output of "Send an HTTP request to Sharepoint".
Hi @Chriddle
Thanks, it doesn't actually give the error, but I have a question as to why it should return a null value if there is an associated image.
And if possible, I would also like to ask you how I can solve the problem that now generates the error in the step that follows the flow (Get File Content Using Path).
Thanks you very much¡
Either the property Photo returns null or there is no property Photo or the results array is empty or not existent at all.
Just remove the question marks from your expression and the error message will tell you.
If you don't care what caused the error and just want to get rid of it, you can use:
json(coalesce(body('Send_an_HTTP_request_to_SharePoint')?['d/results']?[0]?['Foto1'], '{}'))
This expression returns an empty object if Photo is null.
The expresion I used is:
Thanks for youre help¡.
Hi@Francisco77 , could you provide the expression you are using?