Power App Maker Portal issue (?) when deleting polymorphic lookups

Today I was stuck in an uncomfortable situation.

I wrongly created a polymorphic relationship between 3 tables. Wrong for 2 different reasons: the name of the lookup field was wrong, and I also needed 2 tables more (the PACX command to add tables to a…


This content originally appeared on DEV Community and was authored by Riccardo Gregori

Today I was stuck in an uncomfortable situation.

I wrongly created a polymorphic relationship between 3 tables. Wrong for 2 different reasons: the name of the lookup field was wrong, and I also needed 2 tables more (the PACX command to add tables to an existing poly-lookup is not ready yet).

Not so bad, I thought. Let's delete it.

On make.powerapps.com I did the following:

  1. Opened the solution where the table that contains the lookup column is defined.
  2. Moved to Columns.
  3. Selected the polymorphic lookup column and clicked on "Delete from this environment".

Delete from this environment

But it didn't worked: 😕

Error

I also tried deleting the relationship before deleting the column:

  1. Moved to Relationships
  2. Selected one of the relationships composing the poly-lookup relation, and clicked on "Delete from this environment".

Second try

Same stuff... 😠
Error

Then I tried again on the lookup column:

Different error

Now I got a different error 🤬

I'm already tired of headaches. Remembering about the recent threads about make.powerapps.com UI issues, I went by my favorite route.

PACX to the rescue! 💪🏻

Suddenly I remembered an old command I created to remove unwanted columns.

pacx column delete --table ava_presence --schemaName ava_relationshipid

And ✨ it worked like a charm

PACX solves!

The column and relationships are both been deleted successfully.

Conclusions

The Power Apps Maker portal is really powerful, but in terms of UI/UX it presents still a few issues that sometimes are tricky to identify and manage properly.

Fortunately for us, the tools provided by the open-source community (typically created by people who work day-by-day on the platform and understand its constraints and untapped potential) help us overcome these limitations, making us more effective and efficient.


This content originally appeared on DEV Community and was authored by Riccardo Gregori


Print Share Comment Cite Upload Translate Updates
APA

Riccardo Gregori | Sciencx (2024-10-29T10:59:43+00:00) Power App Maker Portal issue (?) when deleting polymorphic lookups. Retrieved from https://www.scien.cx/2024/10/29/power-app-maker-portal-issue-when-deleting-polymorphic-lookups/

MLA
" » Power App Maker Portal issue (?) when deleting polymorphic lookups." Riccardo Gregori | Sciencx - Tuesday October 29, 2024, https://www.scien.cx/2024/10/29/power-app-maker-portal-issue-when-deleting-polymorphic-lookups/
HARVARD
Riccardo Gregori | Sciencx Tuesday October 29, 2024 » Power App Maker Portal issue (?) when deleting polymorphic lookups., viewed ,<https://www.scien.cx/2024/10/29/power-app-maker-portal-issue-when-deleting-polymorphic-lookups/>
VANCOUVER
Riccardo Gregori | Sciencx - » Power App Maker Portal issue (?) when deleting polymorphic lookups. [Internet]. [Accessed ]. Available from: https://www.scien.cx/2024/10/29/power-app-maker-portal-issue-when-deleting-polymorphic-lookups/
CHICAGO
" » Power App Maker Portal issue (?) when deleting polymorphic lookups." Riccardo Gregori | Sciencx - Accessed . https://www.scien.cx/2024/10/29/power-app-maker-portal-issue-when-deleting-polymorphic-lookups/
IEEE
" » Power App Maker Portal issue (?) when deleting polymorphic lookups." Riccardo Gregori | Sciencx [Online]. Available: https://www.scien.cx/2024/10/29/power-app-maker-portal-issue-when-deleting-polymorphic-lookups/. [Accessed: ]
rf:citation
» Power App Maker Portal issue (?) when deleting polymorphic lookups | Riccardo Gregori | Sciencx | https://www.scien.cx/2024/10/29/power-app-maker-portal-issue-when-deleting-polymorphic-lookups/ |

Please log in to upload a file.




There are no updates yet.
Click the Upload button above to add an update.

You must be logged in to translate posts. Please log in or register.