Відео

Please update your tutorial as it is based on an very old version of planner.

My flow takes 10 minutes and what can it be for?

Newbie to Workflows but would be nice to see this updated as this is the only video I see explaining this. Would be good to see this created from the beginning to help find everything better. Also would be good to see how to troubleshoot as mistakes happen and would be good to know how to id them and see what to look for. Otherwise, I appreciate the content.

Can somebody help me? Tutorial looks very nice but I mess up following the "Itarate Action". I looks simply not available under Actions. Has it been renamed meanwhile?

Thank you for the video. I really appreciate it. I created this flow for me, it shows no error, but it is getting timeout in the loop. Can someone please guide me on how to work around it?

AWESOME tutorial! thanks for you help 🧡

Hi im stuck at body('List_bucket/task')?['value'] I cant find in the dynamic value which contain bucket/task. Simply say can you do tutorial for step 4 1 by 1 again?

I tried over 20 times and can't get it to work😭

Blabber…lol!

Thanks for this but it has many gaps that are cause more arrays within the flow leading to errors 😑😑

Hi Changing a title will trigger an update of the task name yes, but fetching the correct bucket name doesn't seem to work. Looks like it just iterates through the bucket names available and updates the excel with the current bucket and then ends at the last one. Anyone have solved this?

Hallo, where do I find "iterate"?

Hello, this method able to get data from MS Planner Label to update in MS Excel ? Appreciate your response thank you..

Thanks, thanks, thanks! After months of battling this exact issue I found the video and got it working! Only issue I have found is when I add a new task, it adds all the previous ones again- I'm guessing it's to do with the loop- any tips would be much appreciated?

Getting this error while updating the row. { "status": 409, "message": "Excel table already has a row with id 'FeqEbDQbWkCv2ju5KGsd4ZYANBt-'. clientRequestId: 03af3f27-6676-4b01-8a2e-00db746f892e", "error": { "message": "Excel table already has a row with id 'FeqEbDQbWkCv2ju5KGsd4ZYANBt-'." Can someone suggest ?

This worked for me; thank you! However, it appears to be creating duplicate line entries in the xls, and I don't understand the pattern. I let it run over the past hour, and it created three identical entries for one task, two of another task, and two for the same task but different TaskIDs. The other two tasks appear fine. Also, one of the runs ran for 6 mins for whatever reason (I hadn't made changes around that time), while all other runs before and after ran 40-50 seconds.

If user delete a task in planner, how do I set another condition?

You are not showing the Assign to the column. That one produces issues.

could it be possible to have an updated version? I also tried and it doesn't work

Hi there, the template on the power automate is different to the youtube tutorial can you please advise

For some reason I don't see the option for Iterate bucket.

Thank you for the video! I am trying to replicate this with Power Automate - how did you resolve the first error?

YOU'RE MY HERO. THANK YOU SO MUCH

Thanks for a really helpful video. I've just started using Power Automate to try and integrate Planner, Excel and Outlook at work. I'm still ironing out some of the bugs but I have managed to create a task in Planner from Excel (13:59). The basic workflow is a new email arrives in the inbox which adds a row to the Excel table from which a Planner task is created. I use the Message ID (which is horrific) as the Planner Title then once the task is created I update the Task with the Task ID and set that as the Task title as well. This is passed back to the Excel table as an update. I want an automatically generated reference in the Excel table to be the Task Title in Planner. The formula I've been using is =CONCAT("TE",G2) where G2 is the formula =TEXT(ROW()-1,"000") which outputs "TE001". The problem so far is Power Automate recognises this as a null value which causes an error but I think I just need to use "List rows present in a table" first. As you have a recurrence running, would it not be possible to set a condition if the Task ID is blank then create a task using details in the row and then update the Excel table with the Task ID? You may have to "List rows present in a Table" first.

How can I make sure the comments from planner get brought in?

I can't stand that pointer zoom on your screen. We only get to the see the characters for a half a second and not with the rest of the expressions. You need to slow down and make every large enough that we can read it. I had to pause and go back about 80 times. A write up in the description would be super helpful.

Brilliant! Brilliant! Brilliant!

Anyway to add "get user profile" into this solution to get Display Name of user that has task assigned to?

Hello, great content!! I can't connect the Priority of the task with my flow, do you have any tip for that? Thank you!

Hi, did anybody manage to get this flow to work? I tried many times but is not working. Thanks

Can you send your package (.zip) of this VDO to my email ? namphon.chailungka@gmail.com

Great video! I'm very new to the FLOW and planner world and my challenge at the moment is doing the exakt opposite of this video. In other words, update tasks in Planner from Excel. If anyone has a clue on how to do this i would really appreciate this. As of now, i have a flow that create Planner tasks from excel. But, I have not figured out how to update task details as a separate flow.

Flow is not pulling up "Iterate Bucket" as an operation option. Issue could be solved if MS allowed Planner to communicate across platforms better.

How can I change the format of the date and time of the fields to excel? I have tried formatDateTime(triggerBody()?['CreatedDateTime'], 'dd/MM/yyyy hh:mm:tt') but nothing changes

I have a problem in step 4 An error occurred in the execution of the template action "Value_buckets": the result of the evaluation of the expression "for each" "@items ('buckets')? ['Id']" is of type "String" . The result must be a valid array.

Did anyone get this to work because I didn't...

The zoom in hover circle is distracting AF and harder to see the video.

Can you export labels too? Microsoft going to increase number of labels significantly soon so would be useful to filter Excel by label to create reports.

Great! Is there any solution to export the "concluded by" information to Excel? Didnt't find.

Thank you so much... Just what i was looking for.. keep them videos coming..

It keeps skipping the condition length(body('List_rows_present_in_a_table')?['value']) for me. Why is that?

Hi Miguel I can't seem to find the function Iterate bucket in my selection. Is there an alternative ?

What Template did you use for this flow? I did not find it in the video or else I have missed it.

very useful!!!!! Thank you!