Power automate excel to planner9/17/2023 20-22nd - Dublin Microsoft Power Platform Conference – Oct. This episode premiered live on our YouTube at 12pm PST on Thursday 15th June 2023. Video series available at Power Platform Community YouTube channel.Įuropean Power Platform conference – Jun. Use the hashtag #PowerPlatformConnects on social media for a chance to have your work featured on the show.Ġ0:00 Cold Open 00:25 Show Intro 01:02 Angeliki Patsiavou Interview 27:10 Blogs & Articles 42:45 Outro & BloopersĬheck out the blogs and articles featured in this week’s requested: Feel free to provide feedback on how we can make our community more inclusive and diverse. I'm not sure how the Excel workbook is involved, but I know for sure that your "Item Number" lookup column in the "Purchase part change list" is directly linked to the "PRTNUM_01" column in the list "Purchase part item list" as the source.Įpisode Fifteen of Power Platform Connections sees David Warner and Hugo Bernier talk to Microsoft Business Applications MVP, Angeliki Patsiavou, alongside the latest news and community blogs. When you get to the Site Contents page, find the other list titled "Purchase part item list" and this is where you will add new items so that they can be looked up in your "Purchase part change list" in the Item Number column. You find the Site Contents by clicking the gear icon like before and then selecting "Site Contents" which will take you to another page. The best way to search for the SharePoint list "Purchase Part Item List" will be through searching the 'Site Contents' of the current SharePoint site. You need to find the SharePoint list "Purchase Part Item List" and add any new items using the key column "PRTNUM_01" and they will be visible in your "Item Number" lookup column on your current SharePoint list "Purchase part change list". The "Item Number" lookup column in your SharePoint list "Purchase part change list" is using the column "PRTNUM_01" as a key column from the SharePoint list titled "Purchase Part Item List" as a source. The "Item Number" lookup column in your SharePoint list "Purchase part change list" does not come from an Excel workbook. Did MS change something that breaks this in a newly entered flow based on your instructions above? (MS has been known to break things without saying anything.Thank you for showing that screenshot. I’ve checked and verified my entries and wondered if you can provide any insight. xpath(xml(json(concat('’))), ‘/body/value/_assignments/userId/text()’) The xpath(…) expression will help you with that, it’ll give you all userId from the ‘List tasks’ output in an array. You must get all the users who have assigned any Planner task. The first step is similar to the html report in previous post. This post will show you how to create a mapping table between the userId and user name, and how to use it to create the export. Since you’re creating the Excel rows one by one, you must get the user names before adding a new row. At the same time there’s no html table where you could later replace the userId. If there’s more than 1 assignee, you can’t simply ‘Get user profile’. For example, when you export the tasks to an Excel file. But there’s another situation where you might need to translate the userId into user name. It can be used when the tasks have 1 assignee, or when you create an html table with the tasks. There’s already a blog post on how to display assigned users in a Planner task, but the post covers only two situations. “I’m stuck on exporting Planner tasks to Excel because some task are assigned to multiple users and Power Automate doesn’t store a nice list of names in a string!”
0 Comments
Leave a Reply.AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |