User Profile
smaharms-wende
Copper Contributor
Joined 4 years ago
User Widgets
Recent Discussions
automate update of a sharepoint list column item based on lookup / in another sharepoint list
High everyone, Subject: updatea sharepoint list column item automatically with a lookup / filtered value of another sharepoint list. We use in a sharepoint site 2 lists (master | riskcat) to do riskmanagement. Within the master list, the process owner rates the process risk with 2 values, impact and probability. The field risk is a calculated column (impact x probability). master processrisk (char) impact (int1) probability (int1) rIsk (int) riskclass (char) The column riskclass is the brinbback colum of a additional second list called riskcat. riskcat (risk-categories) risk (int) riskclass (char) The column risk (INT) contains the risk values (1- 100 ) and the column riskclass contains the assigned class information. With the help of an additional lookup field risk1 (master list) the user will be able to get the riskclass information manually. We are searching for a automate solution. Trigger: If field value master.risk changes (create or update) Request: lookup/filter the list riskcat with the condition master.risk==riscat.risk => bringback riscat.riskclass and update column item master.riskclass. I hope power automate can help, but the GetItem (ID) is the wrong way. Any help is appreciated.Bulk Upload files and meta data from file share into sharepoint online doclib
Hi, We have a requirement to upload image files from fileserver shares into a document library. In addition we need to upload meta data e.g. (Title | Description | Productfamily....) into the corresponding columns of the document lbrary. We prefer to use PowerQuery to extract folder content, transform /add the additional meta data information.So far I haven't found a solution to upload files and meta data. Thank's for a feedback Best regards Stefan5.4KViews0likes3Comments
Groups
Recent Blog Articles
No content to show