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?

Categories:

Using flows

I have the same question (0)

All responses (16)

Answers (1)

Sort by

CFernandes 8,504 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@deanking

Hey Mate,

You might want to check, if there is data being pulled into the Apply to each block. If there is no data then the loop will be skipped..

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

Was this reply helpful? Yes No
deanking 39 on at

Like (0)

Report
Copy link

Link copied!

Hi @CFernandes.

Appreciate your reply.

There is data in the block above. I'm basically building a flow to do the following.

Trigger - When a response is submitted.
- Get response details
- Get user
- User's line manager
- Add details to a list.
- Find the user in another list.
- Add one field from the first list with a field from the other list.

Everything runs fine, besides the part it's skipping.

Was this reply helpful? Yes No
deanking 39 on at

Like (0)

Report
Copy link

Link copied!

@CFernandes Here's it pulling the data through.

Was this reply helpful? Yes No
Pstork1 69,203 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

What @CFernandes is saying is that the Apply to Each loop in your run has a null collection when it gets to it. So double check the actual data being gathered. I can see you've defined it to have data, but that doesn't mean there is any actual data when you get there.

Was this reply helpful? Yes No
deanking 39 on at

Like (0)

Report
Copy link

Link copied!

Hi @Pstork1. Thanks for your comment.

I get what you're saying, but I can't seem to figure out why it isn't pulling data through.

Here's what the item it's looking for contains. I'm using the 'Get Items' block to check this list via a filter query for the employee column which is Employee eq 'Display Name'.

When testing the flow and looking at that specific question, it is saying that the employee = Dean King. So should be pulling my data through right?

Was this reply helpful? Yes No
Pstork1 69,203 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Is the Employee column a Person/Group column? If it is then the test should be Employee.DisplayName = Dean King, not just Employee. Employee will return an object, not a string. Also the test will be case sensitieve. Something about that check isn't working right. Not sure exactly what.

Was this reply helpful? Yes No
deanking 39 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Pstork1 69,203 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
deanking 39 on at

Like (0)

Report
Copy link

Link copied!

@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.

Was this reply helpful? Yes No
Pstork1 69,203 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No