Power Automate

I cant retrieve the value of a column which is lookup datatype.

(1) Share

Report

Posted on by CU21010356-0

I have created 2 dataverse tables as shown below. App ID data type is lookup of Table 2(App)

Table 1 ( Company)

Company App ID

1 1

2 1

3 2

Table 2 (App)

App ID Name

1 XXX

2 YYY

3 ZZZ

My current flow is as such "Triggered when there is a new row in Table1". Next, I compose the value of (App ID Type) to find out the value returned is auto-generated. May I know subsequently, how do I compose to the value of the App Id value (1,2 or 3) and the name of app corresponds to the App ID.

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (0)

Sort by

Michael E. Gernaey 53,963 Moderator on at

Like (1)

Report
Copy link

Link copied!

Hi

I am sorry its extremely confusing.

Can you please try to write it in Step form instead of the sentence form, as too much overlap and unclarity.

Thanks

Was this reply helpful? Yes No
Suggested answer

ankit_singhal 618 Moderator on at

Like (0)

Report
Copy link

Link copied!

I'm a little bit confused. As I understood, Your flow is triggered, when a new row is created in table 1. So, you can compose your triggered body in that you will find app id. and if you want to fetch data from table to based on app id then you can add list row and select table 2 and filter for app id.

Note: Please mark verified, if it is useful for you

Was this reply helpful? Yes No