Answered

Converting list of choices from PowerApps into multi-choice column entry in dataverse

(0) Share

Report

Posted on by AB-03121629-0

Hello! I'm trying to make an application in PowerApps that will ask the user to select multiple items in a combobox that is tied to a Dataverse "Choices" entity. I will then trigger a Power Automate flow, exporting the list of choices (Currently as a JSON, but I am open to suggestions). I need some way for Power Automate to use the JSON it receives to populate a multi-choice column of a new Dataverse row. Currently, I am running into the issue where Power Automate takes the list and creates new row entries for each multi-choice item. I want just one new row entry. Thanks in advance!

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Michael E. Gernaey 53,963 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Hello @AB-03121629-0

The reason is you are not actually binding multiple choices to a row, you are binding a single row in your Array (JSON) so it creates many.

It would help to see what your JSON looks like. Also are you passing the Values or Strings to Power Automate?

Was this reply helpful? Yes No
AB-03121629-0 70 on at

Like
a
(0)

Report
Copy link

Link copied!

@Michael E. Gernaey the binding is only occuring on the powerapps side. The Combobox generates options from the Choices list (titled "Tags"). When the user selects a few options (e.g. 2) and presses the submit button, the JSON that gets sent looks like this:

[{"Value":596770000},{"Value":596770001}]

These values correspond with my choices in dataverse. However, I cannot figure out how to put these values into the "job_tags" section of my "add a new row" item without errors

Was this reply helpful? Yes No
Verified answer

AB-03121629-0 70 on at

Like
a
(0)

Report
Copy link

Link copied!

To anyone looking at this in the future, I found the solution.

1. Initialize a new empty array variable

2. Use an "Apply to Each" loop which iterates over Body

3. Inside the loop, use an "Append to Array Variable" to append the Value (from JSON) to TagArray - not the current item

4. In Add New Row field, use join(variables('YourNewArray'), ',')

1 people found this reply helpful.

Was this reply helpful? Yes No