Scheduled Flow as a Child Flow

(0) Share

Report

Posted on by Micaiah

198

Hello everyone,

So currently I have two flows, the first one is triggered when my status column is changed to either approved or update and depending on which is selected, a new event is created or an existing one is updated. My 2nd flow was originally a child flow that pulled information from the 1st flow to send an email to the event owners. However, I realized this was going to get annoying since an email was sent every time the flow ran and the event owners would get a bunch of emails. So, I want to change the child flow to a scheduled one to get all the items in my SharePoint list at the end of the day(5:00pm) that have either been approved or updated and send emails that way. My questions are:

1) How can I make the scheduled flow a child flow? Even though I want it to run at the end of the day, I still want to get items based on the conditions of the first flow. Should the two flows exist separately instead?

2)I'm trying to group items with the same audience and event owner so multiple unnecessary emails aren't sent but my filter query isn't giving the options I need in the dynamic section and I'm not sure why:

Any help would be greatly appreciated.

Categories:

Building flows

I have the same question (0)

All responses (7)

Answers (1)

Verified answer

Manish Solanki 15,167 Moderator on at

Like (1)

Report
Copy link

Link copied!

Hi @Micaiah

You could not make schedule flow a child flow. You can only make 'Instant cloud flow' flow as child flow with the required input/output parameters. To group data and send consolidated email, please refer the logic mentioned in my blog:

Single consolidated email to user (owner) for single select user field in SharePoint - Microsoft Power Platform (manish-solanki.com)

If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.

Was this reply helpful? Yes No
Micaiah 198 on at

Like (0)

Report
Copy link

Link copied!

Thank you! I'll give this a try when I get back to work tomorrow and let you know how it goes.

Was this reply helpful? Yes No
Micaiah 198 on at

Like (0)

Report
Copy link

Link copied!

Hello,
So I gave the steps in your blog a try(it was super helpful btw) and I got this error msg when I ran the flow:
I had to do a custom item since the column wouldn't show up in the list of options for the filter query. I typed the name the same way it is in my SharePoint list so I'm not sure what's wrong.

Update:
I just needed to remove the space in the column name and it worked perfectly! Do you know how I can do a count of the records in the html table?

Was this reply helpful? Yes No
Manish Solanki 15,167 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi @Micaiah

One way is to calculate the length of input array passed in 'From' parameter. You need to use length() function for the same. This way you can get the rows in html table.

If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.

Was this reply helpful? Yes No
Micaiah 198 on at

Like (0)

Report
Copy link

Link copied!

And where would I put the length function? Like would it be in a compose or Initialize variable action?

Was this reply helpful? Yes No
Manish Solanki 15,167 Moderator on at

Like (1)

Report
Copy link

Link copied!

Hi @Micaiah

You could use either compose or integer variable for storing the length of an array.

If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.

Was this reply helpful? Yes No
Micaiah 198 on at

Like (0)

Report
Copy link

Link copied!

That worked! Thank you for all the help!

Was this reply helpful? Yes No