SOLVED

Power Query and cell Notes (former Comments)

%3CLINGO-SUB%20id%3D%22lingo-sub-1334527%22%20slang%3D%22en-US%22%3EPower%20Query%20and%20cell%20Notes%20(former%20Comments)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1334527%22%20slang%3D%22en-US%22%3E%3CP%3Ehi!%3C%2FP%3E%3CP%3Eis%20there%20any%20way%20to%20connect%20a%20Note%20(the%20one%20you%20evoke%20by%20right-clicking%20the%20cell%20%26gt%3B%20New%20Note)%20with%20a%20Power-Query-made%20table%3F%20as%20of%20now%2C%20after%20the%20sorting%2C%20the%20Note%20is%20floating%20from%20one%20to%20another%20cell%20value.%20I%20guess%20it%20should%20be%20connected%20logically%20with%20the%20table%20ID%20column%20cells...%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1334527%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EBI%20%26amp%3B%20Data%20Analysis%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1334614%22%20slang%3D%22en-US%22%3ERe%3A%20Power%20Query%20and%20cell%20Notes%20(former%20Comments)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1334614%22%20slang%3D%22en-US%22%3E%3CP%3ENot%20that%20I'm%20aware%20of%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F635201%22%20target%3D%22_blank%22%3E%40Artur_999%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EYour%20suggested%20approach%20with%20linking%20via%26nbsp%3B%20ID%20keys%20to%20a%20comments%20table%20is%20the%20best%20way%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%20style%3D%22margin%3A%200in%3B%20font-family%3A%20Calibri%3B%20font-size%3A%2011.0pt%3B%22%3EWyn%3C%2FP%3E%0A%3CP%20style%3D%22margin%3A%200in%3B%20font-family%3A%20Calibri%3B%20font-size%3A%2011.0pt%3B%22%3EMVP%3C%2FP%3E%0A%3CP%20style%3D%22margin%3A%200in%3B%20font-family%3A%20Calibri%3B%20font-size%3A%2011.0pt%3B%22%3EAustralia%20UTC%2B%208%3C%2FP%3E%0A%3CP%20style%3D%22margin%3A%200in%3B%20font-family%3A%20Calibri%3B%20font-size%3A%2011.0pt%3B%22%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%20style%3D%22margin%3A%200in%3B%20font-family%3A%20Calibri%3B%20font-size%3A%2011.0pt%3B%22%3E%3CSPAN%20style%3D%22font-style%3A%20italic%3B%22%3EIf%20this%20answer%20was%20the%20best%20response%20please%20click%20the%20button%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%20style%3D%22margin%3A%200in%3B%20font-family%3A%20Calibri%3B%20font-size%3A%2011.0pt%3B%22%3E%3CSPAN%20style%3D%22font-style%3A%20italic%3B%22%3EI%20also%20happily%20accept%20likes%20%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1337893%22%20slang%3D%22en-US%22%3ERe%3A%20Power%20Query%20and%20cell%20Notes%20(former%20Comments)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1337893%22%20slang%3D%22en-US%22%3EThanks%20Wyn%2C%20I'm%20afraid%20that%20you%20are%20right%20and%20there%20is%20no%20way%20to%20do%20it%20by%20notes%2Fcomment.%20I%20will%20manage%20it%20via%20self-referencing%20table.%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

hi!

is there any way to connect a Note (the one you evoke by right-clicking the cell > New Note) with a Power-Query-made table? as of now, after the sorting, the Note is floating from one to another cell value. I guess it should be connected logically with the table ID column cells...  

2 Replies
Highlighted
Best Response confirmed by Artur_999 (New Contributor)
Solution

Not that I'm aware of @Artur_999 

 

Your suggested approach with linking via  ID keys to a comments table is the best way

 

Wyn

MVP

Australia UTC+ 8

 

If this answer was the best response please click the button

I also happily accept likes

Highlighted
Thanks Wyn, I'm afraid that you are right and there is no way to do it by notes/comment. I will manage it via self-referencing table.