New answers tagged list
0
votes
SharePoint List: Content of Lookup Column disappears when using conditional formatting
{
"$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json",
"elmType": "div",
"style": {
"border-...
- 1
0
votes
Use PowerAutomate to pull a data from another existing existing list
This might be easier and quicker to do if you customise the SharePoint list form with PowerApps.
In Power Automate, I assume you have a workflow that triggers when Target list item is created or ...
- 9,129
0
votes
Hide helper columns while preserving conditional formatting which is based on them
Add 42 days
42*24x60x60x1000
{
"$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json",
"elmType": "div",
...
- 305
0
votes
Accepted
How to preserve colors when exporting SharePoint list data as an excel file?
These color backgrounds provided in the choice columns are only for the viewing purpose. It will not come in exported excel/csv when user clicks on OOTB "Export to Excel" feature.
To achieve ...
- 7,247
0
votes
SharePoint Online grouped list JSON formatting
Dikesh Gandhi's comment is right. Appreciate for his help.
Here I am attaching the official SharePoint documentation which clearly documents the types of JSON formatting columns that are supported and ...
- 499
0
votes
Column date and time + add selected time
Try using calculated column formula like this:
=[DateTimeColumn] + [ExtraMinutesColumn]/(24*60)
Where "ExtraMinutesColumn" is a "Number" type column.
Column Settings:
Output:
...
- 46.4k
0
votes
Accepted
Power Apps Plan error when trying to view SharePoint Online list item created in PowerAutomate
This is because the form has been customized with Power Apps.
You can revert back to the original SharePoint form.
On the list, as an admin, go to List settings > Form settings > Use the default ...
- 1,448
0
votes
SharePoint online list form PowerApp shows edit link when user only has read permissions
in the app you can remove this 'Edit All' button. Or set the button's 'Visible' parameter true of false according the user state (if you can tell about the logged in user whether he/she should have ...
0
votes
SharePoint list pictures not showing in Outlook
I know this is an old post, but I have finally figured out a way to make this work.
If you do not see the image in outlook do the following.
Make sure the email address for your SharePoint which is ...
- 1
0
votes
SharePoint list Lookup Column
When users create a new item in your target list, they will see a dropdown menu for the Lookup Choice column, displaying the choices retrieved from the source list. Users can select one or multiple ...
- 535
0
votes
SharePoint list Lookup Column
Since you have created PRID column by choosing Purchase list and ID column during column creation, it is showing the same ID in your dropdown in Line Items list.
To confirm, you can save the data in ...
- 7,247
0
votes
Accepted
How can I update data in a SharePoint list via Connection in Excel?
I think your best bet is to use Power Automate.
If the list is on a SharePoint site, you can tell Power Automate to trigger on the items when changes or made. You can ask the Power Automate experts ...
- 1,119
0
votes
Accepted
How to handle SharePoint 2,000 lists and libraries combined per site limit for large number of lists/libraires?
If the library fulfils a single Customer's need, then the design looks sound.
Have you considered permissions? Do you plan on breaking permission inheritance for libraries?
Mind you, 2,000 lists and ...
- 2,778
0
votes
SharePoint online multi line text field limit larger than documentation
The documentation indicates that the limit for a multi-line text field in SharePoint is typically 63,999 characters. However, you can store more than this limit. Just as SharePoint has a limit of 5000 ...
- 535
0
votes
Accepted
SharePoint Column Formatting that detects matching words across all the items in the same column
Unfortunately, you will not be able to achieve this using SharePoint JSON formatting capabilities.
In column/view JSON formatting, you cannot access/use the column values from another list item/row.
...
- 46.4k
0
votes
How can I update data in a SharePoint list via Connection in Excel?
There is no native way to achieve this. You need programming or a third party tool.
We used to sell our software Synchronizer for Excel and SharePoint for this, but it has been discontinued. If you ...
- 353
Top 50 recent answers are included