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
| 3300235 | Consulting | Consulting Projects. |
| 3300236 | Marketing | Need to do more marketing |
| 3300237 | Events | Organiza a events |
| 3300238 | Research | POC needs to be done |
| 3300239 | Project | New 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
| 3300235 | Consulting | Consulting Projects |
| 3300235 | Consulting | Consulting Projects are not always short |
| 3300236 | Marketting | Need to do more marketing |
| 3300237 | Events | Organiza a events |
| 3300238 | Research | POC needs to be done |
| 3300239 | Project | New Projects are coming up |
Please let me know how to achieve this .
appreciate your help in advance.