I have a Sharepoint list in which I gather information and store into this list. A few columns are of type Hyperlink that are linked to spreadsheets stored on OneDrive. I created these by using the 'Create share link' from another flow and adding it to Sharepoint using a HTTP POST.
The issues now is I would like to run a cleanup job and for the Sharepoint list rows I want to process for deleting and need to use these Hyperlinks and derive a OneDrive File Id in order to delete the files referneced to by the link. I have tried about all I can find on the internet. I just cannot seen to reverse this process.
I think the easiest thing to do would be to add another column to your SharePoint list named FileId. When you populate the list with the link, also populate the file ID at the same time. The you can use this field for your cleanup process.
Was this reply helpful?YesNo
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.