Unanswered

Flow to create multiple Outlook Meeting invites

(1) Share

Report

Posted on 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.

Categories:

Using flows

I have the same question (0)

All responses (7)

Answers (0)

Sort by

creativeopinion 10,508 Moderator on at

Like (0)

Report
Copy link

Link copied!

@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

Was this reply helpful? Yes No
sfatale 4 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
sfatale 4 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
creativeopinion 10,508 Moderator on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
sfatale 4 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
creativeopinion 10,508 Moderator on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
sfatale 4 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No