Unanswered

Unable to update a row in selected environment

(0) Share

Report

Posted on by MJ-28071720-0

I have a custom table in dataverse and I need to update/add data to a specific row and specific column. Keep getting Bad Request - Error in query syntax and unable to update data in table with connector. Any suggestions?

Categories:

Using connectors

I have the same question (2)

All responses (6)

Answers (0)

stampcoin 5,058 Super User 2025 Season 2 on at

Like (1)

Report

@MJ-28071720-0 Hi,

Please provide more information , like flow's screenshot, some details regarding the fields, error message .

thanks.

Was this reply helpful? Yes No
Tomac 3,953 Moderator on at

Like (0)

Report

To expand on @stampcoin's request, when you say a different environment do you mean a different tenant or that you moved the flow to a different environment and are now getting an error or some secret third problem?

Was this reply helpful? Yes No
MJ-28071720-0 8 on at

Like (1)

Report

Additional info:

I have a personal environment with a flow already created. I have a second account with a premium license that includes dataverse. I am simply adding a built in dataverse action connector that enables me to point to my premium account and access a dataverse table in the flow I already have established in my personal account.

I have a list row dataverse connector added in my flow in order to get dynamic values from my dataverse table( see Row ID text box below). My issue is being able to understand how to use Row ID to point to the correct row and column to update the field I want with a value in my table. I have done this using an excel connector to a file however I am not able to replicate with dataverse.

update row dataverse connector:

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

Similar concept from an update excel row connector I have used that works for comparison:

Error I receive when running flow with dataverse connector, the value I want never is added to the table:

The table I want to update with a value:

Was this reply helpful? Yes No
stampcoin 5,058 Super User 2025 Season 2 on at

Like (1)

Report

@MJ-28071720-0 Hi,

The Row ID is the table's Unique identifier, the type is Unique identifier.

you can use List rows from selected environment to get the unique identifier and assign it to update a row.

For example, one record of my table (column Invoices as display name) RowId =15efa19e-6233-f011-8c4d-6045bd997b48

Was this reply helpful? Yes No
MJ-28071720-0 8 on at

Like (1)

Report

Thats what I selected in my Row ID but the value does not get added to the table:

Am I understanding this correctly, if I want to update the Email number row that has a value of 5, enter data into timestamp field:

Was this reply helpful? Yes No
stampcoin 5,058 Super User 2025 Season 2 on at

Like (1)

Report

@MJ-28071720-0 Hi,

Have you tried to use filter rows in List rows action ?

For example , I use invoice_no = '2025052801' to filter the table.

try that with your own data filter, and select a few columns ( logic name). then check out the output

beware of those two columns, that's odd naming .....

Was this reply helpful? Yes No