Answered

Flow Skipping Stages

(0) Share

Report

Posted on by deanking

Hi All.

Wondering if anyone can help me out. If my test run looks like this, does it mean it's skipping the 'Days Used 2' stage? And if so, how do I make it run each stage?

All responses (16)

Answers (1)

deanking 39 on at

Like (0)

Report

Re: Flow Skipping Stages

@Pstork1 .

It was because I was using the Output to generate it rather than the input.
Just about to try the update part now.

I'll let you know how I get on, really appreciate your support so far!
deanking 39 on at

Like (0)

Report

Re: Flow Skipping Stages

Right okay.

Just got this when running after doing the above.

[
  {
    "message": "Invalid type. Expected Object but got Array.",
    "lineNumber": 0,
    "linePosition": 0,
    "path": "",
    "schemaId": "#",
    "errorType": "type",
    "childErrors": []
  }
]
Verified answer

Pstork1 65,946 Most Valuable Professional on at

Like (0)

Report

Re: Flow Skipping Stages

The output doesn't go in the schema. The output gets pasted into the dialog that comes up when you click on the 'Generate from Sample' button.
deanking 39 on at

Like (0)

Report

Re: Flow Skipping Stages

Hi @Pstork1.

I've run a test run to get the filter array output but when I copy and paste it into the schema it's giving me an error.

Not sure which part I'm supposed to be pasting it to this field?
Pstork1 65,946 Most Valuable Professional on at

Like (0)

Report

Re: Flow Skipping Stages

Once you've filtered the output to get it down to just the one record you'll need to do a Parse JSON step to identify the different fields in the array. Use the output of a successful run up to the Filter array to get the sample to put into the Parse JSON to create the schema. After that you'll see the individual fields in the array in dynamic content. Then do your Update action in the apply to each.
deanking 39 on at

Like (0)

Report

Re: Flow Skipping Stages

There's only one entry for it to find.

I thought it would be an 'Apply to each' but not sure how to get it to work.

This is what I thought would work but it keeps causing it to error.

Not sure how to use the First() function.
Pstork1 65,946 Most Valuable Professional on at

Like (0)

Report

Re: Flow Skipping Stages

I'm assuming that after you filter there is only one item left. But remember its still an item in a collection of items. So to update it you'll need to either use the First() function to get the first record in the output from the filter or run the output of the filter command through an Apply to Each loop. If there is only one item after filtering you can just run the Apply to each and Update the item inside the loop. At that point all the details should be available as dynamic content. I'm assuming you want to use the current values to calculate and update to new values.
deanking 39 on at

Like (0)

Report

Re: Flow Skipping Stages

@Pstork1 I didn't even know Filter Array existed so thanks for this.

Right so, I've put that in place and now it's running and the filter is working.

The only part I have left to do it then to update the item that it found.

So now it has found data in the 'Holiday Allocations List' and then successfully filtered out the item with the same 'Display Name'.

How do I then use that found item to update the details. I know there is an 'update item' option but it doesn't pull through the specific item that it previously found. I hope this makes sense.
Pstork1 65,946 Most Valuable Professional on at

Like (0)

Report

Re: Flow Skipping Stages

Is this for an OData Filter in the Get Items? If so, you can't do an OData filter on a Person or Group column. You need to do Get Items and then filter the resulting array. Like this
deanking 39 on at

Like (0)

Report

Re: Flow Skipping Stages

That's right, it's a Person/Group column. I didn't realise that would be the case! I'm glad I know that now so thank you for the help.

I could do with some connections who know Power Automation and work with it as right now, I'm just self-taught and I'm heavily relying on forums/resources to learn more about it. 😂

Just added in the tweak and this is what I'm getting when running a test.