web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Adding null entry into...

Power Apps

Answered

Adding null entry into sql collection in powerapps

(0) Share

Report

Report

Posted on by tonykiefer

534

I am trying to create a collection from a sql table that currently does not include a null entry. I am using one of the columns in the table to populate a dropdown list. Currently the user should have the option of not making a selection but without a null entry the dropdown list always shows the first entry.

I create the collection this way...

ClearCollect(WashPrep_Collection,Tablename)

So is there a way to make the first record in the collection a blank?

Categories:

Building Power Apps

All responses Img

All responses (2)

Answers Img

Answers (2)

Sort by

Verified answer

StalinPonnusamy Super User 2024 Season 1 on at

Like
a
(2)

Report
Copy link

Link copied!
Hi @tonykiefer

This creates the first entry as an empty one

ClearCollect(colContacts,{}); Collect(colContacts,TableName);
Verified answer

RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

@tonykiefer

If you are truly working with a Dropdown, then set the AllowEmptySelection property to true and set the Default property to Blank()

This will give you a blank entry without any other actions needed.

I hope this is helpful for you.

Join the conversation