Power Apps Integration - Default Value

[Selwynster]

Hi

I have a fairly simple integration that works fine. I'm just struggling adding a default value to a power apps text box instead of the user having to capture it in (when adding a new record in power apps).
The 2 visuals below refer: (On the left is a normal table visual, on the right is the power apps visual)

Please  help with the needed power apps code (something along the lines of Gallery1.Selected maybe?)

[Anonymous]

Hi @Selwynster ,

For either type of form, you set its DataSource property to a table of records, and you set the form's Item property to show a specific record in that table.

If you add a Gallery control, you can configure it to show a table in a data source and then configure a form to show whichever record the user selects in the gallery. You can also add one or more Button controls that the user can select to save edits, cancel edits, and create a record. 

More details : Edit form and Display form controls in Power Apps 

The Last function returns the last record of a table.

See: First, FirstN, Last, and LastN functions in Power Apps 

Best Regards

Community Support Team _ Polly

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Selwynster]

Thanks @Anonymous , the problem is there is no record to select in the gallery, because it is a different dataset. So I cant use Gallery1.selected
It looks like i may have to create a view in the Database that does a left join to the other table, and then bring that field into the Powerapps visual. 🙄

[Anonymous]

Hi @Selwynster ,

Please refer to the following steps to see if it helps you.

Assuming the table on the left is the data source for Apps, and go to the items property of the Gallery to fill it. Then Set the properties of the table on the right to Gallery1 Selected. And set the data source for this table to the table on the left.

Please refer to the following document to see if it helps you.

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/add-form

Best Regards

Community Support Team _ Polly

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Selwynster]

Thanks @v-polly-msft , but the table on the left is a seperate Data source altogther.