Unanswered

Creating a field value based on other fields in a form (Model driven app)

(0) Share

Report

Posted on by GreenPowerBI

Hi, i have created an form where i have the primary name field and 3 lookup fields to othertables: Contract (not null), Product (not null), subproduct(null)

I want the primary name field to be created based on the chosen lookup fields - so it becomes sort of a unique field. can anyone help me on how to accomplish this in a model driven app ? if the answer is Javascript i might need help to write it.

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Nogueira1306 7,390 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Set the Default of that field to the 3 LookUps you make.

EXAMPLE:
LookUp(Contract; ID = 1) & "-" & LookUp(Product; ID = 1) & "-" & LookUp(SubProduct; ID = 1)

If you need additional help please tag me in your reply and please like my reply.
If my reply provided you with a solution, pleased mark it as a solution ✔️!

Best regards,
Gonçalo Nogueira

Check my LinkedIn!

Check my User Group (pt-PT)!

Last Post on Community

My website!

Was this reply helpful? Yes No
GreenPowerBI 16 on at

Like (0)

Report
Copy link

Link copied!

Thank you for the reply @Nogueira1306 .

This would also be my solution if i was working on a canvas app, did not think it would work in a model driven app. where is it possible to write Power fx for default values in model driven apps?

Was this reply helpful? Yes No
GreenPowerBI 16 on at

Like (0)

Report
Copy link

Link copied!

UPDATE.

i managed through workflow to set conditions (see pictures)

But when i create a record, it only insert Contract and not Product or subproduct. does anyone know what i am doing wrong ?

Was this reply helpful? Yes No