web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Switching from Sharepo...
Power Apps
Unanswered

Switching from Sharepoint List to Dataverse Table in Canvas app

(0) ShareShare
ReportReport
Posted on by 135

Hey all!

 

I'm trying to move my data source for my canvas app to Dataverse from a Sharepoint List (I'm going to be setting up a model-driven app for administration/review of the submitted data).  I've built my table and columns, etc.  When I added it as a data source and slowly going through screen by screen and updating, I'm having problems with my cascading forms (across multiple screens) storing the information in the variable that was previously working with my sharepoint list:

Form1: Datasource is MS Dataverse Table--S2S_1

On Success:  Set(formType,"Edit");
Set(selectedItem,'Form1'.LastSubmit);
Navigate('Screen2')

DefaultMode: If(formType = "New", FormMode.New, FormMode.Edit)

Item: selectedItem

 

The only two datacards in that specific form are two text boxes that I specified in the table.  Powerapps is throwing this error:

Smilee279_0-1627304536278.png

Google hasn't been super helpful on what this error means so I can fix the thing.  From everything I've found, it *shouldn't* have an issue with the variable, and yet.....it is.  I have this formula setup on each of my Form screens (there's 4 screens), and works fine with the Sharepoint List, but as soon as I switched it to my CDS table, it blows up on the variable.  Any help would be appreciated--sorry I'm a novice with dataverse and still learning!

Categories:
I have the same question (0)
  • Drrickryp Profile Picture
    Super User 2024 Season 1 on at

    @Smilee279 

    I am not sure what you mean by "cascading forms".  If you are referring to a one to many relationship between tables, you can import each table (Parent and Child), and then recreate the relationship in Dataverse. 

  • Smilee279 Profile Picture
    135 on at

    I'm using April Dunham's video for mutli-screen form controls so that I can pass the information in each form/screen on to the next so that it stays in the same "line" if I were using Sharepoint.  I'm still learning how the one-to-many relationships work in Dataverse, I wasn't sure if it was a broken thing I have setup in the canvas app (given the error) or how I have my table setup (and still learning how to do this properly).  

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 366 Most Valuable Professional

#2
11manish Profile Picture

11manish 184

#3
MS.Ragavendar Profile Picture

MS.Ragavendar 99 Super User 2026 Season 1

Last 30 days Overall leaderboard