Power Platform Community Forum Thread Details

icon onsect used this code :Set(VarJanYTD,AutomaticResultsandYTDDisplayflow.Run(ThisItem.'Measure ID',ThisItem.Scope.Title,Text(ThisItem.'Created On', "yyyy-mm")).results);

//If(!IsBlank(VarJanResults),Set(varRes,Patch(varRes,{Jan:true})),Set(varRes,Patch(varRes,{Jan:false})))
If(
    CountRows(Filter(colRowMonthData, 'Objective ID' = ThisItem.'Objective ID')) = 0,
    // Add new record if it doesn't exist
    Collect(
        colRowMonthData,
        AddColumns(
            Gallery2_4.Selected,
            IsChanged,
            1,
            UnitType,
            If(
                IsNumeric(VarJanYTD) && Text(ThisItem.Unit) <> "text" ,
                1,
                Text(ThisItem.Unit) = "text",
                1,
                IsBlank(VarJanYTD),
                1,0
            )
        )
    ),
    // Use Patch to update the record if it exists
    Patch(
        colRowMonthData,
        LookUp(colRowMonthData, 'Objective ID' = ThisItem.'Objective ID'),
        AddColumns(
            Gallery2_4.Selected,
            IsChanged,
            1,
            UnitType,
            If(
                IsNumeric(VarJanYTD) && Text(ThisItem.Unit) <> "text" ,
                1,
                Text(ThisItem.Unit) = "text",
                1,
                IsBlank(VarJanYTD),
                1,0
            )
        )
    )
);save button onselect: Set(
    glbVarLoadingSpinner,
    true
);

ClearCollect(
    colMyTempObjective,
    Filter(
        Objectives,
        'Objectives (Views)'.'My Objectives'
    )
);

If(CountRows(Filter(colRowMonthData,UnitType = 0)) = 0 ,
ForAll(
    colRowMonthData As Alpha,
    Patch(
        Objectives,
        LookUp(
            Objectives,
            'Objective ID' = Alpha.'Objective ID'
        ),
        {
            'Result jan': If(
                Alpha.Unit <> Unit.text,
                Value(Alpha.ResultJan.Text),
                Blank()
            ),
            'Result jan t': If(
                Alpha.Unit = Unit.text,
                Alpha.ResultJan.Text,
                Blank()
            ),
            'YTD jan': If(
                Alpha.Unit <> Unit.text,
                Value(Alpha.YTDJan.Text),
                Blank()
            ),
            'YTD jan t': If(
                Alpha.Unit = Unit.text,
                Alpha.YTDJan.Text,
                Blank()

Data is displaying on textinput but it is not saving into dataverse.

Categories:

Building Power Apps