No records in my collection retrieved from an Excel sheet

(0) Share

Report

Posted on by AGroegelich

140

Hi Community,

I just started to work with PowerApps. Right now I have problems in using the ClearCollect function on a Excel sheet data source. The connection to the data source itself is working, I can see the records in my app. But now I am trying to fill a collection from that Excel sheet data source. That doesn’t work so far, the collection is empty.

This is what I use:

ClearCollect(colUsers;

ShowColumns(Tabel1;"FullName";"Inlogname"

)

What is going wrong?

Thanks in advance

Categories:

Building Power Apps

I have the same question (0)

All responses (15)

Answers (1)

kidvallejo 100 on at

Like (0)

Report

Firstly you want to use a comma after the collection name... off the top of my head the rest looks fine

Was this reply helpful? Yes No
AGroegelich 140 on at

Like (0)

Report

Thanks it was worth a try, but that didn't work. It must be a semicolon in the Dutch version of PowerApps.

Was this reply helpful? Yes No
kidvallejo 100 on at

Like (0)

Report

Try clearcollect(collection, excelsource) as a starting point and bring everything in to see if there is an issue with the data source.

There is no difference in the syntax that I am aware of but it might require add columns rather show

Was this reply helpful? Yes No
AGroegelich 140 on at

Like (0)

Report

Well there must be an issue with the data source because even now there are no records showed in the collections oversight. However I am sure the data source connection is working because the records of my excel sheet are visible.

Was this reply helpful? Yes No
kidvallejo 100 on at

Like (1)

Report

Can you show me a screen shot of what you can see of the data source... we will get this working for you 😉

Was this reply helpful? Yes No
AGroegelich 140 on at

Like (0)

Report

Was this reply helpful? Yes No
AGroegelich 140 on at

Like (0)

Report

This is what I get. So all the fields are there, just no records. And I am not aware that I set a filter ore somethng like that.
BTW Many thanks you are trying to help me.

Was this reply helpful? Yes No
kidvallejo 100 on at

Like (0)

Report

No problem, happy to help.

Create a button and on select put the following sorry if I use the wrong names):

Refresh(tabel1);clear(collection);collect(collection, tabel1)

If this doesn't work, check the table range in excel and reconnect if needed

Was this reply helpful? Yes No
AGroegelich 140 on at

Like (0)

Report

Cool, that is working. 😀
So I tried to put the same code in OnVisible of the screen but that was to optimistic. However that the button works might give a clue what is going on.

Was this reply helpful? Yes No
Verified answer

kidvallejo 100 on at

Like (0)

Report

Cool, so onvisible put the following:

Refresh(Tabel1);ClearCollect(colUsers,ShowColumns(Tabel1,"FullName","Inlogname"))

Fingers crossed!

**Edit, you are right there is a Dutch variance I was not aware of... if it doesn't like the above use the following:

Refresh(Tabel1);;ClearCollect(colUsers;ShowColumns(Tabel1;"FullName";"Inlogname"))

Was this reply helpful? Yes No