The data source supplied to the function is invalid.

(0) Share

Report

Posted on by IPC_ahaas

1,401 Moderator

My Scene has OnVisible

Set(VarSection,"");
ClearCollect(
 ColSessions,
 {
 Session: "",
 Section: "",
 Site: ""
 }
);

My Button has OnSelect

If(
 CountRows(Filter(ColSessions,Section = VarSection)) < 1,
 Set(VarSession,GUID())
);

Patch(
 ColSessions,
 {
 Session: VarSession,
 Section: VarSection,
 Site: VarSite
 }
 )
);

This works after the first press, but the second press has an error on the Patch saying " The data source supplied to the function is invalid."

Categories:

Building Power Apps

All responses (3)

Answers (1)

Sort by

v-yueyun-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi , @IPC_ahaas

Do you mean you want to add the record in your "ColSessions" collection?

If this , you can try to use this code:

If( CountRows(Filter(ColSessions,Section = VarSection)) < 1, Set(VarSession,GUID()) ); Patch( ColSessions, Defaults(ColSessions ), { Session: VarSession, Section: VarSection, Site: VarSite } );

Patch(datacource/colllection , Derfaults(datacource/colllection),record)

And for more information, you can refer to :
Patch function (contains video) - Power Platform | Microsoft Learn

Best Regards,

Yueyun Zhang
IPC_ahaas 1,401 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

With that, I get:

"Unexpected charterers. Characters are used in the formula in an unexpected way."

on the last closing parenthesis.
Verified answer

v-yueyun-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi, @IPC_ahaas

It seems your code has one more ')' in the end of the code.

Best Regards,

Yueyun Zhang