Create Planner tasks from Excel database

Saskia Ricker 96 Reputation points
2021-08-04T14:20:52.607+00:00

I want to create a MS flow that automatically creats planner tasks on the basis of an excel database.

It already worked well creating the flow, but when I want to select the Group wherere the plan is attached, I can not find all my groups that I have in my MS Teams. I can link the flow to some of my groups, but I can't find the one where I want to insert it to. When I create a new group, it is not displayed either.

Can my problem be related to the combination of "tasks" and "to does" a year ago? Are there any specific settings for groups so thy do appear in the selection?

Microsoft Teams Microsoft Teams for business Other
{count} votes

Accepted answer
  1. Saskia Ricker 96 Reputation points
    2021-08-06T07:24:33.257+00:00

    Hi @JimmyYang-MSFT ,

    my great colleague solved the problem: there seems to be a limitation in the dropdown to select the group-IDs to 100 groups. As I was owner or follower from more than 100, only the 100 oldest groups where shown. I reduced the number of groups that I am following, and now it works :)

    Thanks for taking care of my request.

    Best,
    Saskia


1 additional answer

Sort by: Most helpful
  1. Saskia Ricker 96 Reputation points
    2021-08-05T10:40:52.81+00:00

    120786-plan.jpg

    I am using Excel Online and Flow as an Add-On. After selecting the database-table I choose "create planner task" as next step. The first thing here is to choose the group. I find several groups there, but not the group that contains the plan where I want to create the tasks for.

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.