Answered

Help with multivalue (MS Forms, PowerAutomate, MS Lists, Power BI)

(0) Share

Report

Posted on by TLR

Hi all. I'm at the very start of my learning journey and am not having any luck finding exactly what I need to do to solve my problem. Here's the deal...

I have a MS Form that is connected to Power Automate to transfer the data submitted to a MS List. I then use this data from MS Lists for reporting via Power BI. One of the questions in my MS Form is multiple choice (it's a list of teams).

In my Power Automate set up, it's showing this question as this (Create Item)...

The data in my MS List displays as this and within MS Lists, I am able to filter by the individual team

However, when I try to display or filter by individual team in my Power BI report, I can't and it groups everything. It's also showing as 'Text' type when I try to Transform Data rather MultiValue.

From what I've read, it has something to do with how I've set it up in Power Automate. Please help!

Categories:

General topics

I have the same question (0)

All responses (3)

Answers (1)

v-yueyun-msft on at

Like (0)

Report
Copy link

Link copied!

Hi , @TLR

According to your description , do you mean you want to save the "Impacted Teams" column in your list as choices?

First, is your "Impacted Teams" column Choice type in your side? Can you show me your column setting in your side?

And in your screenshot , it seems get the string type data in your Power BI like :
["Team1","Team2"]

What's the data you want to extract in your Power BI side? Even though it get the String type in Power BI , in my thought , it can be converted by Power Query.

And can you show the output of the "Get response details" action and which field you want to get in your side/

Best Regards,

Yueyun Zhang

Was this reply helpful? Yes No
TLR 7 on at

Like (0)

Report
Copy link

Link copied!

Hi @v-yueyun-msft

Yes, the column setting is 'Choice' - see below

Basically - I want to do this... How to work with SharePoint Multi-value Columns in Power BI - Marquee Insights

At the moment when I use a bar chart to display the impacted teams in the report it displays them grouped by whatever team was selected and I'm not able to just select one team.
Put simply, I want to be able to select one team to display the impact of that one team (which I can do in Lists, but not Power BI)

Was this reply helpful? Yes No
Verified answer

v-yueyun-msft on at

Like (0)

Report
Copy link

Link copied!

Hi , @TLR

Thanks for your response! So in my understanding, Is your problem caused by a multi-select column error that Flow runs to save for, the correct situation is to save as multi-select, but you are now saving as text?

This is my test sahrepoint column and the end result:

In my Compose action is used to create the test array:

The Select and the Create item action:

If this reply can help you , you can click mark this reply as solution (Accept solution) which can help more people, thanks in advance!

Best Regards,

Yueyun Zhang

Was this reply helpful? Yes No