ActionConditionFailed - create sharepoint item

[vipfafen]

 Hi all,

I built a flow that reads users, their managers and merges them into a sharepointlist. I have about 500 identical outputs/inputs, 27 of them which run into the error "ActionConditionFailed"

Full Error message:

Spoiler

ActionConditionFailed

The execution of template action 'Create_item' is skipped: the 'runAfter' condition for action 'Get_manager_(V2)' is not satisfied. Expected status values 'Succeeded' and actual value 'Failed'.

Flow:

The input to a healthy and non-healthy action (Sharepoint - create item):

Healthy:

{
    "host": {
        "connectionReferenceName": "shared_sharepointonline",
        "operationId": "PostItem"
    },
    "parameters": {
        "dataset": "https://...",
        "table": "...",
        "item/UserPrincipalName": "...",
        "item/DisplayName/Claims": "...",
        "item/LastLogin": ""
    }
}

non-healty

{
    "host": {
        "connectionReferenceName": "shared_sharepointonline",
        "operationId": "PostItem"
    },
    "parameters": {
        "dataset": "https://...",
        "table": "...",
        "item/UserPrincipalName": "...",
        "item/DisplayName/Claims": "...",
        "item/LastLogin": ""
    }
}

PS: The dotted entries are identical except for the "UPN" and "displayname"

how to deal with it? what exactly is broken in the affected 27 actions?

Thank you

Regards

[Sayan]

Hey @vipfafen 

I think in the 27 rows has invalid or empty data that's why it is unable to check the condition and giving error.

can you please match the data with the condition.

------------------------------------------------------------------------------------------------------------------------------

If my suggestion helps you please give it a Thumbs up and Mark as a Solution. It motivates to solve more problems.

Thanks 

Sayan Patra

RPA Developer

[vipfafen]

Hi @Sayan, 

thank you for your replay!

As I mentioned in my description. Is the "Create Item" input, the same as for the healthy ones. The display name and UPN match, just like the healthy values. The specified user definitely exists and was also pulled through the flow during the process.

Create Item output: 

healty:

{
    "statusCode": 201,
....
    },
    "body": {
        "@odata.etag": "\"1\"",
        "ItemInternalId": "1229",
        "ID": 1229,
        ....
    }
}

unhealthy:

{
    "statusCode": 400,
    "headers": {
    ...

    },
    "body": {
        "status": 400,
        "message": "The specified user <USER> could not be found.\r\nclientRequestId: 089ca4...\r\nserviceRequestId: b5..."
				   

Affected user is a System-Prod user, for exampel:

- User_stage

- User_dev

- User_prod

the first two users work, the third not. Apart from UPN and display name, there are no differences between the 3 users

I hope I understood the question correctly

thank you!

Regards

[Sayan]

Hey @vipfafen 

On the unhealthy one:

On the Message it is clearly saying that "The specified user could not be found".

So, Get Profile Action unable to Extract the Profile. That's why It is unable to Create item in sharepoint.

Thanks,

Sayan Patra

RPA Developer

[vipfafen]

Hi @Say, 

thank you for you hint! I will follow up on this.

Regards

[Sayan]

Hey @vipfafen 

Please try and if solved please marks it is a solution.

-----------------------------------------------------------------------------------------------------------------------------

Thanks,

Sayan Patra | RPA Developer

[vipfafen]

Hi @Sayan,

Unfortunately I can't figure it out. The entire flow is a copy of a full functioning flow, except that it is not about guest users but about member users. To do this, I only adapted the expression, which I have already changed several times, so that nothing can be done wrong.

Expression:

and(
    equals(item()?['AccountEnabled'], true),
    equals(item()?['UserType'], 'Member'),
    not(endswith(item()?['UserPrincipalName'], '@xxx.de'))
)

i also testet this one:

and(
    equals(item()?['AccountEnabled'], true),
    equals(item()?['UserType'], 'Member')
)

First of all, the number of filtered users is correct, Sharepoint creates around 30 fewer. 

Input - "Apply to each - create sharepoint items"

Even the input does not differ from that of a functional user

Functional stage user - input:

Non-functional user - input:

Under the user management, the users do not differ at all apart from the DisplayName, UPN and IDs.

Error Message:

ActionConditionFailed

The execution of template action 'Create_item' is skipped: the 'runAfter' condition for action 'Get_manager_(V2)' is not satisfied. Expected status values 'Succeeded' and actual value 'Failed'.

The copilot gave me the following advice:

It seems that the error occurred in the 'Get_manager_V2' operation. To fix this, check the parameter names used in the 'Get_manager_V2' action against the output data. Ensure that the parameter names match the keys in the output data, such as 'AccountEnabled' instead of 'accountEnabled'. Make sure the parameter names are case-sensitive and match exactly as provided in the output.

"Get manager (V2)" input:

- items('Apply_to_each_-_create_sharepoint_Items')?['UserPrincipalName']

.. it works for all, but not for the 30 missig entries? The same input as in the working "guest" flow.

I can't recognize the error

Regards