cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
troyhoskison
Helper I
Helper I

creating a record in a sub table on creation that is linked to the created table

Hi,

 

I am trying to create a new power Automate for handling work orders.

 

The concept is that on the creation of a work order in the work order table (cr318_sagemworkorders), it will create some records in a linked table (cr318_sdeworkorderpicklists).

 

I have a trigger on the cr318_sagemworkorders table

troyhoskison_0-1627306806407.png

 

then later in the code I have a add new record on the cr318_sdeworkorderpicklists table:-

 

troyhoskison_1-1627306875826.png

 

in the field for the link to the work Order I have put in the SageM Work Order unique ID

 

troyhoskison_2-1627306934017.png

using the dynamic content:- 

troyhoskison_3-1627306975897.png

 

however when I run it I get the following error:-

 

troyhoskison_4-1627307062130.png

 

but if you look at the work order data then this is the correct reference number, and it does exist. 

troyhoskison_5-1627307172924.png

 

I have also tried using the work order field and that came with the same error message (but with WO021113 instead)

 

When I have created the record manually and then looked that the Pick list table. it has that same reference code:-

 

troyhoskison_6-1627307543946.png

 

it feels like I have made a simple mistake, but I can't find the flaw in my logic.

 

Troy

 

1 ACCEPTED SOLUTION

Accepted Solutions
troyhoskison
Helper I
Helper I

I found the solution here:-

 

Resource not found for the segment issue in Power ... - Power Platform Community (microsoft.com)

 

Apparently I needed to change the field to  \<pluralised table name>(Sagem Work Order)

 

troyhoskison_0-1627309532317.png

 

View solution in original post

2 REPLIES 2
troyhoskison
Helper I
Helper I

I found the solution here:-

 

Resource not found for the segment issue in Power ... - Power Platform Community (microsoft.com)

 

Apparently I needed to change the field to  \<pluralised table name>(Sagem Work Order)

 

troyhoskison_0-1627309532317.png

 

View solution in original post

Hi @troyhoskison 

Glad that your issue is solved.

And thanks for your posting and sharing the solution in the forum as it would be helpful to anyone who encounters similar issues.

Best Regards.

Helpful resources

Announcements
MPA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

V3_PVA CAmpaign Carousel.png

Community Challenge - Giveaways!

Participate in the Power Virtual Agents Community Challenge

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

R2 (Green) 768 x 460px.png

Microsoft Dynamics 365 & Power Platform User Professionals

DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.

Users online (1,037)