Answered

Patch function not accepting .Default

(0) Share

Report

Posted on by Eric18

Hi all,

With very limited experience I'm trying to get belowmentioned patch function to work. Unfortunately, the formula would not accept .Default for my Owner_DataCard1-field coming from the form I'm pulling it from.

Can anyone see what I'm doing wrong here? As far as I can see (again, very limited experience) it should behave identical to the Identifier_DataCard1-field which is working fine.

Thanks a lot in advance!

Patch(CommentDataTable1,
 Defaults(CommentDataTable1),
 {Submitter: fetchFullName.Text, Comment: tb_Comment.Text, DocID: Identitfier_DataCard1.Default, DocOwner: Owner_DataCard1.Default}
)

Eric

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (2)

Sort by

LaurensM 12,516 Moderator on at

Like (0)

Report
Copy link

Link copied!
Hi @Eric18,

You can reference the Selected Owner by referencing the combobox within that DataCard. That removed the error on my end.

//Change to the correct owner combobox name DataCardValue.Selected

If this solves your question, would you be so kind as to accept it as a solution & give it a thumbs up.

Thanks!

Was this reply helpful? Yes No
WarrenBelz 155,291 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @Eric18 ,

Datacard.Default is not a valid Patch parameter - what value are you actually trying to Patch - use the actual Default Value instead.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No
developerAJ 4,763 on at

Like (0)

Report
Copy link

Link copied!
Patch(CommentDataTable1, Defaults(CommentDataTable1), {Submitter: fetchFullName.Text, Comment: tb_Comment.Text, DocID: Identitfier_DataCard1.Text, DocOwner: Owner_DataCard1.Selected} )

Use this formula

Was this reply helpful? Yes No
Eric18 17 on at

Like (0)

Report
Copy link

Link copied!
First of all, thanks for all your replies. Unfortunately though, for me changing what I had

Patch(CommentDataTable1, Defaults(CommentDataTable1), {Submitter: fetchFullName.Text, Comment: tb_Comment.Text, DocID: Identitfier_DataCard1.Default, DocOwner: Owner_DataCard1.Default} )
to
Patch(CommentDataTable1, Defaults(CommentDataTable1), {Submitter: fetchFullName.Text, Comment: tb_Comment.Text, DocID: Identitfier_DataCard1.Default, DocOwner: Owner_DataCard1.Selected} )
does not solve the problem.

What I'm trying to do is to enable people to log a comment on a certain document on our sharepoint and write these comments to an Excel file. Therefore I made a connection to this sharepoint list and I pull the fields; Identifier and Owner. This together with the actual comment that users fill and the user's full name, I try to patch that to the beforementioned excel file on OneDrive.

All these fields now patch correctly, except for Owner_DataCard1. I expected it to behave exactly the same as the Identifier one (I'm aware of the typo there which is in the sharepoint list), but the Owner one would not work with .Default. Also, .Selected would throw the same error.

Hopefully I explained it sufficiently. Thanks a lot in advance again.
Eric

Was this reply helpful? Yes No
Verified answer

developerAJ 4,763 on at

Like (1)

Report
Copy link

Link copied!
Patch(CommentDataTable1, Defaults(CommentDataTable1), {Submitter: fetchFullName.Text, Comment: tb_Comment.Text, DocID: Identitfier_DataCard1.Text, DocOwner: Owner_DataCard1.Selected.DisplayName} )

try this or Select any field after ownerdatacard1.Selected. (similar to displayName)

Was this reply helpful? Yes No
Verified answer

LaurensM 12,516 Moderator on at

Like (1)

Report
Copy link

Link copied!

Hi @Eric18,

Could you try referencing the Combobox within the Datacard. DataCardValue.Selected (change to the correct came).

On my end, this fixed the error when using a column of type person.

If this solves your question, would you be so kind as to accept it as a solution & give it a thumbs up.

Thanks!

Was this reply helpful? Yes No
Eric18 17 on at

Like (0)

Report
Copy link

Link copied!
Thanks developerAJ and LaurensM,

A mix of both your comments actually solved this for me. I'm very grateful!

Eric

Patch(CommentDataTable1, Defaults(CommentDataTable1), {Submitter: fetchFullName.Text, Comment: tb_Comment.Text, DocID: Identitfier_DataCard1.Default, DocOwner: DataCardValue3.Selected.DisplayName} )

Was this reply helpful? Yes No