I have an app to keep track of equipment and loans on my work location.
I use two lists in Sharepoint to do this:
In my company we have several locations which this could be useful.
This is part of the code I use to get information from a list:
SortByColumns(Search('SHAREPOINT LIST', SearchItems.Text, "Title", "Category", "ItemNo"),"Category",If(SortDescending1, Descending, Ascending))
Is there any way to change the data source 'SHAREPOINT LIST' using a variable?
I have tried the easy ways by making a global variable with the same name as the list, tried making a table and using the table. But no luck.
Lets say I have 20 locations which want to use the same app, but they do not want to use the same lists.
Is there any way to make this a simple solution using variables?
Solved! Go to Solution.
We can't dynamically change the data source. The solution is to Collect the data to Collection and Assign the collection to Gallery in PowerApps.
Thanks! Thats seems to do the trick! 🙂
A couple of issues / questions:
1. System fields may not show up. Is the BarcodeValue is a custom field right?. All columns should be in the list settings but the view we are looking at may not show the column.
2. We can change the display name but not the schema name. The best practice to create a column in Sharepoint is "create a column without space and any special char". Once created change the display name with space.
We need to create a new field and migrate the data since we can't change the schema name.