Answered

Building Power App Integrated with Power BI - Save doesn't work.

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

I have built a very simple App connected to power BI - when I had the DB on SharePoint it was working fine but moved it to Dataverse and now save btn doesn't work.

I have the field Name as primary in my table, but my app keeps returning this error:

I know this is a very basic formula but what am I missing here?

lets say my save formula is : SubmitForm(EditForm1)

Table is : XXX

and Name is setup as:

EditForm1 data source is table XXX

I feel like I'm losing my mind but can't find out why this is happening.

any help would be appreciated.

Thanks

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Verified answer

EddieE 4,641 Moderator on at

Like (1)

Report
Copy link

Link copied!

@Anonymous

When using SubmitForm() or Patch() to any data source, all required fields must be included - the error is telling you that a required field is missing.

If you are using a form and you don't want users see / use a particular required field then simply hide it, but it must be one of your datacards in your form.

If you are using Patch, same thing, just include the required field in your Patch code.

Was this reply helpful? Yes No
v-peijunz-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Hi @Anonymous

Based on the error message, it seems that you set the specific column as Required but not patch it in the form.
Please check whether you hide the column in the form. You can click on + Add fields to see if you can add it to the form in PowerApps and set false on Required can be done in your environment and then do a test to see the result.

Best regards,
Sylvia

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Thanks
I can't beleive I missed that! it is now fixed.

Was this reply helpful? Yes No