Power Platform Community Forum Thread Details

Hi,

We are having two tables, first table is related to second table as one-to-many relationship.

I want to create a flow in which I want to select a record (on second table) and call a flow on it. I just want to make copy of that row. Issue that I am facing is to relate this row to the first table because I don't have access to unique id for the row which I want to associate with.

Table Structure to help make sense of use case is

Quote Table - holds customer information

Quote Line Items Table - single line has a single product of the quote in it

Quote Line Item Calcs Table - has multiple quote details (numbers) in it based off of quantity.

How do we get the uniuqeid of the Quote Line Item which doesn't appear in the table in the back end.

Thanks in advance

Todd

Categories:

Building flows

Hi,

If I understood correctly, you want to access a Quote Line Items table record unique id in Power Automate, although you cannot see this column in your Model Driven App. If this is not exactly what you need, please provide more context.

In Dataverse, all tables have a default column that repeats the table's name, and contains its unique identifier for Power Automate purposes. For example, in the Account table the column containing the unique identifier is also named Account:

In Power Automate, you can use this same column for accessing the table record unique id. When searching for the column name in the dynamic content list, you may notice the description will be "Unique identifier of the [table name]", like highlighted in yellow:

Let me know if it works for you or if you need any additional help!

-------------------------------------------------------------------------
If this is the answer for your question, please mark the post as Solved.
If this answer helps you in any way, please give it a like.

http://digitalmill.net/

https://www.linkedin.com/in/raphael-haus-zaneti/