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

edit form error

Hello Team

I am trying to Build Cnves App to integrate with Power Bi to be able the User to update data in SQL DB.

I added Edit Form for connecting with Azure SQL DB and add required fields like Price and Comment (where Comments shall be updated) and Price will be Update form Items formula as below to show selected values from Product ID;

 

issues I'm facing  are

1. The error message is 'Invalid formula. Expected a value compatible with 'DataSource'.

2. when I review it is said item not display 

 

Captureddd.JPG

 

Casdfdfpture.JPG

 

 

1 ACCEPTED SOLUTION

Accepted Solutions

Thank you for your replay!

I solved the error; I have to set the Item value for the from like this "item=Gallary1.selected"

View solution in original post

3 REPLIES 3
Super User III
Super User III

Hi @Mona1 ,

What are the Items property of Gallery1 and the DataSource of your form.

Community Support
Community Support

Hi @Mona1 :

Could you tell me:

What is the specific operation you build canvas app to integrate with Power Bi? Could you elaborate on it?

There are many reasons will cause No item to display, such as:

Case1:The record that specified in the forms items attribute does not exist.

Case2:The data source of the record specified in the forms items property does not match the data source of the form

Case3:No record specified in the forms items property.

Ect……

According to your description, I guess your situation may fit the description of case2.

In order to solve this problem, I suggest you :

  • Check the gallerys items property and the forms DataSource Make sure they use the same data source.

If you still have any problem, dont hesitated to let me know.

 

Best Regards,

Bof

Thank you for your replay!

I solved the error; I have to set the Item value for the from like this "item=Gallary1.selected"

View solution in original post

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

News & Announcements

Community Blog

Stay up tp date on the latest blogs and activities in the community News & Announcements.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Community Highlights

Community Highlights

Check out the Power Platform Community Highlights

Top Solution Authors
Top Kudoed Authors
Users online (11,968)