DEV Community

Jacob Ladd
Jacob Ladd

Posted on

Power Automate - Dynamic Target Column in DV Update/Upload file

Hello...

Fairly new to Power Platform. I'm successfully using the Dataverse Update File event but have many columns to update individually.

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.

Currently I have an update file event buried in a switch case for each column of the DV table.

Is there a way to make this connector dynamic so that the column name could be passed from a variable or dynamic content?

Current flow:

Image description

Desired result:

Image description

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.

Image of Quadratic

Free AI chart generator

Upload data, describe your vision, and get Python-powered, AI-generated charts instantly.

Try Quadratic free

Top comments (0)

AWS Security LIVE! Stream

Stream AWS Security LIVE!

See how AWS is redefining security by design with simple, seamless solutions on Security LIVE!

Learn More

👋 Kindness is contagious

Dive into this insightful write-up, celebrated within the collaborative DEV Community. Developers at any stage are invited to contribute and elevate our shared skills.

A simple "thank you" can boost someone’s spirits—leave your kudos in the comments!

On DEV, exchanging ideas fuels progress and deepens our connections. If this post helped you, a brief note of thanks goes a long way.

Okay