Hola.
Tengo una lista en sharepoint que esta asociada a un powerapps y necesito saber la formula poner en el Boton "liquidar nave" para que los valores del 'Estado de liquidacion' cambie "Ingresado" a "liquidado" segun el IDNaveViaje, se puede usar patch pero hasta ahora no me funciona.
La lista origen se llama 'Ingresos CT'
Solved! Go to Solution.
Hello @pzumi ,
If the type of 'Estado de liquidacion' in the SharePoint list is a string, then you can use the expression below to replace it:
If ( Not(IsBlank(LookUp('Ingresos CT'; IDNaveViaje = Value(TextInput1.Text)))); Patch( 'Ingresos CT'; LookUp('Ingresos CT'; IDNaveViaje = Value(TextInput1.Text)); { 'Estado de liquidacion': "Liquidado" }))
Where 'TextInput1' is the name of the text input that contains the 'IDNaveviaje a liquidar'. You would use a LookUp to find the record to be updated, then pass as the third parameter of the LookUp expression the change that you want made.
Hello @pzumi ,
If the type of 'Estado de liquidacion' in the SharePoint list is a string, then you can use the expression below to replace it:
If ( Not(IsBlank(LookUp('Ingresos CT'; IDNaveViaje = Value(TextInput1.Text)))); Patch( 'Ingresos CT'; LookUp('Ingresos CT'; IDNaveViaje = Value(TextInput1.Text)); { 'Estado de liquidacion': "Liquidado" }))
Where 'TextInput1' is the name of the text input that contains the 'IDNaveviaje a liquidar'. You would use a LookUp to find the record to be updated, then pass as the third parameter of the LookUp expression the change that you want made.
User | Count |
---|---|
251 | |
251 | |
82 | |
45 | |
29 |
User | Count |
---|---|
343 | |
264 | |
129 | |
69 | |
57 |