New answers tagged modern-experience
1
vote
Accepted
Power APPS- Disabling button in the gallery
Is the column/data type of Cost_mitigation_1 and effect_mitigation_1 not "Number", try using formula in Power Apps like this:
If(
Value(ThisItem.Cost_mitigation_1) > Value(ThisItem....
- 42.8k
1
vote
In SharePoint online, is it possible to dynamically feed the name of the user loading the page to the Organizational Chart web part?
Unfortunately, SharePoint online out of the box Organizational Chart web part and the People web part does not support dynamically showing the information of currently logged in user.
You will have to ...
- 42.8k
0
votes
Issue in column formatting in SharePoint JSON with If statement
LEFT() function is from SharePoint calculated column formulas which is not supported in SharePoint JSON formatting.
Use below JSON column formatting:
{
"$schema": "https://developer....
- 42.8k
0
votes
Filter By does nor have search option in SP List
This is the default behavior in SharePoint Online modern experience list views.
As per my testing, text search option in "Filter by" pane is available for:
Single line of text and
Person or ...
- 42.8k
0
votes
Accepted
JSON to Show Time Until a Specific Timestamp - SharePoint List
From the screenshot you provided, I can see that you are using "Date only" column named "Flight Arrival".
If you are trying to show the number of days until the Flight Arrival date,...
- 42.8k
-1
votes
How to detect Edit vs New when styling custom list forms with JSON?
Try the steps in this video for showing a field conditionally depending on whether you are creating a list item OR viewing/editing a list item https://youtu.be/lxAmYT-uQe4?feature=shared
Steps:
...
- 1
0
votes
Accepted
Modern EditForm for Documents when using Document Sets
You can enable the modern properties forms for Document sets content type in SharePoint Online document library using the PnP PowerShell script.
Example:
# SharePoint online site url
$siteUrl = Read-...
- 42.8k
0
votes
Changing color in calendar view to show different locations
If you are using SharePoint Online Modern list calendar view, you can use SharePoint JSON conditional formatting rules to color code the events based on columns (like Location) in the list.
Example:
...
- 42.8k
0
votes
Get file name and full link
Try following these steps for SharePoint Online Modern experience document library:
Go to your SharePoint Online Modern experience document library view
Click on Export to Excel option from top ...
- 42.8k
2
votes
SharePoint List Person Column should not be blank
Unfortunately, this is not possible using SharePoint Online out of the box functionalities because of following reasons:
You cannot apply conditional formula on list form fields if the the column is ...
- 42.8k
0
votes
In SharePoint list, how to add a table like excel where you can fill up information as you want?
In SharePoint, you can use the Grid view (quick edit) or datasheet view to bulk edit multiple items.
You can switch to grid view from normal list view using:
Grid view in action:
If you want to ...
- 42.8k
0
votes
Add button for email in list form footer using JSON. Email content must include link to the form
I am new to JSON and I also cannot use Power suite nor Designer. The workaround I used to obtain the ID, is by creating a calculated column in the List named "RecID" (you can name it as you ...
- 1
2
votes
Accepted
SharePoint List Conditional Formula not working
Well, I managed to found the issue. The issue was due to the naming, we need to follow the naming as below:
Go to list setting -> select the column name and check the naming at the end of link.
- 41
0
votes
Accepted
SharePoint Lists - edit columns not hiding/showing
Your SharePoint conditional formula and syntax looks good to me.
I will suggest you to verify below things:
Make sure you are using correct internal name of "Catalogue" in the SharePoint ...
- 42.8k
0
votes
Adding a semi-transparent cover on an image in a SharePoint View?
I found a way to show translucency by generating a card on mouse hover. This is the mouse hover event in SharePoint JSON-Formatting. You can use this method as a backup.
I used customCardProps and ...
- 171
1
vote
Column Formatter using (File) Name field
I am able to reproduce this issue on our SharePoint site. Here are the results:
I am unable to see the Format this column option to SharePoint default "Title" column in the document library ...
- 42.8k
2
votes
Accepted
Inheriting metadata upward?
Upward metadata inheritance is not possible automatically using the SharePoint Online out of the box features.
Here are few options you can try:
Update folder metadata manually:
You cannot update the ...
- 42.8k
0
votes
SharePoint Online - FAQ List Colors
Use below JSON in SharePoint list JSON view formatting settings:
{
"$schema": "https://developer.microsoft.com/json-schemas/sp/v2/row-formatting.schema.json",
"...
- 42.8k
1
vote
Accepted
Making required condition in SharePoint list dependent on another field
You have to use the SharePoint List validation settings for your requirements.
Use list validation formula like:
=IF([Status]="Finalised",NOT(ISBLANK([End date])),TRUE)
Note:
Sometimes ...
- 42.8k
1
vote
Accepted
SharePoint adding 2 zeros to the percentage values in my list
SharePoint stores actual values ranging from 0 to 1 for a Number column with 'Show as percentage' option checked in backend.
Solutions:
If you are using SharePoint Online modern experience list and ...
- 42.8k
1
vote
Hide Visibility of PowerApps Form Container Based on Name in Field
You can use below simplified formula in Visible property of your container or other controls in Power Apps (use latest MyProfileV2 function instead of MyProfile):
DataCardValue.Text = Office365Users....
- 42.8k
0
votes
Hide Visibility of PowerApps Form Container Based on Name in Field
My function was off just a little bit. The way to get it to work is with a function that looks a bit like this.
If(DataCardValue.Text = Office365Users.MyProfile().DisplayName, true, false)
Change the ...
- 155
Top 50 recent answers are included