Power Platform Community Forum Thread Details

Hi,

I have this Microsoft form for users to report their monthly metrics; to make the form more user friendly I added the question, what department is this for? then using branching that department's metrics show up in a drop down.

My problem is how to set up the power automate to add a row to the scorecard metrics data table. I am trying to do it with conditions, looking for a department metric that is not empty, but it doesn't work. It will always take the If no path regardless of the department metric.

Worth noting, I have a second table Scorecard Metrics that has a list of all the metrics, goals and their departments. That is the List Rows step, it was the only way I knew of to get the other table in.

I have the create row working it is just now adding all the other departments in.