PowerApps Write Back to Excel

Hi Williams25k

I have written quite extensively about write-back to Power BI from Power Apps:

Guide: Add Write-Back to Power BI reports with Power Apps – Part 2: Display write-back data LIVE in Power BI reports – Downhill Data

Fabric/Power BI Write-Back made easy w. Fabric SQL Databases – Downhill Data

The key question is whether or not you need the data to show up in your report live, or if you can wait until after a refresh?

If you can wait for the refresh, your best option is a Sharepoint List, which will minimize license costs, as you won't need Premium Power Apps.

If you need live data, you need a Premium Data Source, like a SQL Database or Dataverse, and connect via DirectQuery in Power BI.

For more info, check out the links above for some of the options.

_____________________________________________________
I hope my comment was helpful.
If your question was answered, please mark your post as 'Solved' and consider giving me a 'Thumbs Up'.
Find me on LinkedIn, Sessionize, or my blog Downhill Data

Hi Williams25k,

Thank you for reaching out in Microsoft Community Forum.

please follow below ways to resolve the error;

1. Use a SharePoint List to store and update patient data instead of Excel.

2. Create a Power Apps form to edit the "Spoke to Patient" field and write back to SharePoint.

3. Refresh Power BI using Scheduled Refresh or Power Automate to reflect updates.

Please continue using Microsoft community forum.

If you found this post helpful, please consider marking it as "Accept as Solution" and give it a 'Kudos'. if it was helpful. help other members find it more easily.

Regards,
Pavan.