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 beColumn 1
andkey value
should be 200.Column 1 Column 2 Column 3 100 A-2 A-3 200 B-2 B-3 300 C-2 C-3
GirishKumarMs
I AM GIRISH KUMAR AND ON MY BLOG YOU CAN FIND MICROSOFT AND SHAREPOINT ARTICLES .I hope these articles may helps you. Just Check out.
Thursday, July 25, 2024
Power Automate + Excel data
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...
-
In this blog, I am explaining how to send mail on any domain using an exchange server. You can implement an exchange server following this...
-
While getting this error "Cannot implicitly convert type 'Newtonsoft.Json.Linq.JArray' to 'string[]'" MenuJson...
-
• SharePoint REST service architecture-2013 SharePoint 2013 introduces a Representational State Transfer (REST) service that is compar...