Power automate trigger in power bi to SharePoint list

[Imran1]

Hi Forum, 

I have created a dashboard with a table that shows detailed columns for multiple clients and is shared with specific users. What we are trying to achieve is creating a automate trigger, where if a user selects muliple rows on the table with the same client ID, the trigger will basically concatenate all the specific data (seperated by comma) in its specific columns and create a list on SharePoint. 

I am very new to automate and am trying to understand how things work, but it is not clear to me, as i am having trouble with the creating that first connection to when a user selects the rows and then clicks the trigger button which basically filters the array and populates the Sharepoint list on 1 row only 


If this is not possible then i can understand. 

Thanks in advance for the support. 

[christinepayton]

There's not a trigger for when an item is selected in Power BI - you'd need to use the Power Automate visual, which is a button, to trigger it on selected rows. I don't know what you mean populates the data into only one row - when it sends the data to Power Automate, its going to be one row for each thing selected in your table, if you want it to push that to a single row in a list you'd need to concatenate the values in the rows into a string. You can do that with an append to string variable in a loop on the rows. 

[Imran1]

Apolgies if i did not explain myself clearly.

As i was creating the flow on power automate I have managed to successfully get the rows into the sharepoint list but currently it is coing as individual rows. 

So we selected 3 rows on the power bi dashboard(table) and clicked the trigger button which starts the automate flow which basically created a item on share point list as 3 rows. But my goal is to take the 3 rows and the output should become 1 row on the sharepoint list.

Currently i have a filter array which pulls the selected data and is filtered by "Customer Name"

the next step was siple apply to each to check if the data is passing through to the list, which it is. I selected 3 different items with the same custromer name and then the output in share point simply created 3 different rows. 

I am trying to figure out how to take the filer array output and concat each of its columns accordingly and seperate any unique values with a "," 

Im thinking either join or creating Select Data aoperation to individually define each column and concat as needed. 

again sorry if this seems confusing i am new to this and learning as i go. 

[christinepayton]

Just loop over the rows and use "append to string variable" - that'll get it all in a text block. You can insert characters like a comma or whatever else in that action after the cards you insert, and do a line break at the end (hit enter on keyboard in the text window) so that when it loops it adds a new line to the string for each item. 

[Anonymous]

Hi, @Imran1 

Do you currently have this issue resolved? Would you mind sharing the current process you have and the actions you are doing, in my understanding the requirements you want are difficult to implement and more testing needs to be done.

Best Regards,
Yang
Community Support Team

[Imran1]

So after researching a lot its not difficult but its not easy, i need to figure out how to take the selected arrays and concat each of the values within its respected column to create 1 row in the share point  list with the respective value.

Example:
10 different columns but the specific we want is "Customer_Name" "Date" and "Exception" 
so the user selects 3 rows with the same customer name, each row has a different date and only 1 differnent exception

Input
[
  Customer1, Date1, Exception1
  Customer1, Date2, Exception2
  Customer1, Date2, Exception1
]

Output onto sharepoint should be 

Customer_Name:  Customer1
Date: Date1, Date2, Date3
Exception: Exception1, Exception2
The above are column names which are defined and available on the apply to each  operation when adding the create list to sharepoint operation