You’re offline. This is a read only version of the page.
Announcements
Hey Everyone,
I am learning Power Automate. I am trying to learn how I can pull data from related records. Here is the test use case I came up with that I am trying to build in Power Automate:
Test Use Case: When an Account is selected in the Case record, look into the Account and find the Primary Contact. Look through all of the Opportunities related to the Primary Contact and find the the Opportunity with the highest Revenue and return the revenue value and Opportunity name and populate it in a field on the Case.
I have the flow I have so far, above. It fails at step 3 - It tells me the Row ID (Primary Contact (Value)) is null, even though when I tested it, I ensured that the Primary Contact has a value for the selected Account. Note that I am using Select Columns in the second action since I only want to return the Primary Contact ID field on the Account. Here is an image of the failure.
What's interesting is that it runs successfully if I do the exact same thing but I go into the second step and then remove the Primary Contact ID under the Select Columns. I don't understand why it returns null if I tell the flow that I only want it to return the Primary Contact ID of the Account and then pass that GUID into the Get Row by ID action for Contact. Can someone help me understand what I am doing wrong? I plan to utilize the Select Columns and Expand Query feature a lot since it can help me return a more filtered list of values for performance purposes. Thank you!
Hi @rahul_s,
As far as I am aware the field name is _primarycontactid_value. Can you use that field instead of the primarycontactid in the select columns. When you hover the field in the third action you should also see that internal name in the tooltip btw.
Share
Report
All responses (
Answers (
33,189
