cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
LinkToTheAsh_
Frequent Visitor

Check if SharePoint Rest API results are blank

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.

 

LinkToTheAsh__0-1621512720411.png


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.

1 ACCEPTED SOLUTION

Accepted Solutions
Expiscornovus
Dual Super User
Dual Super User

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'])

 

isequalto0.png

 

View solution in original post

2 REPLIES 2
Expiscornovus
Dual Super User
Dual Super User

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'])

 

isequalto0.png

 

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

Helpful resources

Announcements
MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

Power automate tips 768x460 v2.png

Restore a Deleted Flow

Did you know that you could restore a deleted flow? Check out this helpful article.

Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

May UG Leader Call Carousel 768x460.png

What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.

Users online (3,315)