14 күн бұрын
21 күн бұрын
6 ай бұрын
6 ай бұрын
9 ай бұрын
10 ай бұрын
11 ай бұрын
Пікірлер
@avixx 10 сағат бұрын
Great video! You're a good teacher
@bi-ome 8 сағат бұрын
Thanks!! Love your photo 😸
@lucasdaels 19 сағат бұрын
Thanks Christine, this is what I needed!
@rawanmusa4399 19 сағат бұрын
This is exactly what I needed. Thank you!!!
@CHEDDScast 20 сағат бұрын
What a hero
@barttrudeau9237 21 сағат бұрын
Do you know if M365 E5 licenses give you access to Premium License?
@bi-ome 20 сағат бұрын
It does not, it’s separate. E5 just gives basic Planner. The cost isn’t astronomical, though, because only people creating projects need licenses - not assignees.
@barttrudeau9237 10 сағат бұрын
@@bi-ome thanks, that helps
@sammertalib8898 22 сағат бұрын
Thank you for this video, solved my problem exporting data to power bi. However I am experiencing an issue when changing the names of the flags as it is not updating in my output. For example, previously I called a flag colour label (cranberry )" engagement+ ready" which worked however when changing it to "engagement+" it doesn't update? Also is there a limit to the number of flags? I added a new label but it's not picking it up. Any help is much appreciated, thank you!
@bi-ome 20 сағат бұрын
When you change names of flags, you can update it but it’s a total pain. First you have to update it in the array if you used the names there, run the flow to update the file, then you refresh in the query editor (this is important) and have to update it in the JSON expansion step (select the columns to expand) and if you did a “remove other columns” step update that to make sure you’re not removing it there. Premium Planner handles the flag data a lot better, you don’t need to update anything at all because they’re all stored in a data table that you can just directly pull.
@TheMarketingPerson Күн бұрын
How long is a little while? I've been waiting about an hour nearly
@bi-ome 20 сағат бұрын
For the permission change? Maybe 15 minutes?
@TheMarketingPerson 11 сағат бұрын
@@bi-ome Thanks for the reply. I have no idea when it kicked in, but it was over 60 mins... few
@TheMarketingPerson 11 сағат бұрын
PS great tutorial
@matheusfariaseng Күн бұрын
i'm from Brazil, tank you so much for very valuable content
@bi-ome 20 сағат бұрын
Hello to you in Brazil! 🇧🇷
@pavel_stafeev Күн бұрын
Amazing video. Got everything I wanted to see in this video. Thanks!
@bi-ome 2 күн бұрын
You can VOTE for recurring tasks to be added to Premium Planner as a feature here if this is a feature you need: feedbackportal.microsoft.com/feedback/idea/50cefc0e-2d11-ef11-989b-6045bd841c15
@SumiteshKumar-w4f 2 күн бұрын
Hi, when i try to send email, it send emails to all the email address that i have used as per the steps. Generally it should go to 1 person at times if an item has been added or modified in SharePoint
@bi-ome 2 күн бұрын
This flow is about using Power BI with Power Automate to send emails, if your source is a SharePoint list you probably want to just use the SharePoint triggers instead and not go through the steps in this video. But there is a for-each loop here that is looping over the recipients and sending an email per, so if yours isn't looping properly perhaps there is an issue with either the loop or the thing you're looping over? If your recipients are in a string instead of an array that could cause this behavior.
@SumiteshKumar-w4f 2 күн бұрын
@@bi-ome so i have Power BI and a SharePoint point, i am using a Power App (canvas) to create an item in SharePoint. So whenever there is an update in SharePoint list i need an update, i am using a trigger " The flow is as below. When an item is created (SP)>Run a query against dataset(PBI)>ParseJSON>InitializeVariable>AppendArrayVariable>Compose>SendEmail So whenever the flow runs it send email to all the entries instead of the new/modified entry. It send 100 of emails to everyone whose email id is there in the list, i want the flow to send email to just the new entry.
@sep5439 3 күн бұрын
That's a list not a form.
@bi-ome 2 күн бұрын
Lists have a form, that's how the data is entered when a new item is created. Forms are a way for users to enter data into fields in a table. Not sure what your definition of form is. :)
@renitharamjattan4957 3 күн бұрын
Very well presented. Thank you
@lucypage4559 4 күн бұрын
I’m having trouble getting the tick to publish onto the online platform. In the app I can see subtasks with the box un ticked and the completed tasks ticked, but when I publish it, it only shows them all as boxes not ticks. I changed the unichar codes and still get the same, it doesn’t want to show the ticks for some reason!
@bi-ome 3 күн бұрын
That's strange! Try a different character maybe, just to troubleshoot? There's filled squares and circles and various other options.
@davidwalker4041 6 күн бұрын
Great video! Thank you! I had set up a bunch of Project Templates for users to copy with the goal of using a couple custom fields for metric tracking important to my company. Is there a way to pull in those custom fields?
@bi-ome 6 күн бұрын
Not yet, but I totally agree that would be useful - I made a thread to vote on it here - if it gets enough votes they'll probably add it! feedbackportal.microsoft.com/feedback/idea/f130aded-aaf3-ee11-a73d-6045bd7e894e
@Craeson1 6 күн бұрын
Took me three days of truoble-shooting until i found your video and got the solution I was looking for. You are a life-saver Christine ❤❤
@MrCreativeoccasions 6 күн бұрын
Awesome Video. Help. It only works for premium plans. Is there a way i can also pull tasks from basics plans?
@bi-ome 6 күн бұрын
Yes, but the data doesn't live in the same place and the process for getting it is a bit involved. I would only recommended it for pulling your own data or your team's data, not for an entire organization - you can't connect directly to it. I did a video on how to get the data with Power Automate here (this one is a single plan, there's another for all or a list in the channel playlist): kzbin.info/www/bejne/p2jFnIqmi8itsJI
@gabypetre8900 7 күн бұрын
Hi Christine, the video was very helpful, I really appreciate the work you put into making those videos! One quick question, how can I also get the priority of the tasks from planner (urgent, important, medium, low) into the json file?
@bi-ome 7 күн бұрын
Thanks! Either part 2 or part 3 has how to get the priorities (I thiiink part 2?) - they're not in the UI, but you can get them with an expression... they come through as numbers that you have to re-map to the text labels. 😅
@gabypetre8900 7 күн бұрын
@@bi-ome alright, i will try that! Thanks.
@alisongunnels6240 8 күн бұрын
You are a lifesaver for those of us using the Teams Kanban boards, which are backended by Planner. I have been making incremental progress on automating reports for months. but now I can get exactly what I need out of planner. Thank you!
@rwfrench66GenX 8 күн бұрын
Thank you for this detailed, thorough video! I have this set up and it’s sending multiple copies of some emails and not forwarding others. This shared inbox is for the AP department and some suppliers send invoices instead of sending the invoices to the email address for our online OCR. I also added a step where after it forwards the email it moved it to a subfolder. It moves the emails to the subfolder but if there are 30 invoices it sends 20 of them 4 - 5 times each. Any suggestions on a fix?
@bi-ome 7 күн бұрын
Are you looping on something when you send the email? It shouldn't be sending multiple copies from the get-go. I'm wondering if perhaps the moving to a subfolder action is creating a copy of the message when it moves and that's where the duplication is happening. I used the send-as for years and didn't have issues with duplicates, but I wasn't trying to move the messages. Have you tried setting a forwarding rule to move in Exchange instead of using Power Automate?
@rwfrench66GenX 7 күн бұрын
@@bi-omeHello, thank you for your quick response. I tried this two different ways. The first way as a scheduled flow where it had a recurring setting for every 10 minutes to check the shared mailbox. That flow still had the move to subfolder setting after it was forwarded figuring when it checked 10 minutes later it would forward any new emails. When that sent multiple emails I thought the recurring setting might be the problem so I deleted the flow and used the describe and design feature and it doesn’t have a recurring setting but now it still sends multiple copies of some emails but it doesn’t forward all emails but it does move all emails to the subfolder. Based on your reply I’m going to build two flows. The first will move the emails to the subfolder and the second will forward the email from the subfolder. Hopefully 🤞🏽 that takes care of it. Thanks again!
@bi-ome 7 күн бұрын
@@rwfrench66GenX Sure! You don't even necessarily need to use Power Automate to do the forwarding and moving, what I mean is you could set a rule on the mailbox in Exchange settings. That way it doesn't have to check for the messages, it just sends it along when the subject or whatever matches a pattern.
@rwfrench66GenX 7 күн бұрын
@@bi-omeoh, I’m sorry I misunderstood. Great idea! I’ll give that a shot! Thank you again! 😊
@KariTTow95 8 күн бұрын
OMG!!! I can't belive it is so easy, I was looking for a solution with power automate, when the solution was here. Thank you so much!!!
@bi-ome 8 күн бұрын
I'm always in favor of easy solutions! 😅
@DelrumoConsumo 8 күн бұрын
Is there a way to see "New Fields" entries from MS Planner Premium in PowerBi? THIS WOULD BE A GAME CHANGER!!!
@bi-ome 8 күн бұрын
You mean the columns you add in Planner? I COMPLETELY AGREE but no not yet! I actually made a thread in the Ideas forum a few months back please vote on it if you'd like to see it! feedbackportal.microsoft.com/feedback/idea/f130aded-aaf3-ee11-a73d-6045bd7e894e
@ClaireGillespie-b2s 8 күн бұрын
I have tried the Workflow. It worked when I created it for a specific plan but when amended for all plans I get the following error. Are you able to advise how I can resolve please?: Flow save failed with code 'InvalidTemplate' and message 'The template validation failed: 'The inputs of template action 'For_each_Bucket' at line '1 and column '3667' cannot reference action 'List_buckets'. The action 'List_buckets' is nested in a foreach scope of multiple levels. Referencing repetition actions from outside the scope is supported only when there are no multiple levels of nesting.'.'.
@bi-ome 8 күн бұрын
It sounds like perhaps things didn't get moved to the right level, or perhaps there's an extra loop in there?
@pearltechnologyllc674 8 күн бұрын
Using the following flow: 1. Get Files from Folder for the PDF, 2. Launching the excel sheet, 3. Saving the excel sheet, 4. Extracting Tables from PDF. The PDf essentially has three tables two towards the top and a third in the middle. Power Automate extracts the three different tables, but i need the top two from each page removed and then the middle bottom one to extract line by line from 30 pdf pages. The top two tables all start with the same words, so those should be easy to ignore. Then the table I want has the same header and each line is number from 1, 2, 3, etc, all the way down the pages of PDF
@bi-ome 8 күн бұрын
If you're trying to extract full very-regular tables, you might try Power Query (it can use files and folders of PDFs as a source) or one of the AI OCR tools. They're better for more structured data--
@pearltechnologyllc674 8 күн бұрын
@@bi-ome thanks, the data is pretty structured inside the PDF. The problem is that the invoice puts a "header" at the top with the invoice information before the lines items. However, it's not a true Adobe Header that I can remove.
@bi-ome 8 күн бұрын
@@pearltechnologyllc674 I'm not sure what the issue with having a header is - if you try Power Query or an AI tool, it should let you recognize it as a header, or if it thinks its a row (Power Query does this sometimes), you can remove the top 1 row to get rid of it usually. You get a lot of transformation options with Power Query too, to split out account IDs/fill down the rows/that sort of thing-- the technique in this video is more about how to pull out a few specific single text strings, it's not really meant for extracting full tables.
@oldersaggypants1261 8 күн бұрын
Great Video! is there any way to filter so that only users created in a dynamic date range are returned? ex: users created this week?
@lingchen-np9mz 8 күн бұрын
I have been waiting for this! Thank you.
@bi-ome 8 күн бұрын
Took me a while, I'm easily distracted 😄
@tahirif1138 9 күн бұрын
Your videos are great but a SUGGESTION. IF YOU can please make them clear and not blur that would be helpful
@bi-ome 8 күн бұрын
Yeah, this was one of the first videos I ever made - the ones created in the last 6 months should all be more clear. I was surprised this one did as well as it has given the recording quality. 😅 If you see any more recent videos that are unclear, let me know!
@akinadekehindeakintunde7508 9 күн бұрын
Came across this video from your comment on Reddit. It was indeed helpful. I am following you right away and I hope to get more lovely contents from you
@2nhii-s6n 9 күн бұрын
Thank you! Much more helpful than videos that are way too long!
@CarolineEcholocity 9 күн бұрын
Thank you, I have spent so much time trying to figure these pieces out! Your first chart of Planner basic vs Planner Premuim data is GOLD
@bi-ome 9 күн бұрын
Thanks!! I feel like it may have been more straightforward if they just considered each product to be a separate license, but for some reason parts of both are packaged together - it makes it really hard to talk about it coherently without resorting to "the product formerly known as...". 😅
@CarolineEcholocity 9 күн бұрын
@@bi-ome Yes, absolutely. I feel like I have to explain the whole history of Planner vs Project for the Web vs New Planner to "explain" where the features / licensing models are coming from. I just finished the video and followed all your steps - really helpful and answered so many of my questions!!
@bi-ome 9 күн бұрын
BUCKET SORT - after publishing this, it dawned on me that you might want to grab a field or two from the buckets table to sort the buckets on the order they appear in Planner. You can get this directly in tasks by expanding msdyn_projectbucket(msdyn_projectbucket) and the msdyn_displayorder field there, similar to how we pulled in the goal info. TASKS WITH CHILDREN - we do a calculation to get this in the video, but it turns out msdyn_summary true/false also identifies the same thing, so you can just use this vs PATH() hijinks. I didn't realize that was what this was about until after I compared the two columns. 😅 My guess is this should probably be used as a filter on measurement efforts to avoid double-summing effort between the parents and children e.g. Sum Effort (assignable only) = CALCULATE([Sum Effort], KEEPFILTERS(Tasks[Summary Task (has children)?] = FALSE())) Here's links to the things mentioned in the video! Excel file with color mappings: christine-payton.com/microsoft-planner-project-for-the-web-color-label-values/ How to get Planner data for NON-Premium Planner: kzbin.info/www/bejne/Z4bJqXiKltGVb6c How to migrate tasks and plans to premium Planner: - How to migrate plans and tasks to Premium Planner: kzbin.info/www/bejne/pZ-4kmhvrZZ9Y6c Want to be able to pull custom column data too? VOTE on it here: feedbackportal.microsoft.com/feedback/idea/f130aded-aaf3-ee11-a73d-6045bd7e894e
@mrspexxx3583 9 күн бұрын
Great solution, thank you! However I stumbled into kind of a big problem: I dragged the measure into the matrix values separately, adjusted the coditional formatting and went on to remove the measure. Turns out it just does not allow me to remove it anymore, even after deleting the dynamic formatting again. Has anyone experienced something similar or has an idea how to fix it?
@bi-ome 9 күн бұрын
It should let you remove it... is there not an "x" over the field in the well to click? Not sure if you're using the on-visual UI or not, that one is set up a little differently.
@NathanielUlrichBos 10 күн бұрын
Than you for the wonderful video. Any idea why my json file outputs “[list]” when I connect it to power bi?
@bi-ome 10 күн бұрын
If you’re not able to expand it properly in the query editor, it’s usually because the JSON isn’t structured right - if you miss a comma, have an extra comma, miss a double quote etc those can make the expansion not function.
@NathanielUlrichBos 9 күн бұрын
@@bi-ome Thank you. Worked like a charm!
@cfrith8963 10 күн бұрын
I follow each step, and every time I hit save, it switches back to "manual" from "for a selected file".
@bi-ome 10 күн бұрын
Are you in the modern UI? If yes, try toggling modern off in the toolbar. It can mess with all kinds of things, it’s a bit wonky still.
@leegarrett1908 10 күн бұрын
Fantastic gonna try this tomorrow:) great work! Will this work if some values are null?
@bi-ome 10 күн бұрын
Cool! It depends on what particular thing is null - if you mean something in the text of the content you're displaying, it just essentially skips putting in a value for the nulls. E.g. if you make something that counts tasks saying "you have xyz tasks", and a person has no tasks, by default it'll say "you have tasks" - there's just nothing where the number would be and it's awkward but doesn't cause the whole thing to fail. You can change that behavior by putting the logic you want for nulls into your measure that the content is drawing on - some people use +0 to force nulls to zero, or use an if statement and say if it's null, return 0 instead in the count measure.
@sholder9933 11 күн бұрын
It is so hard to find Power BI -> Power Automate content. There is so much potential! Your videos added to my knowledge, but it’s not exactly what I’m searching for. Where did you go to learn this stuff?
@bi-ome 11 күн бұрын
@@sholder9933 What are you looking for? Honestly I don’t know of a good learning source for this particular category of thing, that’s why I’m making these. Most of what I know about it I learned through trial and error. 😅
@carlottafabris225 12 күн бұрын
Hi! Very helpful video, I stumbled on it because I am searching a solution for my problem. I have a report with many pages and various maps. I would like to be able to select a hexbin on a map and then apply this selection to every page of the report. I am trying with drillthrough but it is not really what I need. Any idea on how I could achieve this? Thanks!
@bi-ome 12 күн бұрын
Thanks! I don’t think there’s a good way to do what you’re asking. The best solution I can think of would be to just put the content on a single page instead of multiple - you could add bookmark “tabs” or have it scroll down to show the rest instead of going into other pages. Otherwise synced slicers or the filter pane, but I can’t think of a way to do it via a map visual without drill.
@carlottafabris225 12 күн бұрын
@@bi-ome Thank a lot! I hoped there was a way maybe with Power Automate to get the selection of the user in an Excel and then maybe read this Excel back to filter the rest of the model. Put everything on one page could be the solution but I would need to add a sort of page navigation. I already tried with synced slicers but the users would need to select from a list of technical values (hexbins) and this is not really ideal. I tried putting the city as a slicer and this could be a possible solution. I will try with the one page idea, thanks!
@bi-ome 12 күн бұрын
@@carlottafabris225 You could, but you’d have to store it somewhere and direct query (Dataverse or SQL - you can’t direct query Excel) it I think - like get the latest entry in the table for the given user and use that in the slicer. 7/10 jank level haha. I’m not sure that would necessarily work either, they might need to refresh the page or something iirc…
@GetGriddyWithIt 12 күн бұрын
Thank you so much! That was so well communicated 👏❤
@novicesongcovers 12 күн бұрын
I am having issue on the conditional formatting for taskDue and TaskStatus, I can only see "Count of" instead of "First" value as option can you help me please
@bi-ome 10 күн бұрын
Make sure you have the right field selected in the conditional formatting menu - it doesn't always default to the field that you are accessing via the menu. It should always give you different summarization options in the dropdown on the right unless you have a measure or calculated column selected instead.
@NunoFerreira-w5m 13 күн бұрын
When adding milestones on this Gantt the bar completely disappear :( Anyone knows how to overcome that? I tested several other Gantt chart available but the only one that let's me properly configure it is a paid version.
@bi-ome 13 күн бұрын
I had issues with milestones too. Here's another Gannt option that is free that DOES have milestones and dependencies - it's a bit more assembly required, but it's quite good: kzbin.info/www/bejne/a6iUpZeleNushq8
@NunoFerreira-w5m 11 күн бұрын
@@bi-ome This one you shared is great! Although I might have explained myself wrongly. For example, I have a start/end dates which need to be used for the bar, however I also want to see a mark on the "forecasted start date" and "request date", so that our response time and the amount of short notice requests to be easily understood. Anything for this? :)
@bi-ome 10 күн бұрын
@@NunoFerreira-w5m I would just drop it into the tooltip to show it on hover. I honestly don't know of a Gantt that will let you add extra fields to the display outside of the tooltips without coding (you could add code to the Bacci Deneb template to do it)... best I can think of is to maybe concatenate it into the existing text that's shown otherwise.
@aekdbej24 13 күн бұрын
Your videos are truly appreciated. Until now, I have been unable to find a resource that navigates through a project/task/solution so clearly, step by step. I have one problem I can't seem to resolve here and unable to find a clear answer online... upon loading the downloaded JSON file from Sharepoint to PowerBI, I get an error that "We have found an unexpected character in the JSON input." Any advice on how to move past this? Thank you!
@bi-ome 13 күн бұрын
Thanks!! You probably have a typo or missed/extra comma/quotation somewhere in one of the arrays in Power Automate. That will invalidate the JSON and it won’t be able to expand-
@crystalalcott8285 14 күн бұрын
Thank you Christine! I just used this to create a fancy email for supervisors about employees with upcoming service anniversaries that our HR department has been doing manually for ages. They are very happy thank you!
@bi-ome 14 күн бұрын
aw that's so great! GJ!
@rudidekok 14 күн бұрын
This is some fantastic underrated content, i gladly subbed to this, been following this guide, i do have on question, regarding this is there a way to pull all the notes from planner aswell, i'm trying to find a way to pull all the notes places under a task to have them saved under a single spot for that entire task so humans can find the notes in one spot
@bi-ome 14 күн бұрын
Thanks!! The notes field is there, it's just called "description" on the back-end outputs, so I called them "description" in the array. :x
@andrewchavira6729 14 күн бұрын
Hi Christine, great video! In the Tasks query, each tasks is duplicated 6 times. When I go to the model view I can’t edit the relationships between the 4 queries. Do you know how to fix that?
@bi-ome 14 күн бұрын
Thanks! Are the tasks duplicated in the JSON, or just in Power BI? If it's in the JSON, then there is an issue with your loops/arrays in Power Automate. If it's only in Power BI, then you expanded one of the multivalue fields there instead of in its own table (e.g. Assignees - that's why we duplicate the query and expand those separately from tasks). You should be able to edit the relationships, if they got auto-created you can delete them and start over - there's a button to get to a real UI for it in the toolbar. It won't let you have more than one active relationship between two tables at the same time, which if you're trying to add a relationship and one already exists might make it appear like it's not letting you edit?
@andrewchavira6729 13 күн бұрын
@@bi-ome I went back and checked my flow, it looks like I made a few errors, which caused the queries to duplicate. I fixed it now, and there are no duplicates. Thank you!
@EllieCarter5225 15 күн бұрын
Thank you so much for the video. Maybe it is me I tried to see but it was so far away.
@bi-ome 15 күн бұрын
I know, sorry! I can't fix it after the fact, perhaps someday I will re-record. I have started using UI zoom on the newer videos so that they are easier to read. I haven't been doing this very long, still learning ^^
@AC-lt7xf 16 күн бұрын
Thank you for making this video! Is it possible to prevent the phases being ordered by earliest task start date? For my teams use, we just want phases to be in the order they are in our spreadsheet. Thank you again! :)
@bi-ome 16 күн бұрын
Yeah, I went in and looked at the code - if you search on the word "sort" in the JSON, there's two sorts... one for the tasks and one for the groupings. You want the second one in the code - they look exactly the same so make sure you edit the right one (if it says taskSort you're in the wrong place). Just change the word "start" in the code to the field you want to sort by. It has to be something data-based. Here's the code to look for: { "type": "window", "sort": { "field": "start", "order": "ascending" },
@Grant76Wylie 17 күн бұрын
When I send from Shared Mailbox, the sent email still appears in my Personal email Sent folder?
@bi-ome 17 күн бұрын
Yes, this is expected - if you want to change this behavior, there's a thread on it here: www.reddit.com/r/Office365/comments/1c7pumf/mails_sent_from_shared_mailbox_are_appearing_in/
@aurelianhongu4974 11 күн бұрын
I have same question/issue, emails are sent from shared mailbox but I have a copy in my individual mailbox Sent items... can this be changed to have sent mails stored in shared mailbox Sent Items only?
@bi-ome 10 күн бұрын
@@aurelianhongu4974 Have you seen this thread? There's some options here, there's one that mentions a checkbox toggle you can configure in Exchange: www.reddit.com/r/Office365/comments/1c7pumf/mails_sent_from_shared_mailbox_are_appearing_in/
@pumbaaable 18 күн бұрын
Hi Christine, my flow works well but is not updating the json file I set whenever I test it 😢😢 would you have any idea how to troubleshoot this?
@pumbaaable 17 күн бұрын
It says its successful, but it does not create the file. It was working well last week but i dont know what happened why its not creating the file anymore
@bi-ome 17 күн бұрын
Where are you noticing that it's not overwriting? Is the last-modified date in SharePoint not updating, or is it stale in PBI? If you check the flow history, it should show you exactly what it's doing for each step, so you can make sure that the step that composes the data array actually has updated data in it, and check that that is going into the file, and check where the file is going. Make sure you have "chunking" enabled for the create file, that's what allows the overwrite of the file. Also make sure you've refreshed it in Power BI desktop if that's where you're using it right now, both the query editor and the desktop app won't refresh unless you use the associated refresh button (the query editor loves to cache the data so it's normal for it to look stale unless you refresh there too). Once you publish you can schedule refresh. Sorry if this is old news, it's hard to tell what people's experience level is through comments. :)
@pumbaaable 16 күн бұрын
@@bi-ome i have enabled "chunking" for the create function, but json file is not being updated everytime i manually run the flow or when the flow is scheduled to run. i tried to revise the folder location but its not creating a file now for some reason 🥲🥲
@bi-ome 16 күн бұрын
@@pumbaaable Does that step have an output when you look at the flow history? It should show you exactly what it's doing there, if anything.
@pumbaaable 16 күн бұрын
@@bi-ome Yes. I have compared the outputs from the dates it successfully updated the file and when it did not. Seems the same to me. One guess I have is that i have exceeded the limit for a free license 😅 so its not creating the output file anymore. I have noticed also that the output of my file contains duplicates of the same task 13 times 😅 is this normal? I think reducing it to no duplicates can potentially help in not exceeding the limit. Thanks!
@DariaOrlea 18 күн бұрын
Hello Christine, thank you for all your helpful tutorials. I have a question, how can I get the name of the person who completed the task? Especially when the task is assigned to multiple persons I want to see in the power bi report who completed the task. Thank you!
@bi-ome 17 күн бұрын
That info isn't in the outputs for the list tasks or get task details steps, it only has created by, assigned by, and assigned-to user IDs. I don't see it in the API documentation, either, so I don't think it's accessible to us.
@DariaOrlea 8 күн бұрын
@@bi-ome I saw in one of your videos that you posted that the value for 'completed by user display name' appeared, but it was filled with null everywhere, and I was thinking that there might still be a possibility. This was the video kzbin.info/www/bejne/iJPGo32YrNR8hdk
@bi-ome 7 күн бұрын
@@DariaOrlea Oh you know what, you're right - this is another one of those that doesn't show up at all in the UI. I was doing a search on outputs and didn't see it, I think because the plan I was looking at didn't have any completed tasks? I was able to get the completed-by user ID with the expression items('Apply_to_each')?['completedBy']?['user']?['id'] - you can feed that to the get user profile to get their name/email. Their display name seems to always be null.
@lucavlad5669 3 күн бұрын
@@bi-ome Could you send a picture of the changes you've made, since i'm also interested in the 'completed by' part for a report, so i can keep track? I'm still new to Power Automate and didn’t quite understand what to modify
@bi-ome 2 күн бұрын
@@lucavlad5669 I haven't made a flow modification for it, I will put it on my list to do. I just fiddled with a compose action until I got the ID reference right. It'd be handled similar to the assignees, but without a loop since there's only one value.