SharePoint 2016 creating new Web application with ADFS configuration

I created a new web application in our SharePoint 2016 environment , this web site should be accessible internally and externally as well.
I have created the web application on port 443 with ssl “https://testsite.com”, given the dns name and then selected trusted identity provider as ADFS which I configured .
then I extended the same web application to port 80 with no ssl “http://testsite.com” and then selected windows authentication.
When I go to IIS and see both the sites are existing there , i have binded https site with SSL certificate as well
when I check the drop down of sites in IIS http and https both doesn’t show _trust folder. So I deleted the web application and sites and recreated them with same procedure, now I can see the _trust folder , my question here is I want to access the site without giving http and https from browser , just like testsite.com and expecting it to open the adfs sigining page, how would i achieve this. Any suggestions would really help, thank you

sharepoint online – Calculated Column and File Name ‘Title’ Field

I uploaded more the 2000 images files to an SP document library.

When I checked the ‘See Details’ under the file name property options, I noticed the actual name of the file appears in the “Name” field, but not the “Title” field. Why did SP add the name one place and not the other; especially if the content of “Title” is what an SP calculated column defaults to for calculations; which is my issue.

I now want to create a calculated column but the formula doesn’t work because there is no data in “Title”, and “Title” is the only column name option given to me when creating the calculated column.

The question also being asked, “why can’t I see/access ‘Name’ column” in the column options when creating the calculated column? That would fix everything.

Please advise.

enter image description here

SharePoint calculated column, converting time into decimal then dealing with greater than 24 hours using IF

I have a SharePoint list that has the following columns:

Start Time
End Time
Employee Count
Total Hours
Total Hours (Decimal)

The “Start Time” and “End Time” are DATE format, “Employee Count” is a NUMBER and the remaining two columns are Calculated (NUMBER).

“Total Hours” column works out the time difference between Start and End Time then multiplies the return value by Employee Count using the following formula:

=CONCATENATE(INT((Time Diff)*(Employee Count)*24),":",TEXT(MOD((Time Diff)*(Employee Count)*24*60,60),"00"))

I then have to convert the “Total Hours” into decimal, this is done in the “Total Hours (Decimal)” column using the following forumla:

=(Total Hours)*24

This works great so long as the “Total Hours” column is less than 24, if it goes over 24 then I get a ?NAME error.

To get around this I’ve tried to put an IF statement into the “Total Hours (Decimal)” column to change the calculation depending if the value in “Total Hours” is less than 24.

=IF((Total Hours)<24,(Total Hours)*24,0)

The 0 is just a place holder as I’ve not worked out the right calculation yet. However this IF statement doesn’t seem to work as the result is always 0 no matter if the “Total Hours” is less or greater than 24. Is there some catch with referencing a calculated column?

Any help gratefully received.
Rob

sharepoint online – Power Automate – Select single item from Get Items

Here are the steps that I would follow:

  1. After (Get Items) action add a (Compose) action
  2. Execute the Flow and examine the output from the (Compose).
  3. Copy the output of the (Compose) into clipboard
  4. Add (Parse JSON) action and use the output from step 3 as sample data to generate schema
  5. Add addition actions like another (Compose) action to verify the Parse Data.
    Properties should be available from the Dynamic content.

To get a particular item’s property, you can use the expression shown below.
Here (0) indicates the first item in the (Parse JSON) output, which is an array, and (‘LastName’) is a list column (property).

body('Parse_JSON')?(0)('LastName')

enter image description here

Here is an article
describing how to work with JSON in Flow

sharepoint online – Moving files from OneDrive to Teams via Powershell

While it is possible to move files between Teams sites and between OneDrive users, it does not seem feasible to move files from Teams to OneDrive and vice versa, using Powershell.

The restriction is happening due to the domain differences between OneDrive and Teams.

OneDrive URL:
https://org-my.sharepoint.com

Teams URL:
https://org.sharepoint.com

After connecting to one of the above you are only able to use relative URLs with the Move-PnPFile command and will be unable to point to the other domain.

Eg.

Connect-PnPOnline -Url https://org.sharepoint.com
Move-PnpFile -ServerRelativeUrl "/teams/MyTeam/Documents" -TargetServerRelativeLibrary "/personal/user_domain_com/Documents/"

Will throw an error due to not locating the target.

How can we transfer files between these domains in the same organization without downloading and uploading files to/from a local disk?

sharepoint online – Remove html and js file from Filter item display template

I have a custom filter and search item Display template in the Master page Gallery. I want to delete them using Code behind before i add the new js files. How to get the master page Gallery library from Code behind ?.

Should i be {sitecollection}/_catalogs/MasterPage or any other way to get the library ?.

Retrieve Auto-Generated app unique id in SharePoint Hosted Add-In (On-Premise 2016)

The SharePoint add-in auto-generates a unique id for the add-in upon each new deployment, see screenshot!

Is there any way I could retrieve (capture) that id in a post deployment script thats runs after each successfull build?

Thanks in advance!

enter image description here

list – SharePoint Online – Show column description or full column name when hovering the column header

We currently have a SharePoint list that has quite many columns, with describing column names making the column names take up quite a lot of width. Many of them get cut off in the middle of the name, since we’re trying to save some space so the users doesn’t have to scroll too much horizontally. See picture below:

enter image description here

If you change to grid view, you get a tooltip displaying the full column name when hovering the column headers. See picture below:

enter image description here

Is it possible to achieve something similar in the “normal” list view? Either where you get a tooltip with the full column name or the column description. Similar to the grid-view.

sharepoint online – How to enable Modern Experience for new site home page?

Apologies for this basic question. I recently created a new Team Site and would like it to use the Modern Experience. However, the home page for the site seems to default to the classic experience, even though the other pages use to the modern experience (see screenshots). I would ideally like all the pages to use the modern experience so my users aren’t confused by the switches.

So, how do I change the Home page to use the modern experience?

Also, is there a setting I can update in SharePoint Admin so the home page of new sites defaults to be Modern Experience?

I tried Googling this, but couldn’t find any perfectly clear answers (this Q&A seemed to suggest that you have to make a new site page and designate it as the homepage, but that seems roundabout to me: Set Modern Page as a Home Page). Thanks!
Classic Experience Home page

Modern experience page