Flow to create multiple Outlook Meeting invites

Like (1) Share

Report

Posted on 10 Jul 2024 11:43:42 by sfatale

Hi,

I am using an old fcloud low that was working nicely till last week to create Outlook meeting invites. To create these invites, I am passing the XLSX file with all the meeting details. The flow copies the file on SharePoint and reads it again to create invites. Surprisingly, the loop that goes through each row and creates invites is getting stuck while reading the first row or fetch table. The flow is not throwing any errors.

I would like to understand what can be done and how I could fix this issue.

Here is the screenshot of the loop step where the flow is getting stuck.

All responses (7)

Answers (0)

sfatale 4 on 26 Jul 2024 at 13:04:58

Like (0)

Report

Flow to create multiple Outlook Meeting invites

Thank you @creativeopinion for suggestion to use Compose action instead.

I followed troubleshooting steps in the past and verified the output at each step. The flow is able to create multiples Teams Meeting invites when I am using Personal Calendar or Calendar names that are visible in the Teams Meeting creation action. In the current flow, I am trying to use shared calendar to create multiple meeting invites. Flow is failing whenever I am using shared calendar for creating invites.

I tried out suggestions available on the forum to add shared calendar but even with that I am not able to see the shared calendar name in Teams Meeting creation action.
creativeopinion 10,419 Super User 2025 Season 1 on 25 Jul 2024 at 17:20:25

Like (0)

Report

Flow to create multiple Outlook Meeting invites

It looks like you can simplify your flow a bit. You can replace the Variables with a Compose action instead. A Compose action can act as a container to hold values and you don't need to initialize and set them as you do with Variables.

I would recommend creating a copy of your flow and removing all actions up until your first Apply to Each action. Run a test and upload a screenshot of your flow run with all actions expanded. It's always best practice to run test of your flow at each point and troubleshoot rather than building your entire flow and trying to troubleshoot it later.
sfatale 4 on 23 Jul 2024 at 02:33:56

Like (0)

Report

Flow to create multiple Outlook Meeting invites

Hi @creativeopinion,

I have debugged the flow by creating it from scratch and verifying the correct output after every step. It is my observation that the connector that creates Teams Meeting is not able to execute successfully and that is the reason flow is failing after trying out the same step multiple times.
creativeopinion 10,419 Super User 2025 Season 1 on 16 Jul 2024 at 03:21:39

Like (0)

Report

Re: Flow to create multiple Outlook Meeting invites

@sfatale Sorry it's still unclear which portion of your flow is not working. Do you have a screenshot of the last flow run you can upload?
sfatale 4 on 15 Jul 2024 at 15:25:27

Like (0)

Report

Re: Flow to create multiple Outlook Meeting invites

Hi,

I tried out the same flow with sample input. It looks like the flow is failing with a "StatusCode: 502" error message. I tried to find some solution but did not get any.

Any kind of help is useful. Below is the snippet of the error message which is the Output of failed "Teams Meeting creation" action.
sfatale 4 on 11 Jul 2024 at 05:26:50

Like (0)

Report

Re: Flow to create multiple Outlook Meeting invites

Hi @creativeopinion ,

Here are the snippets of the expanded actions:
I have checked the output for Get tables action and here is the snippet of it.
It looks like the action has succeeded.
creativeopinion 10,419 Super User 2025 Season 1 on 10 Jul 2024 at 14:12:23

Like (0)

Report

Re: Flow to create multiple Outlook Meeting invites

@sfatale Can you click on each action to expand it? It would help to provide additional insights on your flow logic. Also, can you confirm that the Get tables action has an output?

Hope this helps!

If I helped you solve your problem—please mark my post as a solution ✅.
Consider giving me a 👍 if you liked my response!

👉 Level up your Power Automate skills by checking out my tutorials on YouTube
👉 Tips and Tricks on TikTok and Instagram