cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Dudditz
Continued Contributor
Continued Contributor

Using first function to avoid apply to each on CDS relationship column

Hello,

 

In the first image the first step works fine and returns the GUID of the related column.

The 2nd step fails which uses the following expressoin, first(body('List_rows_2')['value'])['aet_sharepointdocumentlocation']

The intention of the 2nd step is just for testing and this expression would be used in in the 3rd step once its working.

The error is seen in the next image.

 

I use these first expressions all the time to avoid apply to each steps.  This is the first time I have used on on the CDS relationship type column.  The document location value is being retrieved from another get items step which is the reason for using the first function to avoid the apply to each steps.

 

If all that makes sense than the goal is simply how to use the first function to avoid the apply to each on a cds relationship column resulting in the retrieval of the GUID.  Any guidance is greatly appreciated.

 

1.jpg2.jpg

1 ACCEPTED SOLUTION

Accepted Solutions
Dudditz
Continued Contributor
Continued Contributor

Resolved using the following expression.  first(body('List_rows_2')?['value'])?['_aet_sharepointdocumentlocation_value']

View solution in original post

1 REPLY 1
Dudditz
Continued Contributor
Continued Contributor

Resolved using the following expression.  first(body('List_rows_2')?['value'])?['_aet_sharepointdocumentlocation_value']

View solution in original post

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Users online (1,892)