User Profile
kbzaz
Copper Contributor
Joined Jun 27, 2023
User Widgets
Recent Discussions
Default document library form does not include Description
Referring to SharePoint 365 (SharePoint Online). When selecting to edit all details of any document library item - in any site - Only Name and Title is available. Having the multi-line Description available for editing would be extremely useful. I am hoping to update the default form and not have a custom PowerApps form - not for this! Not for just including Description for all doc library items. What are the steps? Thanks, K.623Views0likes1Commentuse json formatting to set column value, txtcontent, from filter lookup
Hi ... In the json formatting, how do you set txtContent to the result of a "filtered lookup" that is in the json formatting? I am guessing that it is possible to return a lookup in the json formatting, yes? For example ... Current List has a column with a code value. That code value is a column in a source list. The source list also has a name column that contains the value to return to the Current List. All assuming that, fetching the name via the code value "link" and setting txtcontent to that name returned can all be done with json formatting - correct? Or ........ is better list planning needed? Thx for your patience. Kevin902Views0likes0CommentsRe: multiple lookup lists
I got it!!!!! Thx to caring ppl that share ... and ... sharing in almost correct words ... Two URsL helped: .1 LookUp from another list dependent on values on another cell - Microsoft Community Hub and the solution provided for post 1: .2 https://learn.microsoft.com/en-us/microsoft-365/community/working-with-cascading-lists-in-sharepoint-and-powerapps now to apply the "learning" to this specific task .... please dont delete this thread ... I plan to add the resulting list view / form2.1KViews0likes0Commentsmultiple lookup lists
Hi, I am not sure how to complete the list column lookups in this site. Probably need to redo the lists. Or .... the solution is probably to use a SharePoint Form? Here we go.... Here's the list for the end user, Drawing List: Dwg Number Category Code Category Name Dwg Type Name Dwg Type Code 9x1axz1 02 Survey & Cadastral Key Plan S Dwg Number is a Title column, value entered by the user Category Code and Name are 2 columns resulting from user selected lookup here are the first few columns in the Category List (there are actually 70): Category Name Category Code General 01 Survey & Cadastral 02 Roads 03 It's the final 2 columns I am struggling to figure out. 2 more lists Drawing Type List (example rows): Dwg Type Code General Plan C Detail D Long Section L Key Plan S and the relationship list, providing available drawing types per Category using only the Code values in columns named Dwg-Type-By-Category (example inly): Category Code Dwg Type Code 01 C 01 D 02 C 02 S 03 L 03 S I am hoping that when a user creates a new Drawing in the Drawing List, they provide the value for the drawing number, then they select the applicable category. The lookup provides category name and code. Then the hard part that I cannot figure out, hence this post. Need a lookup that will filter only the applicable dwg types using the category code AND provide a list of drawing type NAMES. That's lookup in the relationship list and lookup in the dwg type list to provide the dwg type names to the user. In the example drawing list, the lookup listed ... General Plan (C) and Key Plan (s) for user selection following user selection of 02 (Survey and Cadastral) category. I hope this makes sense. Thanks for reading and thx for your patience. Kevin.2.4KViews0likes1Comment
Recent Blog Articles
No content to show