Issue with selecting SharePoint fields via Solution

[jjkieft]

I use a solution to deploy my Power Apps app from development environment to UAT and Production environment. 

My Filter on a SharePoint List is not working properly because 2 fields are not selected via the filter. When I debug the app, I observe the fields are not added to the collection. I added a lookup formula specific for these fields, the lookup returns blanks. 

The strange thing is in my maintenance form when I enter values to the 2 fields, I see in SharePoint that the fields are updated. 

This behaviour is only in my UAT and Production environment. I my development environment it works perfectly.

I rebuild the app and use standard selection of the SharePoint List. Without the solution and environment variables. Everything works fine.

So my conclusion is something is not working correctly when I use a solution

Has anyone had the same problem? And hopefully someone has a solution for it. 

[FLMike]

Hi @jjkieft 

Lets step back for a minute and pretend we are having a good meal together. You say all these words to me.. and I look at you and say, I am so sorry, SHOW ME 🙂 because the words don't mean anything to me, without seeing the code.

By the way it was a good meal 🙂

Cheers
If you like my answer, please Mark it as Resolved, and give it a thumbs up, so it can help others
Thank You
Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
https://gernaeysoftware.com
LinkedIn: https://www.linkedin.com/in/michaelgernaey

[jjkieft]

The code is rather straightforward,

See below the ClearCollect funtion used when deploying is done via the solution. So it linked to the environment variables in the solution 

ClearCollect(
colGridData,
Filter(
'Organisation Chart List',
'Org Chart' = Value(varLegalHolderID)
)

);

See below the ClearCollect funtion used when deploying is done just with export and import of the app. Directly connected to SharePoint.

ClearCollect(
colGridData,
Filter(
'Organisation Chart',
'Org Chart' = Value(varLegalHolderID)
)
),

The result is different 2 fields are empty in the first collection, in the second collection the correct SharePoint values are available

[FLMike]

Hi @jjkieft 

Straightforward or not its a waste of time for me to have to ask for it.

Have you verified that there is actual data, that matches that criteria in the database. Please dont just say yes, please go and look and verify it actually matches.

The queries do not change or not work from environment to environment unless the data is wrong, the tables are wrong or the columns or all of the above.

I have literally never seen a case where there is data in a column for a row and it doesnt show up in the collection. I mean.. that isn't even feasible.
If you like my answer, I would really appreciate if you please Mark it as Resolved, and give it a thumbs up, so it can help others

Cheers

Thank You
Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
https://gernaeysoftware.com
LinkedIn: https://www.linkedin.com/in/michaelgernaey

[jjkieft]

Hi Michael

Yes it is certainly strange. I use SharePoint as my data collector. 

See attachments where I took a snapshot of both collections from the 2 apps. I understand it is hard for you check if you are looking at the same thing. But marked yellow data is missing the colGirdData using solution

Kind regards Jaap-Jan

[IAmIntractable]

My guess is that the SharePoint lists are not the same across the environments. Perhaps you have misnamed specific fields in UAT and Prod.

[FLMike]

hi @jjkieft 

You skipped the majority of what I said.

Check the columns names (not the display names), literally go look at the schema details of both tables. Side by side with 2 windows open.

Also did you verify that the table where the data comes from even have that data in them

They do not match or the data isn't there. Please go look as I asked and you will find it. Ignore it and keep looking at the data all day.

If you like my answer, I would really appreciate if you please Mark it as Resolved, and give it a thumbs up, so it can help others

Cheers

Thank You
Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
https://gernaeysoftware.com
LinkedIn: https://www.linkedin.com/in/michaelgernaey

[jjkieft]

Of course I looked at the table, As I already mentioned in my first email when I make a change to the fields via the maintenance screen of the same app. The fields are updated in SharePoint. So the link to data source is correct. I would use name that don't exist I in the data source I would get errors in my app. 

The specific data is only available on this SharePoint site. I don't have it available in other sites. Both apps link to the same SharePoint list

[jjkieft]

Yes I checked it a few time, I removed the fields and add them again. But no positive result.

I tried to add a lookup to select the field directly but it returns blank data. It doesn't give an error, which would be the case if I misspelled anything in my app.

[IAmIntractable]

Where is the ClearCollect command that creates the list? Is it pulling in everything or only specific columns. I do know of an issue with solutions whereby field display names cannot be used. You should always use the schema name of a field. I dont think you are using Solutions properly since you should not have one data source for all of the environments. Also, are you linking to the lists using environment connections and variables. I found this to be a bit tricky to get right because of the obtuse presentation in the maker.