Check if SharePoint Rest API results are blank

(0) Share

Report

Posted on by LinkToTheAsh_

Hi All,

I have a flow where I am testing if a user belongs to a SharePoint group and then creates an array of the groups they belong to.

Do do this I am filtering through an Array of all groups as below and then I want to check if the results from this HTTP request are blank (equal to "[]") as shown below.

The outputs of a (_api/web/sitegroups/GetByName('GroupName')/Users?$filter=Email eq 'EmailAddress') when the group doesn't contain this user looks like this.

{
 "d": {
 "results": []
 }
}

However Power Automate see's this "[]" parameter as an array and won't perform the check. How can I create a condition that check if these results are blank?

I've tried using double and single quotes around the square brackets, I've tried "null" as well as leaving the parameter empty but no luck.

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

Expiscornovus 33,175 Most Valuable Professional on at

Like (1)

Report
Re: Check if SharePoint Rest API results are blank

Hi @LinkToTheAsh_,

In your condition action you could check for the length of the response. If it is equal to 0 it is empty.

length(outputs('Check_if_Buyer_is_a_Member')?['body/d/results'])

Was this reply helpful? Yes No
LinkToTheAsh_ 10 on at

Like (1)

Report

Re: Check if SharePoint Rest API results are blank

@Expiscornovus that worked perfectly, so simple I feel like banging my head against the wall now haha. Thank you.

Was this reply helpful? Yes No