Answered

edit form error

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

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

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

WarrenBelz 156,384 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Anonymous ,
What are the Items property of Gallery1 and the DataSource of your form.

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

Like
a
(0)

Report
Copy link

Link copied!
Hi @Anonymous :
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 form’s items attribute does not exist.
Case2:The data source of the record specified in the form’s items property does not match the data source of the form
Case3:No record specified in the form’s 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 gallery‘s items property and the form’s DataSource Make sure they use the same data source.
If you still have any problem, don’t hesitated to let me know.

Best Regards,
Bof

Was this reply helpful? Yes No
Verified answer

Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No