Unanswered

Attach file from OneDrive to SharePoint List Item though PowerApps

(0) Share

Report

Posted on by Acruz5

I have an app where employees need to upload files to specific list items in SharePoint. Everything works well however, we have a problem where not all of our employees have local computers they just have their Microsoft Login and store their files on their OneDrive for Business. How do I have my Attachment Control point to the current user's OneDrive instead of the local computer? I've tried setting up a Power Automate work around but that doesn't work.

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Hassan_SZ_365 542 on at

Like (0)

Report
Copy link

Link copied!
Hi @Acruz5 ,
Follow These steps:
Use OneDrive Connector:
Leverage the OneDrive for Business connector in PowerApps to access files stored in users' OneDrive.
Collect File Information:
Create a collection in PowerApps to store the file information (e.g., name, link).
Attachment Control Properties:
Set the properties of the Attachment control to point to the OneDrive file using the collected information.
Power Automate (Optional):
If necessary, you can use Power Automate to automate the process, triggered by a PowerApps button, for a more seamless integration.
Here's a simplified example of Power Automate:
Trigger: PowerApps Button Get file content using path - Path: concat('/drives/', 'your-onedrive-drive-id', '/items/', 'file-id', '/content') - Output: File Content Create file in SharePoint - Site Address: Your SharePoint Site URL - Folder Path: 'your-list-name'/'list-item-id' # Adjust as per your SharePoint structure - File Name: 'file-name' - File Content: File Content
Ensure that 'your-onedrive-drive-id', 'file-id', 'your-list-name', and 'list-item-id' are replaced with the actual IDs and names in your environment.

Best Regards,
Hassan Raza

Was this reply helpful? Yes No
Acruz5 69 on at

Like (0)

Report
Copy link

Link copied!

I tried that but I must not know what to put in the call in the PowerApps. I'm having users click on a button to trigger the flow but it shows the helper text is Run(Addattachment_id, Addattachment_Filecontent). But I don't know what to put there.
AttachedFileFromOneDrive.Run(????)

Was this reply helpful? Yes No
Acruz5 69 on at

Like (0)

Report
Copy link

Link copied!

I have a variable getting the ID of the record I want to place this attachment on. So I do have that much but what do I put for the file content? I am confused.

Was this reply helpful? Yes No