Answered

Collection columns empty when importing from SQL

(0) Share

Report

Posted on by Capt_Ron

When I import a table or view from a SQL server (on prem) Some of the columns in the collection are empty when using the designer. But when I publish the app and run it, the data shows up.

This is driving me crazy because I have "If IsBlank" conditions in a gallery and they are always blank even though I know they are not.

Is this a systemic issue or isolated?

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (1)

Sort by

eka24 20,925 on at

Like
a
(0)

Report
Copy link

Link copied!

Can you show the "If IsBlank" formula?
------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Was this reply helpful? Yes No
Capt_Ron 74 on at

Like
a
(0)

Report
Copy link

Link copied!

The issue is not with the IsBlank function.
Label Text field = If(IsBlank(ThisItem.Category),"No Category Chosen",ThisItem.Category) (The column in the database would be NULL if there was no data)

After I import the data into the collection and I go to View Collections I see the the collection and the 1st 5 records. Most off the columns in the collection are empty even though the database has data in those columns.

I did look in the Settings | Advanced Settings and saw that this was enabled:
Explicit Column Selection

So I am going to disable it and see if that fixes the issue.

Was this reply helpful? Yes No
eka24 20,925 on at

Like
a
(1)

Report
Copy link

Link copied!

To further clarify:
1. You import from SQL to Collection
2. Check collection, you confirmed that some columns are blank
3. Now you want to use the formula
If(IsBlank(ThisItem.Category),"No Category Chosen",ThisItem.Category)----Where do you want to use the Formula? Gallery or another collection?
if you are using it in another collection, please state the formula

If Gallery, then the formula is ok:
------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Was this reply helpful? Yes No
Capt_Ron 74 on at

Like
a
(0)

Report
Copy link

Link copied!

That is correct.
The formula is in a label in a gallery.

Was this reply helpful? Yes No
Verified answer

Capt_Ron 74 on at

Like
a
(1)

Report
Copy link

Link copied!

Issue has been resolved.

This behavior is caused by:
Settings | Advanced Settings Explicit Column Selection being enabled.

This feature only pulls in the columns you are using. So if you are starting out, you get no columns. I do not know how this got turned on.
It is off and all my data is now showing up.

Thanks
Ron

Was this reply helpful? Yes No
eka24 20,925 on at

Like
a
(0)

Report
Copy link

Link copied!

As you can see on the screenshot i posted, it works. If you are having issues, take a screenshot of the Collection and the Gallery and post.
------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Was this reply helpful? Yes No