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…
Source link
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.
Array
Modern Workplace1 May 2024Using the new ‘Send a Microsoft Graph HTTP request’ action in Power Automate to send urgent messages in Microsoft Teams
Modern Workplace13 April 2024Power Pages and Cloud Flows – Validate user against Dataverse records based on Contact ID
Modern Workplace6 April 2024Download SharePoint library files in Power Pages with JavaScript and Cloud flows – Improved code using jQuery & option to open PDF file in a new tab
Modern Workplace13 March 2024Handle multiple N:N records associate and disassociate requests with JavaScript and Power Pages Web API
