How to bind Editable Gallery Fields with Functions to the Source Columns

(0) Share

Report

Posted on by Finnair

255

I have created an Editable "Grid" with Gallery and plain TextInputs inside it (no Form or DataCards are used).

It went well with written values since the "Default" of the Fields are "ThisItem.SourceColumn1.

But when I need to have a formula in a Field, it gets logically complicated. So, if my CalculatedField1's formula is "SourceColumn1 + SourceColumn2", I can write "SourceColumn1 + SourceColumn2" to CalculatedField1's "Default". But how then I bind the filed to the Source?

I've been thinking it must be done with variables.

Categories:

Building Power Apps

All responses (3)

Answers (0)

Sort by

iAm_ManCat 18,256 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Is this a calculated field in SharePoint? If yes, then you don't need to create/patch these (can't), they will be auto-generated by SharePoint when you submit the rest of the row's columns.
Finnair 255 on at

Like
a
(1)

Report
Copy link

Link copied!

thanks @iAm_ManCat

No. The data source is Dataverse. My intention was to calculate the field value in field's "Default". But now I wonder should I do it in Dataverse?
iAm_ManCat 18,256 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Ok, so I imagine you have hidden the datacard so that the users can't accidentally update it and change the calculated value - in your Update property of the datacard it should be pointing to the TextInputFieldName.Text (the control we are changing the default value for)

For the Default, I'm guessing you don't want it to keep updating every time? And this would be for both new items and existing items, so you can't refer to the fields themselves as those won't have values for any new items that haven't been saved yet, so you would refer to the Control name itself that fills that value currently like:

If( //Check if there's already a value in this item IsBlank(Parent.Default), //If not then make it the sum of these ftwo fields as per form SourceColumn1ControlName.Text + SourceColumn2ControlName.Text, //Otherwise retain the existing value, no need to update Parent.Default )

But if you want it to always calculate a new value (i.e. if the inputs its based on are likely to change) then you only need:

SourceColumn1ControlName.Text + SourceColumn2ControlName.Text