Unanswered

Patch a new record from the command bar, lookup the value in a diffrent table model-driven app

(0) Share

Report

Posted on by RobinFierens1

Hi everyone,

I need to patch a new record to the table trigger, this table has a Name and a Value. The value that I need to pass in the column Value is the value that I need to lookup from the table parameter.

Their is no relationship (lookup column) between them and it is not possible to change this since this is a legacy project.

What I would normally do in a Canvas app is the following:

With({varValue: LookUp(Parameters,Name = "parameter1" ).Value},Patch(Triggers,Defaults(Triggers),{Name:"Test",Value:varValue}))

But this is my first time ever that I need to do it from the command bar in a model-driven app and I have no idea how to do this. How can I connect to an other datasource then the datasource that I'm currently using for edditing the command bar?

I hope someone could help me 😄

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

RobinFierens1 25 on at

Like (0)

Report

After some more research I found the solution by myself via the Microsoft Documentation:
https://learn.microsoft.com/en-us/power-apps/maker/model-driven-apps/use-command-designer

Steps:
1) Click on "Open component library"
2) Go to screens
3) Go to datasources
4) Add the datasources
5) Publish app
6) You can now use these datasources in the commandbar for your model-driven app

Was this reply helpful? Yes No
CU25012207-0 17 on at

Like (0)

Report

I've added the Data table by opening the Component Library and it's now available in my model driven app.

How did you get the currently selected value from this list?

If I use First() or Last(), it works!

'Service Type': First('Service Types')

'Service Type': Last('Service Types')

But I need to clone the value from the selected record.

I've tried it these 2 ways. Both did not work

1) Lookup

'Service Type': LookUp('Service Types','Service Type (cts_servicetype)' = Self.Selected.Item.'Service Type')

2) Search

'Service Type': Search('Service Types',Self.Selected.Item.'Service Type','Service Type (cts_servicetype)')

I believe I'm very close! :)

Sanjeev

Was this reply helpful? Yes No