cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
zdzunic
Helper I
Helper I

Delete a table

Hi, I try to delete table  "Online Shopper Intention" which I created during my test for AI Builder Prediction Model. I got the following message "There are dependencies on this table that are preventing it from being deleted." Before that I deleted all dependencies for example applications or models connected with this table. 
Is it possible to find which dependencies still exist with the table? 

1 ACCEPTED SOLUTION

Accepted Solutions
zdzunic
Helper I
Helper I

Thanks, I deleted table from Default Solution I was able to import new solution from AIBuilderOnlineShopperIntention_1_0_0_0.zip. 
I have another Problem - during importing csv file for AI Builder Example. In Table (Online Shopper Intention) the Field for Prediction (Revenue (Label)) is "Yes/No" type with default Value "No". csv file has rows with null value for that column and that is important for AI Builder Prediction example. How can I import column as "Yes/No" type with null values (how to avoid default value for this type of field). The Field "Ravenue" is optional.

View solution in original post

4 REPLIES 4
ChrisPiasecki
Super User
Super User

Hi @zdzunic,

 

You can view the dependencies of a component from within a Solution (you can choose the Default Solution if it's not in a custom one already) . 

 

  • In the maker portal, navigate to Solutions. 
  • Select Default Solution. 
  • Find your table and select the row (don't open the table) 
  • Select the 3 ellipses at top to see all the options, then select Show Dependencies

 

You can do the same for other components in the solution as well (e.g. Columns, etc). 

 

---
Please click Accept as Solution if my post answered your question. This will help others find solutions to similar questions. If you like my post and/or find it helpful, please consider giving it a Thumbs Up.

 

 

zdzunic
Helper I
Helper I

Thanks, I deleted table from Default Solution I was able to import new solution from AIBuilderOnlineShopperIntention_1_0_0_0.zip. 
I have another Problem - during importing csv file for AI Builder Example. In Table (Online Shopper Intention) the Field for Prediction (Revenue (Label)) is "Yes/No" type with default Value "No". csv file has rows with null value for that column and that is important for AI Builder Prediction example. How can I import column as "Yes/No" type with null values (how to avoid default value for this type of field). The Field "Ravenue" is optional.

View solution in original post

Hi @zdzunic,

 

You cannot have a null value for a yes/no type, as it is represented by a boolean in the backend database. What I would suggest is to use a Choice column instead with Yes and No as options, then leave the default as is to empty. This allows to have nulls..

 

---
Please click Accept as Solution if my post answered your question. This will help others find solutions to similar questions. If you like my post and/or find it helpful, please consider giving it a Thumbs Up.

zdzunic
Helper I
Helper I

Thanks for suggestion.

I tried that, "choice" Data type for Ravenue field with [no default value] option (values for choice are "Yes", "No) and rows with null values for Ravenue field are not imported at all. Is there any option during import for for example "import rows with null values" or something? Funny thing, few days ago this import was ok (with null values ) and it was very easy to create Ai Builder Prediction model and test. Is there any changes in code or version of Power app?

Helpful resources

Announcements
PA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Users online (847)