SharePoint Online List Webpart Views Ignored (Team site Classic Experience)
Can anyone confirm that none of a list's views can be applied to it inserted in to a page as a web part? The Web Part Properties section gives the following message if anything other than All Items is selected for Selected View: Cannot save all of the property settings for this Web Part. Cannot complete this action. Please try again. I thought the issue might be with my custom list, so I created a new list using the Recipe Tracker template. I made no additions, changes, or edits to the list content or definition. I created a new Web Part page and inserted the Recipe Tracker Web Part. The behaviour is the same. Steps to reproduce: Go to https://<yoursite>.sharepoint.com//_layouts/15/viewlsts.aspx Click on + New Click on List Scroll down and click on Recipe tracker in the "Templates" section under the "From Microsoft" tab. Click on Use template Click on Create Go to https://<yoursite>.sharepoint.com/SitePages/Forms/AllPages.aspx Click on + New Click on Web Part Page Type in a name for the page in the "Name:" text box. Select Full Page, Vertical in the "Choose a Layout Template:" list. N.B. the selection here did not seem to make any difference to the outcome. Select Site Pages in the "Document Library" drop-down. N.B. the selection here did not seem to make any difference to the outcome. Click on Create Click on Add a Web Part Click on the right-facing arrow until you see Recipe tracker in the "Parts" list. Click on Recipe tracker Click on Add Select the Recipe tracker web part Click on Web Part tab at the top of the ribbon Click on Web Part Properties in the "Properties" section of the ribbon Select Recipe gallery from the "Selected View" drop-down in the "List Views" section on the right-hand side of the page Click on OK Receive error message, and the view has not changed.
New Item Form View
While I was trying to edit the columns and information on a list, I must have clicked on something, but now I am not getting the same format whenever I try to "add a new item" on the list. It opens on sharepoint vice a pop-up window. Does anybody know how to revert back to the original form format? Below are screenshots of how it used to look (top) and how it is now (bottom). I tried advanced settings and switching from new and classic view already and it stills look like the bottom picture. Thank you!!
View is taking more time and consuming 100% cpu utilization
We are using views on tables having huge records to display some information in our application but it is consuming 100% CPU utilization and taking more time to process the records. SELECT COUNT(*) FROM FRA_ITEM_FIELD_DEF--44 SELECT COUNT(*) FROM FRA_STAT_ITEM--59635520(59M) SELECT COUNT(*) FROM FRA_STAT_FIELD--536719680(536M) Available Indexes: FRA_STAT_ITEM: CREATE UNIQUE INDEX FRA_STITM_U1 ON FRA_STAT_ITEM (ID_ORIGINAL,ITEM_TYPE,SEQUENCE_NO) GO CREATE INDEX FRA_STITM_U2 ON FRA_STAT_ITEM (REFERENCE) GO FRA_STAT_FIELD: CREATE INDEX FRA_STFLD_OPT1 ON FRA_STAT_FIELD (ID_STAT_ITEM,ID_FIELD_DEF,TEXT_VALUE,DATETIME_VALUE,NUMBER_VALUE,DECIMAL_VALUE) GO FRA_STAT_FIELD: CREATE INDEX FRA_STFLD_OPT2 ON FRA_STAT_FIELD (ID_FIELD_DEF) INCLUDE (ID_STAT_ITEM,DATETIME_VALUE) GO CREATE INDEX FRA_STFLD_OPT3 ON FRA_STAT_FIELD (ID_FIELD_DEF) INCLUDE (ID_STAT_ITEM,TEXT_VALUE) GO Reported View: CREATE OR ALTER VIEW FRAUD_ALERT_STAT_HIT_VIEW AS SELECT DISTINCT STAT.ID AS ID, STAT.COMPANY AS COMPANY, STAT.TEXT_VALUE AS ACCOUNT, STAT.ITEM_TYPE AS FRAUD_ITEM_TYPE, STAT.DATETIME_VALUE AS VALUE_DATE, STAT.CREATION_TIME AS CREATION_TIME, STAT.PAYLOAD AS PAYLOAD, STAT.REFERENCE AS REFERENCE, STAT.SEQUENCE_NO AS SEQUENCE_NO, STAT.ID_MANDATOR AS ID_MANDATOR, STAT.ALERTED AS ALERTED, STAT.STATUS AS STATUS FROM ( SELECT DISTINCT FSI.ID, FSI.ITEM_TYPE, FSI1.DATETIME_VALUE, FSI2.TEXT_VALUE, FSI.COMPANY, FSI.CREATION_TIME, FSI.PAYLOAD, FSI.REFERENCE, FSI.SEQUENCE_NO, FSI.ID_MANDATOR, FSI.ALERTED, FSI.STATUS FROM FRA_STAT_ITEM FSI CROSS JOIN FRA_STAT_FIELD FSI1 CROSS JOIN FRA_STAT_FIELD FSI2 WHERE FSI1.ID_STAT_ITEM=FSI.ID AND FSI1.ID_FIELD_DEF IN (SELECT ID FROM FRA_ITEM_FIELD_DEF WHERE MAPPING='executionDate') AND FSI2.ID_STAT_ITEM=FSI.ID AND FSI2.ID_FIELD_DEF IN (SELECT ID FROM FRA_ITEM_FIELD_DEF WHERE MAPPING='debitAccount') UNION SELECT DISTINCT FSI.ID, FSI.ITEM_TYPE, FSI1.DATETIME_VALUE, FSI3.TEXT_VALUE, FSI.COMPANY, FSI.CREATION_TIME, FSI.PAYLOAD, FSI.REFERENCE, FSI.SEQUENCE_NO, FSI.ID_MANDATOR, FSI.ALERTED, FSI.STATUS FROM FRA_STAT_ITEM FSI CROSS JOIN FRA_STAT_FIELD FSI1 CROSS JOIN FRA_STAT_FIELD FSI3 WHERE FSI1.ID_STAT_ITEM=FSI.ID AND FSI1.ID_FIELD_DEF IN (SELECT ID FROM FRA_ITEM_FIELD_DEF WHERE MAPPING='executionDate') AND FSI3.ID_STAT_ITEM=FSI.ID AND FSI3.ID_FIELD_DEF IN (SELECT ID FROM FRA_ITEM_FIELD_DEF WHERE MAPPING='creditAccount') ) STAT GO Query to fetch and display record in GUI: WITH query AS (select ROW_NUMBER() OVER (order by fraudstats0_.id desc) as __hibernate_row_nr__, fraudstats0_.id as id64_, fraudstats0_.version as version64_, fraudstats0_.alert_type as alert3_64_, fraudstats0_.benef_cust_id as benef4_64_, fraudstats0_.blocked as blocked64_, fraudstats0_.company as company64_, fraudstats0_.creation_time as creation7_64_, fraudstats0_.id_mandator as id8_64_, fraudstats0_.ordering_cust_id as ordering9_64_, fraudstats0_.id_original as id10_64_, fraudstats0_.reference as reference64_, fraudstats0_.sequence_no as sequence12_64_, fraudstats0_.item_type as item13_64_, fraudstats0_.alerted as alerted64_, fraudstats0_.last_evaluation as last15_64_, fraudstats0_.last_eval_time as last16_64_, fraudstats0_.last_eval_user as last17_64_, fraudstats0_.id_live_item as id18_64_, fraudstats0_.payload as payload64_, fraudstats0_.status as status64_ from fra_stat_item fraudstats0_ where fraudstats0_.id in (select fraudstats1_.id from fraud_alert_stat_hit_view fraudstats1_ where fraudstats1_.fraud_item_type='profile.batch.trn.alert' and fraudstats1_.value_date>=@P0 and (fraudstats1_.account in (@P1 , @P2 , @P3) or fraudstats1_.account in (@P4 , @P5 , @P6))) ) SELECT * FROM query WHERE __hibernate_row_nr__ BETWEEN @P7 AND @P8 At present, Archiving/Purging the table is not possible by structure. Could anyone share some suggestion on fine tuning the view?Padding before the next field
Hi All, Is it possible to create padding before the next field. I have a Description field which starts after the Title however the Title can be 1 line or 2 or 3. In this case, I do want the title to be take up to 3 lines but I would like to start the next field at a fixed position not relative to the title OR alternatively after there is space for 3 lines of title. This will make sure the rest of the card is aligned. Is there any JSON code that can achieve this for my Sharepoint Gallery ViewJSON View Formatting - Count total number of items in SP list
Hi, I want to modify the groups footer of a custom view that is grouped by a metadata column named Response/Actionv2. In the Totals section of the view settings I enabled Count for this column, which now displays the number of items (rows) for each of the groups. However, I would like to use this number in the JSON formatting to calculate and display the proportion (in percentage %) of total number of decisions. As you can see in the code below, I've included the static number 31, but I'd like to be able to dynamically reference the total number of items in the list? Basically, do you have an idea on how to implement this formula: (@columnAggregate.value / TOTAL NUMBER OF ITEMS) * 100 { "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/row-formatting.schema.json", "groupProps": { "hideFooter": false, "footerFormatter": { "elmType": "div", "children": [ { "elmType": "div", "attributes": { "iconName": "CalculatorPercentage" }, "style": { "color": "=if(@columnAggregate.type == 'Count' && @columnAggregate.value < 50, '#d13438', '#107c10')", "font-weight": "600", "margin-top": "10px" } }, { "elmType": "div", "style": { "color": "=if(@columnAggregate.type == 'Count' && @columnAggregate.value < 50, '#d13438', '#107c10')", "font-weight": "600", "margin-top": "10px", "font-family": "Segoe UI" }, "txtContent": { "operator": "*", "operands": [ 100, { "operator": "/", "operands": [ "@columnAggregate.value", 31 ] } ] } } ] } } }
Download button in View formatting JSON
Hi, Im create a view in a document library to give an overview of the files with a description. On that view I would like a download button, to download the files directly. On known file formats link JPG i just opens the file and on unknown formats link EPS it dowloads the file. The code looks like this: "elmType": "button", "style": { "background-color": "#6eb556", "color": "white", "font-weight": "bold", "font-size": "1rem", "float": "right", "margin-right": "150px" }, "customRowAction": { "action": "Download" }, "txtContent": "Download", "attributes": { "class": "sp-row-button" Is there a way to force it always to download the file?
Edge How to view PathName of Element(s) without parsing URL?
Image to demo what I need. My suggestion borrowed from Toggle View feature in Word 365 Shift+F9 - Toggle Element display - toggles Display for elements contained in the current selection. Alt+F9 - View Element PathName - toggles PathName display for all elements in the entire Page. Thanks Regards,Apply view only for a specific folder
Hello everyone I have a folder within a default document library which is connected to a team in teams. So, in this folder I have documents that must be sorted by its number in the file name. Example: File_1 File_2 ... First, I figured out that it isn't possible to sort numeric, if the number is only in the filename. SharePoint will then sort it like: File_1 File_11 File_2 ... Very frustrating but okay. So, I created a numeric column that can be used to sort the files properly. But what I noticed is that the column is now visible in the whole document library 😞 So now my question: Is it possible to apply the column to only being visible in this specific folder where I need it? I tried it with different views and so on, but it seems that this cannot be achieved. Thanks for your help.Calendar List View - Future Months Not Showing
Hello! I created a group calendar within Teams where team members can add their time off through a list. Team members have put in time off for the next three months. In the list view, I can see all inputs for all months but in the calendar view, I can only see the current month (June) listings. Here is a screenshot of the calendar view. There should be listings for July but they are not showing up on the calendar view. Any help would be greatly appreciated!
