This can be achieved in a way by using Dataverse API with the following endpoint:<\/p>\n
{environment-url}\/api\/data\/v9.0\/table_logical_name({record-id})\/column_logical_name\/$value<\/p>\n
However, this link will fail with 401 error in mobile and also if the user is not logged into Dynamics already \u2013 which is in almost all cases.<\/p>\n
But don\u2019t you worry! In this blog we will show you a workaround using Power Automate that will avoid all 401 errors that could happen.<\/p>\n
Turn your ideas into digital solutions<\/strong><\/p>\n Our team guides you step by step to build custom apps in Power Platform. Because in many cases this type of functionality\u2014where users need to reliably download files from various environments\u2014involves cross-functional planning, organizations may engage business application development services<\/strong> <\/a>to ensure the solution works smoothly across devices and contexts.<\/p> Automate tasks that slow you down<\/p>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t Free up your team\u2019s time and focus on strategic work with digital and robotic automation.<\/p>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t Start by creating a new flow and select the \u201cinstant cloud flow\u201d type and select the \u201cWhen an HTTP request is received\u201d trigger.<\/p>\n Configure trigger as follows<\/p>\n Who can trigger the flow?: Anyone<\/p>\n Method: GET<\/p>\n Relative path: {guid}<\/p>\n Use the \u201cGet row by ID\u201d action from the Dataverse connector<\/b><\/a> and pass the \u201cguid\u201d variable in the flow that comes from the trigger as \u201cRow ID\u201d<\/p>\n Add the \u201cDownload a file or an image\u201d action from the Dataverse connection, select the relevant table and column and pass the \u201cGuid\u201d variable as the value for \u201crow id\u201d.<\/p>\n Add the \u201cResponse\u201d action as the final step for the workflow. We will rename to \u201cSend file to user\u201d<\/p>\n Set up the action as follows:<\/p>\n Status code: 200<\/p>\n Headers:<\/p>\n Content-Type application\/octet-stream<\/p>\n Content-Disposition attachment;filename=\u201d{file-name-from-table}\u201d<\/p>\n Body: @{base64ToBinary(body(\u2018Download_file\u2019)?[\u2018$content\u2019])} (Power Fx expression to convert the Dataverse file from Base64 to Binary).<\/p>\n This is the code you should add in the button or icon that will download the files from Dataverse in the app:<\/p> Are you ready to discover the joy of automation?<\/p>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t Whether you have a project in mind or just want to know how we can help, we\u2019re happy to have a conversation<\/p>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t Download(HTTP_GET_URL_FROM_POWER_AUTOMATE)<\/p>\n Copy the URL from Power Automate and replace the \u201c{guid}\u201d part by the Record GUID from the Dataverse table that contains the attachment.<\/p>\n Download(Substitute(HTTP_GET_URL_FROM_POWER_AUTOMATE, \u201c{guid}\u201d,ThisItem.FileRecordID)<\/p>\n To further enhance your Power Apps experience, consider our Power platform consulting services<\/strong><\/a>. These services empower our clients to streamline app functionality while ensuring seamless file accessibility, even across various devices and environments. By integrating advanced Power Automate workflows, we mitigate potential issues such as the common 401 error. Our expertise guarantees a user-friendly and secure solution tailored to your organizational needs.<\/p>\nSolution description<\/h2>\n
\n
\n
\n
Step 1. Create Power Automate workflow<\/h2>\n
![\"Instant](\"https:\/\/powergi.net\/wp-content\/uploads\/2024\/11\/unnamed-32.png\")
<\/p>\n![\"\"](\"https:\/\/powergi.net\/wp-content\/uploads\/2024\/11\/unnamed-33.png\")
<\/p>\nStep 2. Extract file name<\/h2>\n
![\"Get](\"https:\/\/powergi.net\/wp-content\/uploads\/2024\/11\/unnamed-34.png\")
<\/p>\nStep 3. Extract file content<\/h2>\n
![\"\"](\"https:\/\/powergi.net\/wp-content\/uploads\/2024\/11\/unnamed-35.png\")
<\/p>\nStep 4. Return file to user<\/h2>\n
![\"Response](\"https:\/\/powergi.net\/wp-content\/uploads\/2024\/11\/unnamed-36.png\")
<\/p>\n![\"Column](\"https:\/\/powergi.net\/wp-content\/uploads\/2024\/11\/unnamed-37.png\")
<\/p>\nStep 5. Add Download function in Power Apps<\/h2>\n
![\"HTTP](\"https:\/\/powergi.net\/wp-content\/uploads\/2024\/11\/unnamed-39.png\")
<\/p>\n![\"Power](\"https:\/\/powergi.net\/wp-content\/uploads\/2024\/11\/unnamed-38.png\")
<\/p>\n