Answered

Unable to delete blank rows in List - Group being added as a Row Azure AD

(0) Share

Report

Posted on by Ethan1132

I have a flow which will be running weekly to help our users see who is part of a group of distribution lists.

The issue I am having is the flow is adding all members as an item. There are groups which have been added as a member. This is causing the Title to be blank, which breaks my flow the next time I run it.

I need to ideally get the flow to filter out any values which are blank, as we will be having multiple groups added in each group for SP Permissions.

The flow then repeats this for other groups with the same flow steps.

Categories:

General topics

I have the same question (0)

All responses (5)

Answers (1)

S-Venkadesh 1,214 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi @Ethan1132 ,
One approach is to perform a null check when creating an item. If the mail field is null, you can assign a static value, such as "BLANK," to indicate the absence of a value.
By doing so, 'Get Items' action will work as intended

I hope this information is helpful. If it is, please consider giving a thumbs up.

Best regards,
Venkadesh Sundaramurthy

Was this reply helpful? Yes No
Ethan1132 12 on at

Like (0)

Report
Copy link

Link copied!

I am probably doing this the wrong way, but when I try do this check I get an error with the ID number being an integer rather than an array.
Relatively new to PA and learning as and when I come across issues.

Was this reply helpful? Yes No
Verified answer

Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @Ethan1132,

After creating an item in the SharePoint list using the "Create item" action in Power Automate, the output will provide the ID value as an integer, not an array.
Since the ID is not an array, there is no need to use a foreach loop. Instead, you can perform a null check on the ID value directly after the "Create item" action.
Here is an updated approach:
Add the "Create item" action to create the item in the SharePoint list.
After the "Create item" action, add a "Condition" action to perform the null check on the ID value.
In the condition, check if the ID value is not equal to null or empty. If the condition is true, proceed with the desired actions or logic. If the condition is false, handle the case accordingly (e.g., show an error message or perform an alternative action).

I hope this information is helpful. If it is, please consider giving a thumbs up.

Best regards,
Venkadesh Sundaramurthy

Was this reply helpful? Yes No
Ethan1132 12 on at

Like (0)

Report
Copy link

Link copied!

HI Venkadesh.

I've tried to add this, however I am still getting an error with the ID being empty.

The issue seems to be the azure ID is valid, however when it then gives it to the User profile, the account does not have an ID, because the account is actually a group.

Was this reply helpful? Yes No
Ethan1132 12 on at

Like (0)

Report
Copy link

Link copied!

I managed to get round this by doing two things.

I created the item before hand and labeled it Blank. I then assigned the UserID at creation.
I was then checking to see if the UserID was blank, if it was the title would stay blank
At the bottom of my flow, i then checked all items and anything with the Title "blank" was deleted

Was this reply helpful? Yes No