Power Platform Community Forum Thread Details

My user is asked a series of questions which determine whether they are routed to a "new" or a "edit" form. All responses are saved and recorded on the same Sharepoint list, which contains choice columns, text columns and date columns.

My simple "new" and "edit" versions of the form work as expected.

Here is where I run into trouble-

I would also like there to be a version of the form (which the user is routed to based on dropdown selections made on previous screens) which creates a new row (form mode new), but which auto-populates and locks for editing all but a few of the fields. These should still appear on the form, and should still populate the list.

For example, if my app was about food, on one dropdown the user has already indicated their task as "baking" and on a second cascading dropdown "I want to bake pie". Suppose the entries in a "starch" column are always flour when the user is baking pie. To reduce their date entry burden, I want "flour" to appear on the form for the starch field, already grayed out, and locked for editing.

For my text fields, I achieved my desired result. First, I unlock the data card that is auto-produced, delete it, add a new text input, and set the default property to:

Concat((Distinct(Filter('SP LIST DATA SOURCE', Task = Dropdown.Selected.Result), Starch)), Result, ",")

It seems I had to add the "concat" piece to trick PowerApps into gathering the data as text, rather than pointing it to a record which breaks the logic.

This same method does not work for "choice" or "date" columns. I can delete the data card and add a new text input which filters and displays the distinct values based on the logic I need, but this does not update the column in the list when I submit the form. I've tried everything I can think of.

I can't figure out how to incorporate "date" or "choices" into the function, and it seems that the "look up" functions etc, are set up to edit an existing record, etc, not to copy information from an existing record and set that info as the default for a new record. I have too much data to manually set all of the cases (ie, If (dropdown = bake_pike {value: flour}), that's why I need to point it to the records referenced by dropdowns.

Thanks!

Categories:

Building Power Apps