No answer to my canundrum as yet.
But, I'm gonna keep swinging for the fences...my S.F. Giants are in 1st Place! :smiling_face_with_sunglasses:
I have a Library full of existing documents I inherited. New documents are added through PowerApps everyday.
I have a List that has meta data specific to the existing documents and those newly uploaded to the Library and the Members those document are associated with.
Both the Library and the List have a column called 'CQUnqID'.
I have manually pre-populated the column in both for all existing documents and created a calculation in the Library that automatically auto-populates the specific and unique 'CQUnqID' along side the doucment whenever a new document is created in the Library.
My issue; where a document with the 'CQUnqID' being upload from PowerApps already exists in the Library the Flow adds a 'new' document with a bad extension that is useless.
I need an edit to the Flow that first, based on the 'CQUnqID' of the current document being created in the Library, deletes the existing file in the Library that matches that 'CQUnqID' coming in from the upload action.
Then, the rest of the flow, creating the new file, can continue.
How do I get that new 'CQUnqID' from the Patch/List into the current action and Flow so that that existing file is deleted and a new one allowed to be created in the Library?