Condition

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

I'm extracting image from sharepoint list to mail in my flow

My flow is getting failed if their is no image in the column

So , I tried to use " condition " to check the column value (User Attachments - image column name )

After the action " Send an http request to sharepoint list , I need to check whether the particular column contain any image orn't

For that I'm passing following code in my condition

empty(body('Send_an_HTTP_request_to_SharePoint')?['User Attachments'])

not(equals(outputs('Send_an_HTTP_request_to_SharePoint')?['User Attachments'],null))

Spoiler (Highlight to read)

But the above expressions is s always returning "false" in the "Compose" action, regardless of whether the "User Attachments" field contains an image or not,

could anyone help me on this

Categories:

General topics

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

v-chengfen-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @Anonymous ,
I made a test for your reference:
The last image column in list is empty
In flow:
We can find that when the image column is empty, its value is null
So we need to judge whether it is null, we need to obtain this part of information through the formula:
first(outputs('Send_an_HTTP_request_to_SharePoint')?['body'].d.results)['image column name']
Here is result:

Best Regards
Cheng Feng

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!
Perfect Solution
Could u please explain why you are using .d.results In the formula

Was this reply helpful? Yes No
v-chengfen-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @Anonymous ,
We can see the body structure of [Send an HTTP request to SharePoint]'s output, the information of the Image column we need is in the .d.results in the body, we need to call the data in this way (this is very similar to the field of the call record in power apps, This record .columnName).

Finally because results is an array. We want to get the first one, so use first. We're going to use the property of the image column of the first record in the array.
first(outputs('Send_an_HTTP_request_to_SharePoint')?['body'].d.results)['image column name']

Best Regards
Cheng Feng

Was this reply helpful? Yes No