tdalon

// STEP Expand&Rename
let
    IssuesTable = GetIssuesTable,
    ExpIssues = Table.ExpandRecordColumn(IssuesTable, "Column1", {"key", "fields"}, {"Key", "Fields"}),
    // expand fields s. https://exceed.hr/blog/dynamically-expand-table-or-record-columns-in-power-query/
    IssuesRaw = Table.ExpandRecordColumn(ExpIssues, "Fields", Record.FieldNames(ExpIssues{0}[Fields]),Record.FieldNames(ExpIssues{0}[Fields]) ),
   
    // extracting field info
    restUrl = JiraRootUrl&"/rest/api/2/field",
    FieldsList= Json.Document(Web.Contents(restUrl)),

tdalon

FocusAssist(sInput){
Run, ms-settings:quiethours

; Wait for WinTitle=Settings
WinWaitActive,Settings

UIA := UIA_Interface()

WinId := WinActive("A")
UIAEl := UIA.ElementFromHandle(WinId) 

tdalon

Confluence_GetVerLink(url:="") { ; @fun_Confluence_GetVerLink@
; Get Link information from current page Url
; sHtml := Confluence_GetVerLink(url:="")
If (url="")
	url := Browser_GetUrl()
If (url="")
	return
; Get current pageId
pageId := Confluence_GetPageId(url)
rootUrl := Confluence_GetRootUrl()

tdalon

function addIndex() {
    var indices = [];

        jQuery(".ak-editor-content-area .ProseMirror").find("h1,h2,h3,h4,h5,h6").each(function(i,e) {
            var hIndex = parseInt(this.nodeName.substring(1)) - 1;
            if (indices.length - 1 > hIndex) {
                indices= indices.slice(0, hIndex + 1 );
            }
            if (indices[hIndex] == undefined) {
                indices[hIndex] = 0;

tdalon

If Confluence_IsWinActive() {
  If RegExMatch(Clipboard, "^http.*\.(png|jpg|jpeg|gif)$") {
    imglink = ![ALT TEXT](%Clipboard%)
    Clip_Paste(imglink)
    return
  }
}

tdalon

(FieldName as text) as text =>
let
    Source = Json.Document(Web.Contents(JiraRootUrl & "/rest/api/latest/field")),
    #"Converted to Table" = Table.FromList(Source, Splitter.SplitByNothing(), null, null, ExtraValues.Error),
    #"ExpandedTable" = Table.ExpandRecordColumn(#"Converted to Table", "Column1", {"id", "name"}, {"id", "name"}),
    Record = Table.First(Table.SelectRows(ExpandedTable, each ([name] = FieldName))),
    FieldId = Record.Field(Record,"id")
in
    FieldId

tdalon

let
    JiraRootUrl = getNamedCellValue("JiraRootUrl"),
    ProjectKey = getNamedCellValue("ProjectKey"),
    Source = Json.Document(Web.Contents(JiraRootUrl & "/rest/api/2/search?jql=project=" & ProjectKey & " AND issuetype = Epic AND labels in ('process_improvement')")),
    issues = Source[issues],
    #"Converted to Table" = Table.FromList(issues, Splitter.SplitByNothing(), null, null, ExtraValues.Error),
    #"Expanded Column1" = Table.ExpandRecordColumn(#"Converted to Table", "Column1", { "fields","key"}, { "Column1.fields","EpicKey"}),
    #"Expanded Column1.fields" = Table.ExpandRecordColumn(#"Expanded Column1", "Column1.fields", {"customfield_10104"}, {"Epic Name"})
in
    #"Expanded Column1.fields"

tdalon

Teams_GetMeetingWindow(Minimize:=false,showTrayTip:=true){ ; @fun_teams_getmeetingwindow@
; Syntax: 
;      hWnd := Teams_GetMeetingWindow(Minimize:=true) 
;   If window is not found, hwnd is empty
; Input Arguments:
;   Minimize: if true, minimized (aka Call in Progress) meeting window can be returned
;
; See implementation explanations here: 
;   https://tdalon.blogspot.com/2022/07/ahk-get-teams-meeting-win.html
; Does not require window to be activated

tdalon

Teams_Mute(State := 2,showInfo:=true,restoreWin:=true){
; State: 
;    0: mute off, unmute
;    1: mute on
;    2*: (Default): Toggle mute state

WinId := Teams_GetMeetingWindow() 
If !WinId ; empty
    return

tdalon

Teams_SwitchTenant(sTenant) {
    WinId := Teams_GetMainWindow()
    If !WinId ; empty
        return
    UIA := UIA_Interface()
    TeamsEl := UIA.ElementFromHandle(WinId)

    If !TeamsEl.FindFirstBy("AutomationId=idna-me-control-set-status-message-trigger") { ; menu not opened 
        ; Click on avatar
        MeCtrl :=  TeamsEl.FindFirstBy("AutomationId=idna-me-control-avatar-trigger")