I am finishing up my self contained Test Drive version of our company's PowerApp, so i have to keep all data local.
So far i'm having no trouble with Collect(), but in some cases, I'd like to explore persisting data in Excel.
however, when i use code like this:
UpdateContext({row: First(Filter(Data, Datum="SafetyTeam"))});
Patch(
Data,
row,
{Value: row.Value + 1}
)
I get an errors like this:
"The first argument of 'Patch' should be a collection" (No, according to the docs, it should be a Data Source)
"The type of this argument 'Value' does not match the expected value of 'Hyperlink.'" Found type 'Number'. (really, well this code does not report that last error (SafetyIndex here is, indeed, a collection)
UpdateContext({rec: First(Filter(SafetyIndex, Label = "Member"))});
Patch(
SafetyIndex,
rec,
{Weight: rec.Weight +1}
);
)
rookie error (again)?
