Office Get user profile + error null

[ALP1]

Hi, 

I made a flow that allows me to save in a Sharepoint list, the participants of a meeting.

However, it happens that the value of the column (UPN) is empty... and it causes the Office connector to fail.

Is it possible to bypass this error?

to avoid errors on the parse json action, i added 

 "type": [

            "object",

            "null"

        ],

"ID du participant (UPN)": {

                "type": [

                    "string",

                    "null"

How can i avoid this error ?

[WillPage]

Add new step: Filter array

Put the Parse JSON output into the From input

In the filter condition, item()?['ID du participant (UPN)'] is not equal to null

Both item()?['ID du participant (UPN)'] and null should be input via the expression editor.

Use the output of the filter in your Apply to each loop.

[ALP1]

Hi @WillPage  Thanks for your reply

If I correctly understood the output of the filter array action should display only those rows that have a value that is populated in the UPN column.

if I look at the ouput, the filtering does not seem to apply.

the output 

My filtering 

[WillPage · Accepted solution]

The blank value is actually an empty string here. We can see that in your yellow highlighted screen shot like : "" Therefore the leave the right side of the filter condition blank instead of putting null in there.

As an aside, you wrote null directly in The filter condition. If you want to evaluate a null/blank value, you must type null into the expression editor. However in this case the excel table is using an empty string as a blank value so just leave the filter condition right hand side blank.

[ALP1]

Thank you a lot. It's working now.