Add Row to a table based on entry from another table

(0) Share

Report

Posted on by THowkins96

Hi all,

I have a business process flow that is going to be used for our organisations unit mobilisation process.

In our SDC (Sales Data Capture) table we provide a unit code for a newly mobilised contract. The flow I am using sends an approval request to the approver, the approver then puts a unit code into the comments and I use the comments response as the field to populate the unit code column in the SDC table. Note, the unit code column is a lookup to a unit code master table that is updated via a dataflow from Oracle JD Edwards.

At the moment I have the below:

But this flow is failing, presumably because of the column being a lookup? The records I am trialing it with do exist but have been getting the below error:

"URL was not parsed due to an ODataUnrecognizedPathException. Resource not found for the segment provided in the URL."

Can anyone please assist in how I can firstly populate the unit code field with approval response comment and secondly how I can then use that field to add a new row to my second table.

Thanks

Tom

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (4)

Answers (0)

Mira Ghaly 11,415 Moderator on at

Like (0)

Report
Copy link

Link copied!
@THowkins96

To set a lookup column you will need to get the GUID of the unit code, so I assume the unit code you are getting in the comments in the name of the unit code so you need to use List Rows on the unit code table with a filter expression like

publisherPrefix_primarycolumnname eq 'Code Unit Name' and then to set the lookup it should be set in the below way.

/unitcodetablelogicalnameinplural/GUIDfromtheListRowsfirstitem

Hope this gives you an idea !

Was this reply helpful? Yes No
THowkins96 88 on at

Like (0)

Report
Copy link

Link copied!

Hi @Mira_Ghaly

Would you be able to break that down a bit more for me please, I am not too confident with Power Automate so might need this explained to me in a more in depth way so I can follow please?

I managed to get this far with your response currently.

Was this reply helpful? Yes No
Mira Ghaly 11,415 Moderator on at

Like (0)

Report
Copy link

Link copied!
@THowkins96

Yes sure so on List rows on the Filter rows add the query to get the unit code id from the name

I am not sure about your column names so it will be something similar to the below

xx_name eq 'pass here value from code unit'

Compose Expression

first(outputs('List_rows')?['body/value'])['mg_sampletableid']

Was this reply helpful? Yes No
THowkins96 88 on at

Like (0)

Report
Copy link

Link copied!

Thanks, would the select columns name be the schema name? If yes, would the below be correct?

Was this reply helpful? Yes No