Unanswered

Change Data format of dropdown list

(0) Share

Report

Posted on by MSDigitalUser

138

Hello,

My data comes from SP, dates are in format "dd/mm/yyyy" I have a dropdown list, I need to show dates in Quarters.

Thanks,

Categories:

Building Power Apps

I have the same question (0)

All responses (8)

Answers (2)

Verified answer

Ami K 15,679 Super User 2024 Season 1 on at

Like (2)

Report
Hi @MSDigitalUser ,

Could you try:

Sort( Distinct( AddColumns( 'Your Datas', "Quarters", "Q" & RoundUp( Month('Your Date Column') / 3, 0 ) ), Quarters ), Value )

------------------------------------------------------------------------------------------------------------------------------

If I have answered your question, please mark your post as Solved. Remember, you can accept more than one post as a solution.

If you like my response, please give it a Thumbs Up.

Was this reply helpful? Yes No
MSDigitalUser 138 on at

Like (0)

Report

Thanks a lot Amik, one more question please, how can I refer to the new created column?
Like I need to filter the gallery based on the quarters now not dates.

Was this reply helpful? Yes No
Ami K 15,679 Super User 2024 Season 1 on at

Like (0)

Report
Hi @MSDigitalUser ,

Same principle except you're going to merge a Filter condition into the expression. Apply the below to the Items property of your Gallery.

Sort( Filter( AddColumns( 'Your Data', "Quarters", "Q" & RoundUp( Month('Your Date Column') / 3, 0 ) ), Quarters = Your_drop_down_control.Selected.Value ), Quarters, SortOrder.Ascending )

Please note if you have a Form control associated to your Gallery, the above expression will break the Form control and you will receive an "Invalid formula. Expected a value compatible with 'DataSource' error . To fix this you will need to change the Items property of the Form to:

LookUp( 'Your Data', ID = VarRecord.ID //whatever your actual variable name is )

Or:

LookUp( 'Your Data', ID = Your_Gallery.Selected.ID )

------------------------------------------------------------------------------------------------------------------------------

If I have answered your question, please mark your post as Solved. Remember, you can accept more than one post as a solution.

If you like my response, please give it a Thumbs Up.

Was this reply helpful? Yes No
MSDigitalUser 138 on at

Like (0)

Report

Am reciveing the attached error

Was this reply helpful? Yes No
MSDigitalUser 138 on at

Like (0)

Report
Am sorry again, I want to combine the below Gallery filter with the quarters filter:

Filter( 'ICP - Sharepoint', Len(DropOPU.Selected.Value) = 0 || OPU.Value = DropOPU.Selected.Value, Len(DropCountry.Selected.Value) = 0 || Country.Value = DropCountry.Selected.Value, Len(DropDate.Selected.Value) = 0 || 'Activity Planned Date' = DropDate.Selected.Value, Len(DropEM.Selected.Value) = 0 || 'EM ID' = DropEM.Selected.Value, Len(DropStatus.Selected.Value) = 0 || Status.Value = DropStatus.Selected.Value )

I tried to replace " 'Activity Planned Date' with Quarters but it seems I should be adding the column "Quarters" here again

Was this reply helpful? Yes No
Ami K 15,679 Super User 2024 Season 1 on at

Like (0)

Report

@MSDigitalUser ,

I just ran a test out of interest and the delegation warning is not appearing in my SharePoint environment.

@Ethan_R - any thoughts on this whenever you have a moment?

------------------------------------------------------------------------------------------------------------------------------

If I have answered your question, please mark your post as Solved. Remember, you can accept more than one post as a solution.

If you like my response, please give it a Thumbs Up.

Was this reply helpful? Yes No
Verified answer

Ami K 15,679 Super User 2024 Season 1 on at

Like (1)

Report
@MSDigitalUser , use:

Filter( AddColumns( 'ICP - Sharepoint', "Quarters", "Q" & RoundUp( Month('Date Only Column') / 3, 0 ) ), Len(DropOPU.Selected.Value) = 0 || OPU.Value = DropOPU.Selected.Value, Len(DropCountry.Selected.Value) = 0 || Country.Value = DropCountry.Selected.Value, Len(DropDate.Selected.Value) = 0 || 'Activity Planned Date' = DropDate.Selected.Value, Len(DropEM.Selected.Value) = 0 || 'EM ID' = DropEM.Selected.Value, Len(DropStatus.Selected.Value) = 0 || Status.Value = DropStatus.Selected.Value, Quarters = Your_drop_down_control.Selected.Value )

------------------------------------------------------------------------------------------------------------------------------

If I have answered your question, please mark your post as Solved. Remember, you can accept more than one post as a solution.

If you like my response, please give it a Thumbs Up.

Was this reply helpful? Yes No
MSDigitalUser 138 on at

Like (0)

Report

Thanks Amik it worked 🙂

Was this reply helpful? Yes No