cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Tn_Gartn
Level: Powered On

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

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.

2 REPLIES 2
KroonOfficeSol
Level 10

Re: PowerApps write to excel spreadsheets /oracle database whenever description is added as a new ro

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
Level: Powered On

Re: PowerApps write to excel spreadsheets /oracle database whenever description is added as a new ro

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. 

 

Helpful resources

Announcements
New Ranks and Rank Icons in April

'New Ranks and Rank Icons in April

Read the announcement for more information!

Better Together’ Contest Finalists Announced!

'Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

thirdimage

Community Summit North America

Innovate, Collaborate, Grow - The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Top Kudoed Authors
Users online (3,615)