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:
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:
Add a LookUp field in the issues list to link to the source list where you are linking the issue:
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:
Add also two other input fields, one to capture What was the issue, and another to…
More About This Author
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.
- Modern Workplace9 September 2023Using SharePoint list formatting and Power Automate to create linked items (via LookUp field) in a related list
- Modern Workplace1 September 2023Using the HTTP with Azure AD connector in Power Automate to create Planner Plans and add them as Teams tabs
- Modern Workplace26 August 2023Create an Issue Tracker App using Power Apps Copilot (Preview)