EDIT: I have more information in a new post below.
Hello.
I'm trying to build an app that has a simple gallery with a list as the data source. The data source only has one extra column except for the defaults, Margin. Margin is a numeric column with a default value of 20.
When I build the gallery from the data source, the Margin column isn't available.
Here are the columns in the list:
And when I add the data source, I only get Title as a data card. If I manually add a label, this is what happens:
And likewise, when changing the Text parameter:
How come I can't use the Margin column in my gallery?
Solved! Go to Solution.
Figured it out - just removed .Title from the Search.
Before:
SortByColumns(Search('Internal Stock Customers'.Title, TextSearchBox.Text, "Title"), "Title", If(SortDescending1, SortOrder.Descending, SortOrder.Ascending))
After:
SortByColumns(Search('Internal Stock Customers', TextSearchBox.Text, "Title"), "Title", If(SortDescending1, SortOrder.Descending, SortOrder.Ascending))
Hi @WillPage
Did you add the Margin column to your list after connecting to the datasource in your powerapp?
If you did you may need to refresh the connection, or try removing and re-adding it.
Cheers
Hadyn
@HadynMYes I should have mentioned - tried refreshing the data source, then when that didn't work, removed and re-added the data source, same result.
I have figured out why it's not giving me the addional column to use as a data card, but I don't know how to fix it. I copied the Items field from the defualt template for this kind of gallery and adapted it for my data source. It looks like this:
SortByColumns(Search('Internal Stock Customers'.Title, TextSearchBox.Text, "Title"), "Title", If(SortDescending1, SortOrder.Descending, SortOrder.Ascending))
I need to know how I can add 'Internal Stock Customers'.Margin to this without affecting how the search box and sort order button works. I don't even want to display the Margin, just set it as a variable when the Next arrow within a gallery item is pressed, to use on another screen.
Figured it out - just removed .Title from the Search.
Before:
SortByColumns(Search('Internal Stock Customers'.Title, TextSearchBox.Text, "Title"), "Title", If(SortDescending1, SortOrder.Descending, SortOrder.Ascending))
After:
SortByColumns(Search('Internal Stock Customers', TextSearchBox.Text, "Title"), "Title", If(SortDescending1, SortOrder.Descending, SortOrder.Ascending))
Hi @WillPage,
As I know,SharePoint default field values aren't brought forward to PowerApps. You need to set the default values yourself in the PowerApps form.
I am not sure whether my understanding for your issue is right or not.
What you want is the Margin's default value not show in the first Gallery Screen, but when you pressed next arrow it will show in the next screen?
You can set as this:
Display Form: Change the Text of Margin to 20, as the screenshot;
Edit Form:Change the Default to 20.(as the screenshot)
Hope this helpful.
User | Count |
---|---|
193 | |
127 | |
88 | |
48 | |
42 |
User | Count |
---|---|
279 | |
162 | |
136 | |
81 | |
78 |