Compose Error: Unable to process template language expressions in action 'Compose' inputs at line '0' and column '0': 'The template language function 'json' expects its parameter to be a string or an XML. The provided value is of type 'Null'. Please see https://aka.ms/logicexpressions#json for usage

(0) Share

Report

Posted on by Francisco77

353

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¡.

Categories:

General topics

I have the same question (0)

All responses (5)

Answers (0)

Sort by

abouchaala007 on at

Like (0)

Report
Copy link

Link copied!

Hi@Francisco77 , could you provide the expression you are using?

Was this reply helpful? Yes No
Francisco77 353 on at

Like (0)

Report
Copy link

Link copied!

Hi @abouchaala007

The expresion I used is:

json(body('Send_an_HTTP_request_to_SharePoint')?['d/results']?[0]?['Foto1'])

Where Foto1 is the internal name of column.

Thanks for youre help¡.

Was this reply helpful? Yes No
Chriddle 8,691 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
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.

Was this reply helpful? Yes No
Francisco77 353 on at

Like (0)

Report
Copy link

Link copied!

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¡

Was this reply helpful? Yes No
Chriddle 8,691 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Check if the expected property Foto1 exists in the output of "Send an HTTP request to Sharepoint".

Was this reply helpful? Yes No