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
firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

FirstImage

Power Platform World Tour

Coming to a city near you

thirdimage

PowerApps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

FourthImage

Join PowerApps User Group!!

Connect, share, and learn with your peers year-round

SecondImage

Power Platform Summit North America

Register by September 5 to save $200

Users Online
Currently online: 110 members 4,525 guests
Recent signins:
Please welcome our newest community members: