User Profile

AndrewCrompton

Copper Contributor

Joined Mar 22, 2023

4 Posts

View All Badges

User Widgets

Recent Discussions

Re: Create SPO list from csv with schema with calculated columns
Hi, Pankaj Thanks for this. Looks like I'll have to deal with the calculated fields manually, then. Maybe MS will get around to parsing such fields as formulas at some point - would be useful. Andrew
Aug 15, 2025 Place SharePoint
43Views
0likes
0Comments
Create SPO list from csv with schema with calculated columns
Hi, I am trying to create a new SPO list from csv with schema. (I take the standard route: New, List, CSV. Then upload the csv file from my pc.) In general it is working ok, but I am unable to process calculated columns correctly. The column is imported, but as values rather than a formula. Here is an example of a column-definition from my schema (I have omitted various other columns which are unproblematic): ListSchema= { "schemaXmlList": [ "<Field Type=\"Calculated\" DisplayName=\"ProgrammeID_Space_ProgrammeName\" EnforceUniqueValues=\"FALSE\" Indexed=\"FALSE\" Format=\"DateOnly\" LCID=\"2057\" ResultType=\"Text\" ReadOnly=\"TRUE\" ID=\"{65de5fda-ea99-4829-ae88-c71d6d1cb2e0}\" StaticName=\"ProgrammeID_Space_ProgrammeName\" Name=\"ProgrammeID_Space_ProgrammeName\"><Formula>=ProgrammeID&\": \"& Programme</Formula><FieldRefs><FieldRef Name=\"Programme\" /><FieldRef Name=\"ProgrammeID\" /></FieldRefs></Field>" ]} All the formula does is produce a text column consisting of ProgrammeID & " " & ProgrammeName so nothing complicated. Can anyone suggest how to resolve this issue, please? Thanks, Andrew PS Why does the schema have Format=\"DateOnly\" when this field has nothing to do with dates?
Solved
Aug 14, 2025 Place SharePoint
microsoft lists
95Views
0likes
2Comments
Re: Automatically aggregating / summarizing from one list into another
ganeshsanap Hi, Ganesh, Thanks for your reply. I'm not too surprised that SPO does not allow this. I guess I'll have to make do with a PowerApps solution. Kind regards, Andrew
Apr 07, 2023 Place SharePoint
2.6KViews
0likes
0Comments
Automatically aggregating / summarizing from one list into another
I want to aggregate / summarize information from one SPO list into another (without using a flow, Powerapp etc.). For example, I have a list of payments, which includes a column called PaymentID, and I want to create a summary list which will automatically display the maximum PaymentID that currently exists in the list of payments. Then, when a new payment gets added, with a PaymentID that is 1 greater than the previous payment, the summary list should automatically display the new maximum PaymentID. Does anyone know of a simple way of doing this? Thanks for any suggestions.
Solved
Mar 31, 2023 Place SharePoint
Lists
SharePoint Online
3KViews
0likes
2Comments

Recent Blog Articles

No content to show