Dear All
I am very new to MS flow. I am trying to create a plan dashboard but not able to do so. I have created an excel with team members and tasks. I have uploaded the same in sharepoint . In my microsoft teams I want to create plan dashboard for the members . I want to display the activities by week, display the role, tasks .I failed initially with date. I do need help if I give the email id of the team member can it take the user ID as my company details. Sorry for posting this request . But requesting you help Thanks for your help
Cost ID | category | Member role | Add Task here | Name of Associate | Starting Date | Date due | Week of Year | Total work days | Task Name |
XA1345 | Agile development | Coder | login create | Tom | 16-12-2019 | 20-12-2019 | 51 | 5 | XA1345Agile developmentCoderlogin create |
XA1345 | Agile development | Tester | Login check | Jerry | 16-12-2019 | 20-12-2019 | 51 | 5 | XA1345Agile developmentTesterLogin check |
XA1345 | Agile development | Coder | side bar create | Tom | 23-12-2019 | 27-12-2019 | 52 | 5 | XA1345Agile developmentCoderside bar create |
XA1345 | Agile development | Tester | side bar check | Jerry | 23-12-2019 | 27-12-2019 | 52 | 5 | XA1345Agile developmentTesterside bar check |
XA1345 | Agile development | Coder | Transaction code | Tom | 30-12-2019 | 11-01-2020 | 53 | 10 | XA1345Agile developmentCoderTransaction code |
XA1345 | Agile development | Tester | Transcation check | Jerry | 30-12-2019 | 11-01-2020 | 53 | 10 | XA1345Agile developmentTesterTranscation check |
XA1345 | Agile development | Coder | Valide code | Tom | 30-12-2019 | 11-01-2020 | 53 | 10 | XA1345Agile developmentCoderValide code |
XA1345 | Agile development | Tester | validate check | Jerry | 30-12-2019 | 11-01-2020 | 53 | 10 | XA1345Agile developmentTestervalidate check |
Hi @johnabrahambio ,
Where are you want to create the plan in?
I have made a test on my side and we could only create task for a plan in Planner connector in Microsoft flow currently,
if you want to create plan in planner with Microsoft flow, the requirement couldn't be achieved and you could consider submitting an idea to flow ideas forum:
https://powerusers.microsoft.com/t5/Flow-Ideas/idb-p/FlowIdeas
Best regards,
Alice
Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thanks
I am trying to create the plan in MS teams. Is there a possibility to create tasks in my teams and show the tasks against respective members in my teams.?
I am having terrible issues to get the dates from excel to MSFLOW. Its not recognizing the dates.
In the excel I have start date time and Due Date time. I tried having empty rows for start date time and Due Date time
when there is no data in the start date time and due date time I used following expression
addDays(utcNow('dd/MM/yyyy'),0,'dd/MM/yyyy')
addDays(utcNow('dd/MM/yyyy'),8,'dd/MM/yyyy')
Idea is to take current date and get the start date and due date which is 8 days from start date.
That didnt work
I also tried following
addDays('1900-01-01',float(item()['Starting Date']),'yyyy-MM-dd')
addDays('1900-01-01',int(item()['Due Date Time']),'dd-MM-yyyy')
and then did with empty columns in excel
concat(formatDateTime('Starting Date Time','yyyy-MM-dd'),'T00:00:00Z')
concat(formatDateTime('Due Date Time','yyyy-MM-dd'),'T00:00:00Z')
I am also attaching my flow. Is there a way to make this happen
Hi Alice and v-alzhan-msft
Thanks
I am trying to create the plan in MS teams. Is there a possibility to create tasks in my teams and show the tasks against respective members in my teams.?
I am having terrible issues to get the dates from excel to MSFLOW. Its not recognizing the dates.
In the excel I have start date time and Due Date time. I tried having empty rows for start date time and Due Date time
when there is no data in the start date time and due date time I used following expression
addDays(utcNow('dd/MM/yyyy'),0,'dd/MM/yyyy')
addDays(utcNow('dd/MM/yyyy'),8,'dd/MM/yyyy')
Idea is to take current date and get the start date and due date which is 8 days from start date.
That didnt work
I also tried following
addDays('1900-01-01',float(item()['Starting Date']),'yyyy-MM-dd')
addDays('1900-01-01',int(item()['Due Date Time']),'dd-MM-yyyy')
and then did with empty columns in excel
concat(formatDateTime('Starting Date Time','yyyy-MM-dd'),'T00:00:00Z')
concat(formatDateTime('Due Date Time','yyyy-MM-dd'),'T00:00:00Z')
I am also attaching my flow. Is there a way to make this happen
Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!
Power Platform release plan for the 2021 release wave 1 describes all new features releasing from April through September 2021.
User | Count |
---|---|
91 | |
58 | |
41 | |
39 | |
38 |
User | Count |
---|---|
83 | |
71 | |
57 | |
56 | |
42 |