Power Automate - Apply to Each 2 (skipped)

[JMBernardo]

Dear Power Users,

I'd like to seek your help about my automation. So I have this flow that when an item is created in my sharepoint list, it will send an automated email with an attachment (excel file) to the user.

Now on the condition part, I created a column in my sharepoint list named (varEmail_Normal) where it has 3 status: "On-going", "5th month" & "Sent"

The email will trigger depending on those 3 status. The default value is "5th month" where it won't send an email, once I changed it to "On-going", then it will fire an email and updates the column to "Sent" now this is just to avoid an infinite loop.

However, this was not being implemented as the Apply to each 2 below kept on being skipped.

See Apply to Each 2:

Thanks y'all for the support!

[SanmeshG]

Hi @JMBernardo  ,

Which value (ID) are you passing in the Update Item action ?

Looks like you are passing the ID from Get Files action. If your column is in the same list as that of your trigger list and you want to update the status then you should use ID from trigger action.

Currently the apply to each 2 action is being skipped because there are no items retrieved from the Get Files action.(This is my  assumption from your screenshots).

If this helps , please give this a thumbs up and mark this as a solution.

Thanks,

Sanmesh

[JMBernardo]

Hello @SanmeshG ,

I am using the ID in the trigger action, this confuses me when I tried to changed the Condition which is the varemail column is equal to Yes - the flow triggers, but if it is equal to No, it's being skipped