How to remove duplicate app

If you followed the instructions included within that dialog box and tried upgrading macOS and failed, and then tried removing all OneDrive installs and restarting macOS and then tried your macOS install again, then contact Microsoft Support or the Microsoft discussion forums assistance with their app.

Forums? Microsoft also has forums for Microsoft apps, and those Microsoft forums are usually a better spot for questions and issues involving Microsoft products and services.

Other options available here include migrating to alternative apps or services and replacing OneDrive, or migrating to Microsoft Windows and running the Microsoft tools native.

Logs or Apps? If you select one of them and press Command+i, what does the Get Info window say they are? Posting a screen shot would be helpful.

What duplicate app?

Sorry, where are you seeing these? There is no iCloud app per se.

Okay. First, OneDrive is not iCloud. Second, you cannot delete the one that is open. That's why it asks you to check which one is open. Last, check on https://support.microsoft.com/en-us/onedrive