cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Stanza
Frequent Visitor

CDS - Enter custom value - Update record

I want to update an activity record (phone call/task etc) depending on its type.

 

How do I do this using the action 'Update a record' ? I need to specify an entity type but I want to do this dynamically using a variable?

The variable contains the activity entity type.

I get the following when I enter the entity type using a custom value :

 

power_automate activity.JPG

I am not able to progress further.

1 ACCEPTED SOLUTION

Accepted Solutions
Expiscornovus
Super User
Super User

Hi @Stanza,

 

As far as I am aware this is limitation of that update a record action. 

 

However, a workaround could be to use the Web API of Microsoft DataVerse instead: https://docs.microsoft.com/en-us/powerapps/developer/common-data-service/webapi/overview

 

1. Register an app in Azure AD and assign the Microsoft DataVerse impersonation delegated permissions

2. Create an Application User with the Client Id of the Azure AD App

3. Use an HTTP action in your flow with the following URI and the client id, tenant id and secret from your Azure AD app in the authentication section.

@{variables('EnvironmentUrl')}/api/data/v9.0/@{variables('Entity')}(@{variables('RecordId')})

microsoftdataversepatch.png

View solution in original post

1 REPLY 1
Expiscornovus
Super User
Super User

Hi @Stanza,

 

As far as I am aware this is limitation of that update a record action. 

 

However, a workaround could be to use the Web API of Microsoft DataVerse instead: https://docs.microsoft.com/en-us/powerapps/developer/common-data-service/webapi/overview

 

1. Register an app in Azure AD and assign the Microsoft DataVerse impersonation delegated permissions

2. Create an Application User with the Client Id of the Azure AD App

3. Use an HTTP action in your flow with the following URI and the client id, tenant id and secret from your Azure AD app in the authentication section.

@{variables('EnvironmentUrl')}/api/data/v9.0/@{variables('Entity')}(@{variables('RecordId')})

microsoftdataversepatch.png

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

New Ideas Forum MPA.jpg

A new place to submit your Ideas for Power Automate

Announcing a new way to share your feedback with the Power Automate Team.

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

MPA Licensing.jpg

Ask your licensing questions at the Power Automate AMA!

Join Priya Kodukula and the licensing team, super users and MVPs to find answers to your questions on Power Automate licensing.

Users online (2,969)