Answered

Adding null entry into sql collection in powerapps

(0) Share

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

I have the same question (0)

All responses (2)

Answers (2)

Verified answer

StalinPonnusamy Super User 2024 Season 1 on at

Like (2)

Report
Hi @tonykiefer

This creates the first entry as an empty one

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

Was this reply helpful? Yes No
Verified answer

RandyHayes 76,297 Super User 2024 Season 1 on at

Like (1)

Report

@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.

Was this reply helpful? Yes No