web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Automate
Unanswered

Write back to Excel

(0) ShareShare
ReportReport
Posted on by

Hi, 

A little background about the content. I have a excel file with 4 fields and I wanted to have the feature of writing back to the source in Power BI for which I'm getting aid of Power Apps.

 

I added the Text Input and Button and a gallery with the required fields. 

While using "PATCH" function to write back, it throws me an error.

MU2_0-1715340748421.png

 

The code used is "

Patch(AnalysisTable ,Defaults(AnalysisTable), {FiscalYear:Value(TextInput_FiscalYear.Text) , FiscalPeriod:Value(TextInput_FiscalPeriod.Text) , Business:TextInput_Business.Text , Forecast:Value(TextInput_Forecast.Text)})"
 
Appreciate any help on this
Categories:
I have the same question (0)
  • Srini007 Profile Picture
    3,327 Super User 2025 Season 2 on at

    Hi @MU2 

     

    Check below video for your reference

     

    https://www.youtube.com/watch?v=5y2jJyH4Eu0

     

    If you find this reply helpful, please consider giving it a LIKE AND

    If this reply answers your question or solves your issue, please ACCEPT AS SOLUTION

     

    Cheers,

    Srini

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 522 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 364 Moderator

#3
abm abm Profile Picture

abm abm 243 Most Valuable Professional

Last 30 days Overall leaderboard