Collection not populating

Hi =ADumith , I'm glad you found a solution. We all learn together, every day.

Regards, Jon

jonlake 

I finally did it.

I decided to create a new list from a database as you suggested and also create a new app.

So everything works perfect now.

We won't know what the problem really was but I think it was a data source.

Thank you so much for all the follow-up you did to this case, now I am going with something a little more complicated and it is for work anniversaries, I will create another question in case I need it.

Again, thank you so much, I really appreciate it 

Hello jonlake,

At first I thought that was the problem and it would be enough to do what you are recommending me; actually, that was what I was doing, but unfortunately that's not the problem.

I'll explain, I took the variable varMonth and assign the value 01 (January) and the filter worked!

The filter worked finally, so the problem is when I try to do the filter with the variable value or the field value, somehow there is no match between them.

Maybe if we change the type of the variable, I mean use a local one instead of global, or there is definitely a problem with the list and I have to redo it but from scratch, instead of importing it.

Any ideas?

Hi ADumith , I can see now what's happening. The import from Excel brought in the Mbirth data with a field name of 'field_4'. Even if you rename it, in a Flow you need to use the original name. The original name can be seen if you view your list settings, then hover over the field in question At the bottom of the screen you will see the URL for that field with the original name at the end of the URL.

I avoid importing from Excel if at all possible but I appreciate it can sometime be a quick way to import data. A method which provides for greater control is to import the Excel data into an Access database, do any data cleansing there, and then export to your SP site as a list.

I can also see that you date of birth field is set to 'single line of text'. Should that not be a date field?

If your Mbirth data is in 'field_4' your gallery items should be set to:

//filter the gallery items to only show those with a birth month matching the current month
Sort(Filter(colBirthDay,field_4=varMonth),field_3,Descending)

Good morning jonlake,

Look at the image.

Note that each field has its title.

But, when the collection is created, the title of the field is not brought, but rather an ambiguous title is placed, I mean, field_1 instead of FullName, field_2 instead of EmployeeEmail, etc.

I'm sure that's the issue source, so how to solve it.

Thanks again for your time and support

Hi ADumith , do you have fields in the list with the same title?

Good evening jonlake,

Oh! 

I hadn't realized it.  How do you think we can fix it?

 I use that list for a workflow for birthdays, so any changes I make will surely affect the workflow. 

Thank you for taking the time to review and go further. 

Hi ADumith, I noticed that your list contained a number of field headings with ambiguous titles, e.g. Field_01, Field_02 etc. I would first try to simplify the list and give names to the columns that are appropriate for the data they contain. It's possible that you have more than one field named the same, which may be confusing your gallery filter/sort. If you can create the collection then your access shouldn't present a problem.

Hello jonlake 

Well, now I don't know whether to laugh or cry. 

On the one hand the app is fine, it works as expected, however I can't get it to work on my side.

Thinking a little more, if there was a problem accessing the SharePoint list, don't you think that the collection would not even be generated?

I imported the list from Excel, I didn't do it from scratch. Would have something to do with it?

I think I'll have to put a support ticket to Microsoft to review this case.

However, thank you so much for all the support you have given me.