Update

How to Use the Power Fx Update  Function in Power Apps

What is the Power Fx Update Function?

The Power Fx Update function is used to update data in a record or collection in Power Apps. It is a simple and straightforward function that allows users to modify existing data in real-time. The function can be used to update individual fields in a record or update multiple records at once.

How to Use the Power Fx Update Function

To use the Power Fx Update function, you need to follow these steps:

1. Open Power Apps and select the app you want to work on.

2. Go to the screen that contains the data you want to update.

3. Select the control that contains the data you want to update.

4. Go to the Properties tab and select the OnSelect property.

5. Enter the following code in the formula bar:


Update([DataSource], {ID: ThisItem.ID, FieldName: NewValue})


6. Replace [DataSource] with the name of your data source.

7. Replace ID with the name of the field that contains the record ID.

8. Replace FieldName with the name of the field you want to update.

9. Replace NewValue with the new value you want to set for the field.

Updating Multiple Records

If you want to update multiple records at once, you can use the ForAll function in combination with the Power Fx Update function. To do this, follow these steps:

1. Open Power Apps and select the app you want to work on.

2. Go to the screen that contains the data you want to update.

3. Select the control that contains the data you want to update.

4. Go to the Properties tab and select the OnSelect property.

5. Enter the following code in the formula bar:


ForAll([DataSource], Update([DataSource], {ID: ID, FieldName: NewValue}))


6. Replace [DataSource] with the name of your data source.

7. Replace ID with the name of the field that contains the record ID.

8. Replace FieldName with the name of the field you want to update.

9. Replace NewValue with the new value you want to set for the field.

The Power Fx Update function is a powerful tool that enables users to update data in a record or collection in Power Apps. It is a simple and straightforward function that can be used to modify existing data in real-time. By following the steps outlined in this article, you can easily use the Power Fx Update function to update data in your Power Apps application.

Power Apps Training Courses by G Com Solutions (0800 998 9248)