How to relate two entities into CDS

(0) Share

Report

Posted on by Community Power Pla...

Hi All,

I want to related two entities but the situation here is I have two entities for instance- Journey and Route. And, I have created a web form using these two entities. As soon as user fills the web form, the data is getting inserted into two entities. As data is inserted simultaneously how can I related them ? How can I pass the Route id lookup value into the journey entity as both are generated at the same time into respective entity into CDS.

Is there a way to achieve this?

Any help is appreciated.

Thank You.

Categories:

Power Apps portals

I have the same question (0)

All responses (1)

Answers (0)

OOlashyn 3,496 Most Valuable Professional on at

Like (1)

Report

Hi @Anonymous ,

If you would like to create them simultaneously there won't be any easy way to achieve this. Instead, if applicable, I would suggest you create two separate entity forms - one for Journey and one for Route. First, you will create a Route entity. On the entity form for it in the On Success Settings tab you can set On Success field to Redirect and then in Redirect section select entity form for Journey as a Web Page, check Append Record ID To Query String field and provide custom query id parameter in Record ID Query String Parameter Name field. After that on Journey form implement javascript that reads query string parameter and populate lookup on the Journey.

Was this reply helpful? Yes No