Unanswered

Patch from another database to another

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hello!

I got 2 galleries in my app with 2 different databases.

From Database1 i'm trying to patch an column to DataBase2. Those columns have the exact same options in it. Its a choice fields in an sharepoint list.

In DateBase1 i put this in on a dropdown function "OnChange" but doesnt seem to work:

Patch('Database2'; ThisItem; {Status: Dropdown3.Selected})

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

mdevaney 29,991 Moderator on at

Like (0)

Report
Copy link

Link copied!
@Anonymous

Choices fields must be patched in a special way like this:

Patch('Database2'; LookUp('Database2', ID=ThisItem.ID); {Status: {Value: Dropdown3.Selected}})

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

@mdevaney Hello and thanks for the replay.

I get this error when i'm trying your code:

The Patch function has some invalid arguments. Invalid argument type.
A record value was expected, but from a different schedule. Incompatible type.
The Value column in the data source you are updating expects a Text type and you are using a Record type.

Was this reply helpful? Yes No
mdevaney 29,991 Moderator on at

Like (0)

Report
Copy link

Link copied!
@Anonymous

Try these

Patch('Database2'; LookUp('Database2', ID=ThisItem.ID); {Status: {Value: Dropdown3.Selected.Value}})
Patch('Database2'; LookUp('Database2', ID=ThisItem.ID); {Status: Dropdown3.Selected.Value})

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

Was this reply helpful? Yes No