Share
ReportHey 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!
All responses (
Answers (
33,511
