Recently I was asked by a community member how to create a linked issue item (via LookUp field) using SharePoint list formatting. Via pure list formatting, it’s not possible to implement such functionality.
But we can use List Formatting to create a button that triggers a Power Automate flow and this flow creates a linked issue as below:
![](https://i0.wp.com/michelcarlo.com/wp-content/uploads/2023/09/formflow-1024x569.png?resize=838%2C466&ssl=1)
Check out how to implement this functionality in this post.
Create an Issues list
Create a new SharePoint list using the Issue Tracker template from the standard SharePoint list templates:
![](https://i0.wp.com/michelcarlo.com/wp-content/uploads/2023/09/Issue-Tracker-1024x626.png?resize=838%2C512&ssl=1)
![](https://i0.wp.com/michelcarlo.com/wp-content/uploads/2023/09/usetemplate-1024x646.png?resize=838%2C529&ssl=1)
Add a LookUp field in the issues list to link to the source list where you are linking the issue:
![](https://i0.wp.com/michelcarlo.com/wp-content/uploads/2023/09/lookup.png?resize=376%2C290&ssl=1)
![](https://i0.wp.com/michelcarlo.com/wp-content/uploads/2023/09/lookup2.png?resize=295%2C503&ssl=1)
Creating the Flow
Create the Flow using the ‘For a Selected Item’ SharePoint trigger.
Add as input parameters an ‘Issue Priority’ field as a Drop Down and add the equivalent values to what the Issues list has in the Priority field:
![](https://i0.wp.com/michelcarlo.com/wp-content/uploads/2023/09/Flow-01.png?resize=460%2C524&ssl=1)
Add also two other input fields, one to capture What was the issue, and another to…
Source link
More About This Author
![michelcarlo](https://i0.wp.com/365community.online/wp-content/uploads/2020/04/C6zQCIg6_400x400.jpg?resize=150%2C150&ssl=1)
-
SharePoint and Office 365 Consultant/Developer always trying to get the best from Microsoft stack (Microsoft 365/Azure/Power Platform and related stuff).
Living in Ireland since 2018, I had previously worked in Brazil as a consultant/developer for Office 365, SharePoint and related technologies for almost 10 years.
Array
Modern Workplace24 July 2024Power Pages Table Permissions: Configure permissions to see records from child Accounts
Modern Workplace15 July 2024Copy Dataverse contact phone numbers across different environments based on Contact e-mail address using Power Automate
Modern Workplace1 June 2024Get the current logged Power Pages user Contact ID via JavaScript and use it to create records assigned to the current user
Modern Workplace11 May 2024How to get the current Azure Devops iteration name for a project using Power Automate