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

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / PowerApps write to exc...
Power Apps
Unanswered

PowerApps write to excel spreadsheets /oracle database whenever description is added as a new row!!

(0) ShareShare
ReportReport
Posted on by 2

I have a requirement to

1. create a report using poweapps . 

2. Report has a field called "description" and this needs to be updated/added every time as a new row whenever i click on the project number . 

Currently I am using canvas app start from data . This is simply updating the description instead of adding a new record.

below is the sample data  and Expected behavior view.

Sample data.

Project NumberProject NameDescription

 

3300235ConsultingConsulting Projects.
3300236MarketingNeed to do more marketing 
3300237EventsOrganiza a events
3300238ResearchPOC needs to be done
3300239ProjectNew Projects are coming up

 

Now if you select Project number 3300235 and add a new description as "Consulting Projects are not always short .Report and backend table should have recorded description highlighted as below.

Expected Reports in PowerBI.

Project NumberProject NameDescription

3300235ConsultingConsulting Projects 
3300235ConsultingConsulting Projects are not always short
3300236MarkettingNeed to do more marketing 
3300237EventsOrganiza a events
3300238ResearchPOC needs to be done
3300239Project New Projects are coming up

 

Please let me know how to achieve this .

appreciate your help in advance.

Categories:
I have the same question (0)
  • KroonOfficeSol Profile Picture
    587 on at
    You can use Patch() or Collect() formula to write a new record to your datasource. And put it on the Label.OnSelect attribute.

    Hope this helps,

    Paul
  • Tn_Gartn Profile Picture
    2 on at

    I am new to Powerapps and not sure where to use patch function. is it possible to connect with you so you can guide me how to do that. 

     

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 358 Most Valuable Professional

#2
11manish Profile Picture

11manish 214 Super User 2026 Season 2

#3
Mohsin Ali Profile Picture

Mohsin Ali 185

Last 30 days Overall leaderboard