get related row

(0) Share

Report

Posted on by DiePic

463

Hi all,

the flow in picture is working, it send me 2 mails with the correct row of table "opportunity".
I will need 2 more data from tables :
1 - Account (linked to [Opportunity][parentaccountid] with column [Account][name])
2 - Utente (linked to [Opportunity][ownerid] with column [Utente][fullname])
...
I try to put "retrieve a row by id" in every place but it fails always.
Can somebody give me some suggestion please?
Thanx in advance

Categories:

General topics

I have the same question (0)

All responses (3)

Answers (0)

okeks 802 Super User 2024 Season 1 on at

Like (1)

Report

I think what you need is an expand query.

Here is an example of how to use it: Using expand query with Microsoft Dataverse Connector | Power Automate | by Prerna Kapoor | PowPCo

If this is too complicated you could also use the "Get a row by ID" action on your other two tables and put the ID from the opportunity record as a row id there.

Was this reply helpful? Yes No
DiePic 463 on at

Like (0)

Report

thanks @okeks
I try with this expand query as suggest in your link:
"parentaccountid($select=name;$expand=ownerid($select=fullname))"
but return this error
where I'm mistaken?
thanks in advance for any help or suggestion

Was this reply helpful? Yes No
DiePic 463 on at

Like (0)

Report

No suggestion for error in my string for expand query?

Was this reply helpful? Yes No