Share
Report
18Hello,
I need help fetching a singular record from a table to use in a lookup field on a parent table...
I have a table of approvers, with the columns:
Approver ID
Approver (user lookup)
Department (choice)
Title (choice)
There is only one approver for each Department (ex. accounting) with a given Title (ex. manager)
Based on values in the Parent table, I want to auto assign an approver based on the title and department, on a row in the Parent table that is a lookup field.
I essentially want to do a "get" call on the table to fetch a record based on a specific Title and Department (which should never return multiple records, since they are unique combinations of Title and Department)
The closest I can get is with the Dataverse List Rows function, but this returns a table and automatically applies an Apply to Each on the record I want to update with the approver I retrieved, even though based on my filtering it should be a table of 1 record.
Is there a way to get just the one record so that I can use it in the Dataverse Update Row function in lookup field to the Approver table?
Alternatively, if I could just retrieve the Approver ID, I could use that to populate the lookup field in the Parent table.
All responses (
Answers (
