Answered

Taking input from a Lookup combobox in Powerapps and populating a Lookup column in Dataverse

(0) Share

Report

Posted on by AB-03121629-0

Hello!

I currently have a PowerApps app that uses a Power Automate flow to create new rows in a Dataverse Table, using the user input. Currently, for creating an "Event", I have a combo box input in PowerApps that has an items property of my "Jobs" table. It allows the user to set what Job this Event should be associated with. I am passing the unique identifier of that Job to the Power Automate flow, but I can only pass it as text given the limitations of the "PowerApps requests a flow" trigger and the allowed parameter types. The column in my Event table for associated job is of type "Lookup", and it references the Job table. As a result, when using the "Add New Row" Dataverse action in Power Automate, I cannot use the unique identifier obtained from powerapps as a value in the "Add New Row" action. Is there any way I can use this unique identifier in my "Add New Row" action in order to populate the entry with the Job item that has that unique identifier?

Currently, I try to pass in the job id and am getting this error: "URL was not parsed due to an ODataUnrecognizedPathException. Resource not found for the segment 'JOB-000024' provided in the URL." This makes sense of course because I am trying to put a text value into a Lookup column, but I just wanted to note where I'm at.

Sorry, I know this one is a bit confusing, but I am happy to answer any questions in order to figure this out, it's quite important for my program.

Thanks in advance!

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Verified answer

Kalathiya 2,139 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!
Hello @AB-03121629-0,

Issue is that a Lookup column in Dataverse can’t just take a text ID. In your Power Automate flow, you need to pass the Job record as a proper reference (GUID).

If you need to store a value in a Lookup column, you need to pass the record ID (GUID) of the item you want to link. In Power Automate, set the Lookup column like this:

/jobs(<GUID of the job>) //jobs replace with your job table scheme name //Replace jobs with the schema name of your Job table. //Replace <GUID of the job> with the actual Job GUID you get from PowerApps.

You can copy the column’s schema name from the table designer properties in Dataverse. This is the name you need to use in Power Automate to store a value in the Lookup column.

Power Automate:

Reference Link about how to store lookup column value:

https://www.matthewdevaney.com/power-automate-update-a-lookup-column-in-dataverse/

If this response resolves your issue, please mark it as the Verified Answer so it can help other community members as well.

---------------------------------------------------------------------------------

📩 Need more help? Mention @Kalathiya anytime!
✔️ Don’t forget to Accept as Solution if this guidance worked for you.
💛 Your Like motivates me to keep helping!

Was this reply helpful? Yes No
AB-03121629-0 62 on at

Like (0)

Report
Copy link

Link copied!

@Kalathiya Thanks! I am trying to solve using the "Get a row by ID" action in Power Automate, but I am currently struggling with taking the user's input from powerapps (which is a unique identifier of the row as text, matching a column value from Jobs) and retrieving the specific Row ID from that. I want it to work like this:

User Triggers Power Automate flow from Power Apps, passing a parameter of JobID (e.g. JOB-00001)

Power Automate uses "Get a row by ID" and retrieves the specific row from the Jobs table which has the JobID of JOB-00001.

Power Automate uses "Add to Table" and uses the result of "Get a row by ID" as the parameter of the "Associated Job" column of the new Event entry.

I'm just getting hung up on the second step, where power automate uses that specific value of JOB-00001 and retrieves the correct row based on that. Thanks in advance again for your help!

Was this reply helpful? Yes No
Kalathiya 2,139 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
Hello @AB-03121629-0,

You can’t use “Get a row by ID” in this case because that action expects the Dataverse record GUID.

To get the Job Record GUID, you need to use the List rows action and apply a filter on the JobID column to retrieve the correct record. I’m assuming the JobID column is also a unique column.

This will return the full Job record, from which you can capture and store the GUID in a variable.

Add one variable action with String data type.

On expression you need to add below formula:

first(outputs('List_rows')?['body/value'])?['cr1bf_courseid'] //outputs('List_rows')?['body/value'] - This is output of above List Rows action //cr1bf_courseid - replace with your jobid guid column

And use this column in further automate for store job id lookup column value.

If this response resolves your issue, please mark it as the Verified Answer so it can help other community members as well.

---------------------------------------------------------------------------------

📩 Need more help? Mention @Kalathiya anytime!
✔️ Don’t forget to Accept as Solution if this guidance worked for you.
💛 Your Like motivates me to keep helping!

Was this reply helpful? Yes No