[ad_1]
Hello Everyone,
Today i am going to share my experience on how to update a invoice record where the option set field value needs to be updated in the lookup field on same invoice entity.
Scenario: Requirement to remove the Option set field and before that happens that option set value should be updated in the Lookup field which have same string value. The purpose of it is to do bulk update of all invoice records with business unit lookup value.
Lets gets started.
Login into Power Automate here
First choose manual trigger flow.
Then initialize variable “department” and choose Type as “string”.
Then select “List rows” which is for list invoices.
In the table name column choose “Invoices” and in the filter rows paste the “schema name” of the business unit field not equal to null from the invoice.
As the business unit field is already exists in the invoice table, the purpose of this flow is o update the invoices records, copy the values from the department “option set” field value and update…
[ad_2]
Source link