Answered

patch to Dataverse not working

(0) Share

Report

Posted on by Community Power Pla...

Hello,

I have created collection form my Dataverse table.

ClearCollect(MySales,salestable_A)

I made a excel like editable gallery.

That is working well. My gallery update MySales correctly.

My gallery is made to edit like excel and also to add a data form my item tabe.

What I would like to do is to Patch(Update) MySales data to my Dataverse table "salestable_A".

Following formula is to Update "salestable_A" but this is not working.

I have red line form ForAll and to the end.

Can somebody advice me what is wrong on my formula?

If(!IsBlank ---

is to update "salestable_A".

I need to create to add new one also but I would like to solve update first.

ForAll(
 MySales, 
 If(!IsBlank(ThisRecord.salestable_A_id),

 Patch(salestable_A,
 ThisRecord,
 {cr9d1_qty: ThisRecord.cr9d1_qty,
 cr9d1_price: ThisRecord.cr9d1_price
 }
 )
 ));

Categories:

Microsoft Dataverse

All responses (11)

Answers (1)

Community Power Pla... on at

Like (0)

Report

Re: patch to Dataverse not working

@v-xiaochen-msft

I'm sorry for not contacting you earlier.
I rename my column and it worked!
Thank you so much for your help.
v-xiaochen-msft on at

Like (0)

Report

Re: patch to Dataverse not working

Hi @Anonymous ,

You could also use MyTable[@fieldname] instead of fieldname .

Best Regards,
Wearsky
Verified answer

v-xiaochen-msft on at

Like (0)

Report

Re: patch to Dataverse not working

Hi @Anonymous ,

I will suggest you to rename the columns of your collection. (Use RenameColumns() function)
The column names of the table are the same as the column names of the collection, which may cause errors.

Best Regards,
Wearsky
If my post helps, then please consider Accept it as the solution to help others. Thanks.
Community Power Pla... on at

Like (0)

Report

Re: patch to Dataverse not working

@v-xiaochen-msft

Thank you for your help!
This is my Dataverse setting.
v-xiaochen-msft on at

Like (0)

Report

Re: patch to Dataverse not working

Hi @Anonymous ,

Could you tell me:
What's data type of 'cr9d1_r_daily_report_ope_sales_figures_id' column in dataverse table?
What's data type of 'qty' in dataverse table?

In addition, please check that the column names are correct.

Best Regards,
Wearsky
If my post helps, then please consider Accept it as the solution to help others. Thanks.
Community Power Pla... on at

Like (0)

Report

Re: patch to Dataverse not working

@v-xiaochen-msft
Hello,

Thank you for your help!
I have delete 'ThisItem.'.
Still not working
v-xiaochen-msft on at

Like (0)

Report

Re: patch to Dataverse not working

Hi @Anonymous ,

I noticed that you used "ThisItem" in the formula.
Could you tell me why you use it?

You could try to delete 'ThisItem.' first to check if the formula works correctly.

Best Regards,
Wearsky
If my post helps, then please consider Accept it as the solution to help others. Thanks.
Community Power Pla... on at

Like (0)

Report

Re: patch to Dataverse not working

@v-xiaochen-msft

Hello, Thankyou for your continued support.
This is my error message.😅
v-xiaochen-msft on at

Like (0)

Report

Re: patch to Dataverse not working

Hi @Anonymous ,

What is the error message?

Best Regards,
Wearsky
Community Power Pla... on at

Like (0)

Report

Re: patch to Dataverse not working

@v-xiaochen-msft

Thank you so much for your help.
I still have error message.😫