web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Power Apps - Power Query
Unanswered

Data is not saving

(1) ShareShare
ReportReport
Posted on by 42
icon onselect:  Set(VarytdResults,AutomaticResultsandYTDDisplayflow.Run(ThisItem.'Measure ID',ThisItem.Scope.Title,Text(ThisItem.'Modified On', "yyyy-mm")).ytd);
Patch(
    colTest,
    LookUp(colTest, 'Objective ID' = ThisItem.'Objective ID'),
    { YTDJulX: VarytdResults }
);   sumbit button icon Onselect:If(
    CountRows(
        Filter(
            colRowMonthData,
            UnitType = 0
        )
    ) = 0,
    ForAll(
        colRowMonthData As Alpha,
        Patch(
            Objectives,
            LookUp(
                Objectives,
                'Objective ID' = Alpha.'Objective ID'
            ),
            {'Result jul':
If(
                    Alpha.Unit <> Unit.text,
                    Value(Alpha.ResultJul.Text),
                    Blank()
                )
,
                'Result jul t': If(
                    Alpha.Unit = Unit.text,
                    If(IsBlank(Alpha.'Result jul'),fallbackResultJul,Value(Alpha.ResultJul.Text)),
                    Blank()
                )}) textinput default:Switch( Text(ThisItem.Frequency),"Quarterly","","Monthly",If(IsBlank(ThisItem.'Result jul'),
ThisItem.ResultJulX,
ThisItem.'Result jul'),"Yearly", "") app onsart:ClearCollect(
    colTest,
    AddColumns(
        colObjectivesData,
        ResultJanX,"",
        ResultFebX,"",
        ResultMarX,"",
        ResultAprX,"",
        ResultMayX,"",
        ResultJunX,"",
        ResultJulX, "",
        ResultAugX, "",
        ResultSepX,"",
        ResultOctX,"",
        ResultNovX,"",
        ResultDecX,"",
        YTDJanX,"",
        YTDFebX,"",
        YTDMarX,"",
        YTDAprX,"",
        YTDMayX,"",
        YTDJunX,"",
        YTDJulX,"",
        YTDAugX,"",
        YTDSepX,"",
        YTDOctX,"",
        YTDNovX,"",
        YTDDecX,""
    )
);
If the txt input is blank am filling the value with icon after that save the value using submit button. Am getting the fallback Result Jul but it is not assigning to 'Result Jul' or 'Result Jul t'?
Categories:
I have the same question (0)
  • WarrenBelz Profile Picture
    149,311 Most Valuable Professional on at
    Data is not saving
    This earlier thread may give you some insight (possibly)
  • Michael E. Gernaey Profile Picture
    47,123 Super User 2025 Season 2 on at
    Data is not saving
     
    Can you please do a better write up of what the code is supposed to do please.
     
    its pretty jumbled and would like to know what I am looking at as it makes it easier,
     
    I do thank you for posting it all though!! it helps :-)
     
    Cheers

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Telen Wang – Community Spotlight

We are honored to recognize Telen Wang as our August 2025 Community…

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 637 Most Valuable Professional

#2
stampcoin Profile Picture

stampcoin 570 Super User 2025 Season 2

#3
Power Apps 1919 Profile Picture

Power Apps 1919 473

Featured topics