Create a record and then add additional data

(0) Share

Report

Posted on by KT61

347

Hi,

Could someone help, in my app, so far i can search for a record and display in a form - (which is working, thanks to help here.),

but i wish to add information, as in work carried out to a piece of equipment, in the form

This work carried out will happen several times on the same piece of equipment.

Would also like a time stamp and record person adding data.

Thanks

Categories:

Building Power Apps

I have the same question (0)

All responses (9)

Answers (1)

Drrickryp Super User 2024 Season 1 on at

Like (0)

Report

Dataverse or SharePoint?

Was this reply helpful? Yes No
KT61 347 on at

Like (0)

Report

Dataverse using powerapp through teams

Was this reply helpful? Yes No
Verified answer

Drrickryp Super User 2024 Season 1 on at

Like (0)

Report

@KT61

You are describing a one to many relationship. Create a new table for work with a lookup to the equipment table. Include columns for the person, Date/time, type of work, etc.

Was this reply helpful? Yes No
KT61 347 on at

Like (0)

Report

Thanks @Drrickryp will try that, thanks for your help

Was this reply helpful? Yes No
KT61 347 on at

Like (0)

Report

Hi, in this case, would the work table be one to many or the equipment table.
Equipment table will have the same details every time

Was this reply helpful? Yes No
KT61 347 on at

Like (0)

Report

Hi, how do I link the work table and the Equipment table? I have a lookup column in work but it just displays the 1st column in equipment, which in my case is "TAG"

Was this reply helpful? Yes No
Drrickryp Super User 2024 Season 1 on at

Like (1)

Report

@KT61

Please see my blog posts on how to design your tables https://powerusers.microsoft.com/t5/Power-Apps-Community-Blog/Relational-Database-Principles-and-PowerApps-Step-3-Keys-and/ba-p/188640

and the follow up post on how to implement them in PowerApps https://powerusers.microsoft.com/t5/Power-Apps-Community-Blog/Relational-Database-Design-fundamentals-Implementing-a-One-to/ba-p/200521

Was this reply helpful? Yes No
KT61 347 on at

Like (0)

Report

Thanks @Drrickryp very good reading,
You state "All tables are connected by Primary and Foreign keys." how do I know I have done this?
I have selected "many to one" for Works to Equipment in the properties.
I have "TAG" as the 1st column in both tables. My lookup in Works table will only let me select what is in the TAG column in the equipment table.

The overall aim is to add works carried out to pieces of equipment and to see a history of works when I select the equipment.
thanks

Was this reply helpful? Yes No
Drrickryp Super User 2024 Season 1 on at

Like (0)

Report

Dataverse creates the relationship automatically. You can use dot notation to implement it. Check out Dataverse's Northwind sample database to see how it's done.

Was this reply helpful? Yes No