Power Platform Community Forum Thread Details

Hello

Is it possible to set a time and date record of using function Relate?

I want it to be seen by what day was assigned certain work to certain worker.

Or even better, can you think of some way to set a various dates when the work have to be done to a various linked workloads?

Thank you all

Categories:

Using Apps Using Formulas

@JM-14081323-0

The Relate function links two records through a one-to-many or many-to-many relationship in Microsoft Dataverse. This means that Relate function doesn't creates a new record, it can relate two records that exists.

In your case, if you just use Relate, you will not be able to capture date-time of the assignment.

You can have 3 tables like Workers table, worker-load table and Assignment table.

This way, every time you assign a worker to a workload, you create a record in Assignments table with the date (or dates).

You can use Patch() function to create a record in Assignment table.

==================================================

If this reply helped you, please mark this reply as suggested answer ✔️ and give it a like to help others in the community find the answer too!

Thanks,

Vipul

Community site session details

Set a date of linking the records when using function Relate

Helpful resources

News and Announcements

Quick Links

Responsible AI policies

Telen Wang – Community Spotlight

Congratulations to the July Top 10 Community Leaders!

Leaderboard > Power Apps

Featured topics

Product updates