Write Back data from PowerBI to SharePoint

(0) Share

Report

Posted on by Sharmilshah

Hi all,
I'm working on a Power BI report where users need to update a SharePoint list by clicking a Power Automate button. I have everything working when values are selected from slicers or table visuals (like Request ID, Status, etc.).
However, I'm stuck on how to let the user enter free text input (like a comment) and pass that into the Power Automate flow.

⚙️ Setup so far:

Power BI visual has fields: RequestID, Status (from slicer)
Power Automate visual is configured and updates SharePoint successfully when using predefined values
No Power Apps is being used — I want to keep everything inside Power BI

🧩 Problem:

There's no native free text input in Power BI
I can't figure out how to let the user type a custom comment and pass it to the flow
Tried using slicers or prebuilt tables, but they only support static values

Is there any workaround or clean way to collect user-entered text (like a comment) inside Power BI and pass it dynamically into a Power Automate flow?
Appreciate any help or best practices!
Thanks!

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (0)

Suggested answer

Tomac 3,966 Moderator on at

Like (0)

Report

The user won't be able to enter text into Power BI because it parses data, not collect it.

If you're using Teams, you can send the user an adaptive card to collect a response:

Then use the response to this action as your comment field when updating SharePoint

If this resolved your issue, please mark it as the answer.

Was this reply helpful? Yes No
lbendlin 8,479 Super User 2025 Season 2 on at

Like (0)

Report
a Power BI report where users need to update a SharePoint list by clicking a Power Automate button.

That will result in an unsatisfactory UX as the Power BI user will not get any feedback if their write action was successful.

Instead consider a PowerApp visual with a Direct Query data source (requires additional licenses) or Translytical Task Flows in Fabric with User Data Functions.

Was this reply helpful? Yes No