Buenas tardes, En una lista de Microsoft lists, tengo una columna denominada Valor, que por cada fila tiene varios números: Fila 1: 24 Fila 2: 32 Fila 3: 36 y me gustaría calcular otra columna denominada Tendencia, que se fije en los valores de

MARTIN VALERO Carlota - Contractor 100 Reputation points
2023-09-18T12:46:27.5733333+00:00
Buenas tardes,

En una lista de Microsoft lists, tengo una columna denominada Valor, que por cada fila tiene varios números:

Fila 1:   24

Fila 2:   32

Fila 3:   36

y me gustaría calcular otra columna denominada Tendencia, que se fije en los valores de la columna Valor y si la secuencia de números es creciente, ponga ASCENDENTE; si es decreciente, ponga DESCENDENTE y si es igual ponga IGUAL: por ejemplo:

           Valor           Tendencia

Fila 1:   24

Fila 2:   32

Fila 3:   36               Ascendente

Fila 4:   20               Descendente

Fila 5:   10               Descendente

y así sucesivamente.... ¿Cómo podría hacerlo?

Responder 
SharePoint Server
SharePoint Server
A family of Microsoft on-premises document management and storage systems.
2,211 questions
SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
9,572 questions
SharePoint Development
SharePoint Development
SharePoint: A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.Development: The process of researching, productizing, and refining new or existing technologies.
2,657 questions
SharePoint Workflow
SharePoint Workflow
SharePoint: A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.Workflow: An orchestrated and repeatable pattern of business activity, enabling data transformation, service provision, and information retrieval.
506 questions
SharePoint Server Management
SharePoint Server Management
SharePoint Server: A family of Microsoft on-premises document management and storage systems.Management: The act or process of organizing, handling, directing or controlling something.
2,796 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. ChengFeng - MSFT 5,010 Reputation points Microsoft Vendor
    2023-09-19T02:23:30.01+00:00

    HI @ MARTIN VALERO Carlota - Contractor

    Here is a test for your reference:

    Here is list

    User's image

    Here is flow

    add(triggerOutputs()?['body/ID'],-1)
    
    if(equals(triggerOutputs()?['body/Value'],outputs('Get_item')?['body/Value']),'EQUAL',if(greater(triggerOutputs()?['body/Value'],outputs('Get_item')?['body/Value']),'ASCENDENTE','DESCENDENTE'))
    

    User's image

    Here is test result:

    ASCENDENTE

    User's image

    User's image

    EQUAL:

    User's image

    User's image

    DESCENDENTE

    User's image

    User's image


    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    Best Regards

    Cheng Feng