Foreach item value not retrieved

(0) Share

Report

Posted on by AC-21101902-0

Hi,

I'm using a flow to count the emails inside a columns in a sharepoint list (ex: pippo@example.it; pluto@example.com will return "2")

I'm using a Get_Items action to read the list, the a Foreach action to work on single item

I combine the split function with length to count the occurrences of "@": length(split(items('Foreach')?['siteOwners'], '@'))

The test raises error for missing value (null):

So I simplified the function to extract only the siteOwners data in a variable: items('Foreach')?['siteOwners']. The test run without error but output is null

Note thatI checked Foreach output that reports 4 items to loop, each one with SiteOwners columns with data.

So I think the error raised by split function is for null value, but not for missing value but concerned a syntax error in "items('Foreach')?['siteOwners']." Where is the error in the flow?

Tks

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (0)

Suggested answer

rzaneti 4,263 Super User 2025 Season 2 on at

Like (1)

Report

Hi,

Based on the shared images, it looks like Power Automate cannot find the property siteOwner in your SP List records. Since you are using the question mark before the property reference, Power Automate returns a null whenever the property is missing.

I recommend you to double check if siteOwner is the actual logical name of the SharePoint column. You can do it by checking the raw outputs from your Get items action (if you don't know how to access the raw outputs, follow these steps), and try to identify the name of the property that contains your data. Eventually the property name starts with a capital letter, and it can be breaking your flow.

Also, once the flow works, I recommend you to review the outputs from your expression, since it looks like it will return always 1 more result than the total quantity of email addresses. If you apply a split to the text "pippo@example.it,pluto@example.com" using the "@" as separator, you will have a total of 3 items in your array: "pippo", "example.it,pluto" and "example.com". If this is the case, I would recommend you to use a comma as separator :)

Let me know if it works for you or if you need any additional help!

-------------------------------------------------------------------------
If this is the answer for your question, please mark the post as Solved.
If this answer helps you in any way, please give it a like.

http://digitalmill.net/

https://www.linkedin.com/in/raphael-haus-zaneti/

Was this reply helpful? Yes No
Suggested answer

SudeepGhatakNZ 14,394 Most Valuable Professional on at

Like (1)

Report

Try the following expression in your Foreach. This should handle null values

if(empty(items('Foreach')?['siteOwners']), 0, length(split(items('Foreach')?['siteOwners'], '@')) - 1)

Was this reply helpful? Yes No
AC-22101443-0 2 on at

Like (0)

Report

I made some changes during the day and moving the main function in a Compose action

length(split(items('Foreach')?['siteOwners'], '@'))

then the run works

Also I added a condition to work almost one occurrence is found

Thk @all for suggestion

Was this reply helpful? Yes No