I have a SharePoint list with two columns that I want to multiply (QTY - numeric and Unit price - currency).  I want the result to go in a third column (_Line total - currency).  The SharePoint list Flow is "When an item is created or modified."  This used to be pretty easy with SharePoint Designer but because I'm new to Flow, it seems overly complicated.  A calculated column is out because I want to use the third column to group and sum in list views.

Here is the expression I'm using but it errors out when run:

mul(triggerBody()?['QTY'],triggerBody()?['Unit price'])

Select all Open in new window

Good morning

Could you check this out and please do criticize it as much as possible. I want this to go smoothly :D

-----start-----

We will first start with the DL360s, known going forward as the “Management Cluster”. The justification for using these first is purely because they hold the IT Infrastructure and will allow for small issues due to the fact they won’t impact production or end user use.

1.      Log onto VMware (https://Server/vsphere-client/?csp)

2.      Migrate all the VM’s off of Server01.Doimain.com onto Server02.Domain.com manually.

3.      Drop serverl01.Domain.com into maintenance mode. This previously has caused purple screens, hence the initial move.

4.      Obtain a formatted USB Key media.
 
5.      From that drive and directory, execute the downloaded SoftPaq file: Simply double click on the SP99298.exe file and follow the installation wizard to complete the SoftPaq installation process. At the end of a successful installation of the SoftPaq a web page will automatically appear to provide you with the different methods for restoring and/or upgrading the firmware on the system.
 
6.      After the USB Key is created, you may delete the downloaded file if you wish.
 
7.      Insert this USB Key into the USB Key port of the system to be updated and power the system on to boot to the USB Key.

8.      Shutdown the host and boot from the USB key

9.      Install the latest BIOS version

10.      Shutdown the server

11.      Plug in the USB stick with the HPE Custom Image for …

Dear helpful experts,

Could you please assist regarding below-?
Part of role, we update computer/asset bar-code details in Active Directory to keep track of financial record/cost centre. So as a process we need to open AD, go to default search for Hardware, then able to see hardware but cannot see Attribute Editor for complete detail.
I’d like to add an AD custom tab or Attribute Editor. (Please see attached image).



1.      How to add Attribute Editor Tab as an standard in scenario-1. (Showing in the attached image)
So we can avoid steps A, B and C to search Attributes as shown in scenario 2.
 
2.      If we can add Attribute Editor Tab in scenario 1 then how to include only selected fields instead 50+ of field. i.e. department, department number, description, etc…… shown as 2,3,4,5

Many thankks

Business phone systems - looking to upgrade. What are the options people are currently using? For example if we go to an all cloud based system - what happens when we lose internet, does the system have a fall back adsl number that people can still contact us on? Also anyone used Skype for Business and if so - does it use much bandwidth? Can we have multiple numbers?

Thanks

I have a client who has a lot of old wmp files (windows media photo), which I need to convert to any modern file type.  I cannot find anything which will open them, let alone convert them.  Does anyone have any suggestions?

I've tried all the Adobe Apps and even gone back to an XP machine with Windows Photo Viewer and Windows media Player, but no go :(

Thanks

In my Delphi application, I have a TMemo on a form
I put some text in it, but quiet long (wordwrap = true)
That's not a problem, user can go down in the text but sometimes the beginning of the text is not shown at the top right of the TMemo
How can I have text visible from the beginning of it

Dear Experts,

I have a network that is connected to the internet 192.168.3.0/24.

I have another network 192.168.125.0/27 which I want to connect to the internet

I have a HP Jl380A switch.

Port 8 is already connected to the network using a static IP so that I can manage the switch. This IP is 192.168.3.251 of vlan1.

I created a vlan20 for 192.168.125.0/27 included and untagged at Port1 @ IP 192.168.135.131/27.

Do i need to configure another port using a seperate vlan so that vlan20 can go internet?

Or use port8 which is already connected to the internet?

Can you please help?

I have a workbook that contains dynamic number of sheets.
Each sheet contains three pivot tables, these pivot tables have three source sheets.
All three source sheets have one column in common the customer ID, and therefore, the three pivot tables are filtered on Page Filed “GL_ID”, i.e. customer ID.  
Every day, we run another macro that compiles a dynamic list of customer IDs, and out of this list, we create a changeable number sheets, this macro also pastes three pivots on those sheets, it also prints the customer ID on cell B2 of each sheet (each sheet contains, (1) balance, (2) possible trading activity and (3) possible product change reports of a customer).
-      Pivot table one contains;  all customer IDs
-      Pivot table two and three, however, may or may not contain every customer ID printed on cell B2.
What I would like to do and kindly ask your help, is a macro that filters each pivot table in each sheet, by setting the page fields equal to the value of cell B2?
But also importantly before that, it tests, if the pivot item in cell B2 is to be found in the drop down list of the pivot tables (page field), epically on pivot table two and three .
-      If the pivot Item is found = filter each pivot table based on cell B2.
-      Else ignore and go to the next pivot table.
Thank you in advance,
Regards,
Jay

Hi

I have an IIS 7 server, however suddenly it's not automatically redirecting to the relevant /index.php file in sub directories.

For example, if it is www.example.com/ it should automatically go to www.example.com/index.php

I haven't changed anything and I'm struggling to figure out what the issue is!

Any ideas?

In Excel 2016, my "Nuance PowerPDF" tab has moved to in front of the "Home" tab.  Unfortunately, when I go into "Customize Ribbon", it shows me ALL of my ribbons except for the Nuance Power PDF ribbon (fyi:  Power PDF add-in is enabled in Excel 2016).  So I can move any of the other ribbons (e.g., Acrobat, Review, etc.) in front of "Home".  I cannot figure out how the user got the Power PDF ribbon to be in front of the "Home" tab if the ribbon does not show.

This does NOT happen in any of the other Microsoft Office 2016 products.

Outlook 2010 - New sent mail goes to outbox but does not go to sent items and after restarting outlook the mail is missing - Any suggestions or solutions.

Hello experts,

I have the following flat file attached (Input Sheet).
I am trying to build a vba procedure that covers the following requirements:
1-Check if Output sheet if so delete and create a new blank
2-Transfer the various unique values in column H, J and AI
3-Consolidate the sum values for the various month from AJ to BV split by column AI

I attached dummy file with expected Output sheet.

I think that we can proceed steps by steps, such as copy unique values related to H & J.
For this we can use the following procedure:

Sub CopyRangeUniqueValues(FromWSheet As String, FromRange As String, ToWSheet As String, ToRange As String)
'Sub treats first cell in FromRange as a header label, and will copy it to ToRange even if it is duplicated in the list
Dim celHome As Range, rgDest As Range, rgSource As Range
Dim n As Long
Set celHome = ActiveCell
Set rgDest = Worksheets(ToWSheet).Range(ToRange)
Range(rgDest, rgDest.End(xlDown)).ClearContents

With Worksheets(FromWSheet)
    n = .UsedRange.Row + .UsedRange.Rows.Count - 1
    Set rgSource = .Range(FromRange & n)
End With

rgDest.Worksheet.Activate
rgSource.AdvancedFilter Action:=xlFilterCopy, CopyToRange:=rgDest, Unique:=True
Application.GoTo celHome

Select all Open in new window

Concerning the consolidated sum we can also go ahead with a formula reported in macro:

Sub LoopFormula2(strwsName, strColflag, strCol As String, strColName As String, formula As String)

'Call LoopFormula2("ImportCC", "1", "D", "Test", "=clean(sheet1!G2*sheet1!I2)") 'example of formula
    Dim ws As Worksheet
    Set ws = Worksheets(strwsName)
    ws.Activate
     '==>Clear Destination Column
    Range(strCol & ":" & strCol).Clear
    UsedRows = ActiveSheet.UsedRange.Rows.count + ActiveSheet.UsedRange.Rows(1).Row - 1
    If strColflag = 1 Then
        Range(strCol & 1).Value = strColName
    End If
    '==>Clear Destination Column
    RightFormula = Replace(formula, "1048576", UsedRows)
    '==>ApplyFormula
    Range(Cells(2, strCol), Cells(UsedRows, strCol)).formula = RightFormula
    Range(Cells(2, strCol), Cells(UsedRows, strCol)).Value = Range(Cells(2, strCol), Cells(UsedRows, strCol)).Value
End Sub

Select all Open in new window

Thank you in advance for your help.

We have identified one PC having more than 20 ms to application server  .  All the other machine look ok with the same time to mention serevrs . Only one ping replay going more than 40 ms . How can we monitor the  network card fault in a large network  . Is there any way of monitor via network monitoring tool ?
And the other two thing i need to confirm are
that fault network card PC can Couse the Network FDe ?
Local Are network  ping  ms value shuld below 10 ? or can be go up due to the nature of the serevr like Application / exchange ?