Patch Task table in a command bar button on a custom table

(1) Share

Report

Posted on by Ellen Heijmans

I have a custom table and an MD app. Now I want to create a command bar button (main form) that adds a record in the Task table. But when I use the function Patch I cannot choose the table Tasks, it's not visible.

I've created a relationship between my custom table and the tasks table. Published everything. Added the task table to the MD-app. But nothing works.

How can I create a task from a command bar button from a custom table?

Any help is appreciated.

Categories:

Power Apps Pro Dev & ISV

I have the same question (0)

All responses (3)

Answers (0)

Sort by

CU01080920-0 2 on at

Like
a
(0)

Report
Copy link

Link copied!

Anyone?

Was this reply helpful? Yes No
Suggested answer

PANow 6 on at

Like
a
(0)

Report
Copy link

Link copied!

Ensure that the Tasks table is in the component library data sources. You can select Open Component Library from he top right near the publish button when editing a button. When viewing the library, it's the same experience as a canvas app builder, without the canvas.

Was this reply helpful? Yes No
Suggested answer

deepakmehta13a 369 on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @Ellen Heijmans,

The reason you cannot see the Tasks table in your Patch function is that it hasn't been added to the command's data context, even if it is part of your Model-Driven App.

To fix this using Power Fx:

Open the Command Bar Editor for your main form.

In the top menu, select Open Component Library.

Once the library opens, go to the Data tab on the left.

Click Add data and search for the Tasks table.

Save and Publish the library, then go back to your command bar and the Patch(Tasks, ...) formula will now be recognized.

Alternative: Using JavaScript
If you prefer not to use Power Fx, you can use a JavaScript Web Resource. This is often more flexible for creating related records without navigating away from the page.

✅If this helped, please Accept as Solution to help others ❤️ A Like is appreciated

Was this reply helpful? Yes No