sort by ID

[mbhatt]

Hello Everyone ,

i have filter gallery and i want to see my data when new record create output on my gallery will appear new records on top ,

i mean new ticket on top 

i am using this formula but not working there is no error on formula but seems like not working 

suggest me if any solution 

my DataSource is from splist and view my data by New Record ID which is comes from ID column from list

[BCBuizer · Accepted solution]

Hi @mbhatt ,

From a syntax perspective there was something weird going on in your conditions. Also the Sort function was missing. Can you try the below:

Sort(
	If(
		User().FullName = "Maulik Bhatt",
		'HH Power App',
		Filter(
			SpCollection,
			'Created by'.DisplayName = User().FullName || ID = Value(TextInput6.Text)
		)
	),
	ID,
	SortOrder.Descending
)

Ps. Please post your formulas in text as well to prevent having to re-type everything which takes more time, effort and is more prone to errors.

[mbhatt · Accepted solution]

Thank you So much sir its work for me.

[mbhatt · Accepted solution]

Hello 

@BCBuizer 

Your formula is work but somehow i can see all data but user will not able see their own data ... see blank 

[BCBuizer · Accepted solution]

Hi @mbhatt ,

In your original formula you gave two different data sources, depending on whether or not you are the user:

You (Maulik Bhatt"): 'HH Power App'

Everyone else: SpCollection

Is the collection properly populated? If not, that can explain why other users don't see anything. You can resolve that by either populating the collection correctly, or by using using 'HH Power App' for the other users as well:

Sort(
	Filter(
		'HH Power App',
		User().FullName = "Maulik Bhatt" || ('Created by'.DisplayName = User().FullName && (IsBlank(TextInput6.Text) || ID = Value(TextInput6.Text)))
	),
	ID,
	SortOrder.Descending
)

Ps. In the above I also changed the condition for the ID filtering because it doesn't make sense for a user to be able to filter for other User's records. Now, with TextIput6, they can filter for one specific ID as long as they created it.

[mbhatt · Accepted solution]

Hi

@BCBuizer 

with this new formula i got delegation warning might not process large dataset 

Please look screenshot 

[mbhatt · Accepted solution]

with this new formula i got delegation warning might not process large dataset 

Please look screenshot. 

please ignore my previous screenshot 

[BCBuizer · Accepted solution]

Hi @mbhatt ,

Besides the delegation warning I ran into a further issue where items weren't showing up, so please try:

Sort(
	If(
        User().FullName = "Maulik Bhatt",
        'HH Power App',
        Filter(
            'HH Power App',
            'Created by'.DisplayName = User().FullName,
            IsBlank(TextInput6.Text) || ID = Value(TextInput6.Text)
        )
    ),
	ID,
	SortOrder.Descending
)

[mbhatt · Accepted solution]

Hello @BCBuizer 

i try this formula also. but there is no data visible from user side as i am Maulik Bhatt admin i can see all 

but user not able to see anything 

do i need to update any formula in APP on Start Or on visible property?

to can see data ? here i am attach the formula on app start i use this all 

[BCBuizer · Accepted solution]

Hi @mbhatt,

Where in the user screen is TextInput6? The filter has been set up to use that, but in your screenshot I don't see it. Perhaps this has a default value like "Text input", which is causing the user to not see anything since that is not a valid ID.