How to reproduce this Form from Excel

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

I have this Excel Data entry form, Basically the user add a new Date column and input the new values

Later I take this Table and unpivot and create a normalized Table

how to approach this in Powerapps, Please notice, I am using team

thanks for your help

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Verified answer

Drrickryp Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Anonymous

The formula for the disabled textinput control is First(Sort(tasks,ID,Descending)).ID+1

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

@Drrickryp thanks a lot, for the time to build a mockup, is Collect can only add records or, it can Update records, basically if the user updated only the Quantity but kept the same date, it should updated the record not add a new one ? as the PK= ID&Date

Was this reply helpful? Yes No
Drrickryp Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

@Anonymous

Keep in mind that "tasks" is the name of an Excel table containing the field names: ID, Tasks, Quantity, and Date. As you have noted, the button will only add a new record. If you want to edit the quantity in a record, add a TextInput box and a pencil icon inside the gallery. Set the Default property of the TextInput box to ThisItem.Quantity and the OnSelect of the pencil icon to Patch(tasks, ThisItem, {Quantity:TextInput2.Text*1}). This will allow the user to change the quantity without changing any of the other fields. If you wanted to remove that record, then you could put a trash icon into the gallery and set its OnSelect to Remove(tasks, ThisItem).
Please note that the button to add new records is outside the gallery while the ones that select a record to modify or remove are inside the gallery.

Was this reply helpful? Yes No