Hello! I'm still pretty new with PowerApps and would like to know the best way to edit / add data in an SQL view. Basically, I have a canvass app connected to an SQL DB. The DB has multiple tables and consolidated to a view. If I want to add / edit the view, I need to edit the underlying table (let's call it master table) where it gets the data from. I used an edit form with master table as the source.
Is lookup function an effective way to do this? I tried patterning my lookup with Shane Young's tutorial video but just couldn't make it work and I always get the message "This formula uses scope, which is not presently supported for evaluation." I don't think it would be that straight forward since I want to edit the master table so in the editform, the datacard values should show it's corresponding value from the view and not the master table.
Solved! Go to Solution.
User | Count |
---|---|
263 | |
110 | |
92 | |
55 | |
41 |