Unique Static GUID

[Thomas_R_H]

Hi all 

I have a problem with the  "Text.NewGuid()" that generates the same GUID for each row my table. 

So i read through this post: Solved: Problem with M function Text.NewGUID() - Microsoft Fabric Community and got this: 

Table.TransformColumnTypes(Table.AddColumn(#"Filtered rows", "GUID", each try error Text.NewGuid() otherwise Text.NewGuid()), {{"GUID", type text}})
My question is will this keep the generated GUIDS static? 
It is used for a dataflow in the Power Platform and i have to tick the box "Delete rows that no longer exists in the query output", which basically means that they have to be static to be able to delete the correct rows that does not exist any more? 

If not, is there some one that can help with a work around? 

Br 🙂 

[lbendlin · Accepted solution]

GUIDs will not be kept static. If you need static GUIDs then you need to use an external reference table that correlates your table's primary key with the external GUID.