The latest articles on DEV Community by Jacob Ladd (@snoproladd). https://dev.to/snoproladd https://media2.dev.to/dynamic/image/width=90,height=90,fit=cover,gravity=auto,format=auto/https:%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Fuser%2Fprofile_image%2F3080886%2Fe45f162a-3e7f-4433-8d25-2e11bef48daf.png https://dev.to/snoproladd en Jacob Ladd Fri, 25 Apr 2025 14:45:03 +0000 https://dev.to/snoproladd/power-automate-dynamic-target-column-in-dv-updateupload-file-15pp https://dev.to/snoproladd/power-automate-dynamic-target-column-in-dv-updateupload-file-15pp <p>Hello...</p> <p>Fairly new to Power Platform. I'm successfully using the Dataverse Update File event but have many columns to update individually.</p> <p>The flow compares some data, fetches a QR code where it needs to, then saves the QR to a Sharepoint folder and a DV table.</p> <p>Currently I have an update file event buried in a switch case for each column of the DV table.</p> <p>Is there a way to make this connector dynamic so that the column name could be passed from a variable or dynamic content?</p> <p>Current flow:</p> <p><a href="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Farticles%2Fpcb7vdtj0ku32c9k0ebq.png" class="article-body-image-wrapper"><img src="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Farticles%2Fpcb7vdtj0ku32c9k0ebq.png" alt="Image description" width="800" height="267"></a></p> <p>Desired result:</p> <p><a href="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Farticles%2Fb8erwu5b6t1wgc0argax.png" class="article-body-image-wrapper"><img src="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Farticles%2Fb8erwu5b6t1wgc0argax.png" alt="Image description" width="564" height="518"></a></p> <p>Any help would be appreciated. I have a working version of this flow, its just SLOW...trying things to speed up both working on it and its actual run. Currently just modifying it is slow as all of those switch cases (36) are resource hogs in a browser.</p> powerplatform powerautomate