Set the desired values for the "riskclass" column based on the retrieved item from the riskcat list.ID: Select the ID of the current item from the trigger.Site Address: Select the SharePoint site where the master list is located.Configure the action with the following settings:
AUTOMIZE IT UPDATE
Within the "If true" branch of the condition, add an "Update item" action to update the master list item.
Choose the dynamic content for the "Get items" action's output, for example, body('Get_items')?.Configure the condition with the following condition: Add a "Condition" action to check if any items were retrieved from the riskcat list.Filter Query: Enter the filter query to match the risk value from the master list.Site Address: Select the SharePoint site where the riskcat list is located.Add a "Get items" action to retrieve the corresponding item from the riskcat list.For example, you can use the "When an item is created or modified" trigger to monitor changes in the master list. Choose a trigger that suits your needs.Open Power Automate and create a new flow.I hope power automate can help, but the GetItem (ID) is the wrong way.Īny help is automate the update of a SharePoint list column item based on a lookup or filtered value from another SharePoint list, you can use Power Automate (previously known as Microsoft Flow). Request: lookup/filter the list riskcat with the condition master.risk=riscat.risk => bringback riscat.riskclass and update column item master.riskclass. Trigger: If field value master.risk changes (create or update) We are searching for a automate solution. With the help of an additional lookup field risk1 (master list) the user will be able to get the riskclass information manually. The column risk (INT) contains the risk values (1- 100 ) and the column riskclass contains the assigned class information.
The column riskclass is the brinbback colum of a additional second list called riskcat. The field risk is a calculated column (impact x probability). Within the master list, the process owner rates the process risk with 2 values, impact and probability. We use in a sharepoint site 2 lists (master | riskcat) to do riskmanagement. It does not store any personal data.Subject: update a sharepoint list column item automatically with a lookup / filtered value of another sharepoint list. The cookie is set by the GDPR Cookie Consent plugin and is used to store whether or not user has consented to the use of cookies. The cookie is used to store the user consent for the cookies in the category "Performance". This cookie is set by GDPR Cookie Consent plugin. The cookies is used to store the user consent for the cookies in the category "Necessary". The cookie is used to store the user consent for the cookies in the category "Other. The cookie is set by GDPR cookie consent to record the user consent for the cookies in the category "Functional". The cookie is used to store the user consent for the cookies in the category "Analytics". These cookies ensure basic functionalities and security features of the website, anonymously. Necessary cookies are absolutely essential for the website to function properly.
0 kommentar(er)
