Thursday, July 25, 2024

Power Automate + Excel data

  • Extract excel data, get manager and update row with user details which will get from GET MANAGER

  • Concepts and examples

    • Key column: Column in a table that will be use to search a value (key value).
    • Key value: Value in the key column that will be used to identify a specific row.

    The following table is an example. To perform a row operation in the second row of the table, the key column should be Column 1 and key value should be 200.

    Column 1Column 2Column 3
    100A-2A-3
    200B-2B-3
    300C-2C-3

  • Flow screenshot for reference

Excel Online (Business) connector lets you work with Excel files in document libraries supported by Microsoft Graph (OneDrive for Business, SharePoint Sites, and Office 365 Groups).
https://learn.microsoft.com/en-us/connectors/excelonlinebusiness/

Excel Online (OneDrive) connection provider lets you work with Excel files stored in OneDrive. This connection provider only supports personal (MSA) accounts.
https://learn.microsoft.com/en-us/connectors/excelonline/

Friday, April 19, 2024

Update or edit status filed in JIRA issue

the status field is a special case and can't be updated directly, which is the second problem here. Changing a status in Jira is called a transition. You need to trigger the transition to move the issue into the status you want.

Start by identifying the available transitions by calling the get transitions API:

GET https://example.net/rest/api/latest/issue/FWZH-2170/transitions

This tells you which transitions are currently available, something like this:

{
  "expand": "transitions",
  "transitions": [
    {
      "id": "21",
      "name": "Fixed",
      "to": {
        "self": "https://example.net/rest/api/2/status/10001",
        "description": "",
        "iconUrl": "https://example.net/images/icons/status_generic.gif",
        "name": "Fixed",
        "id": "10001",
        "statusCategory": {
          "self": "https://example.net/rest/api/2/statuscategory/3",
          "id": 3,
          "key": "done",
          "colorName": "green",
          "name": "Done"
        }
      }
    }
  ]
}

Take the id of the transition you want, in this case 21, then post it to the issue transition API:

POST https://example.net/rest/api/latest/issue/{IssueKey}/transitions

Use a request body like this:

{
  "transition": {
    "id": 21
  }
}

You should get a 204 HTTP response from Jira which indicates the transition was successful.

Power Automate + Excel data

Extract excel data, get manager and update row with user details which will get from GET MANAGER Concepts and examples Key column:  Column i...