Display Planner bucket name instead of id in Powerapps gallery

Like (0) Share

Report

Posted on 27 Apr 2020 16:35:58 by BaderTOO

Hi Everyone,

Is there a way to make a gallery, that is connected to my Planner tasks, show the actual display name in place of the bucket id?

The first screenshot shows the gallery with the long string of characters representing the bucket id. The second screenshot shows the drop down with the options available to display data from Planner.

Any help would be awesome!

Thanks

Categories:

General Questions

Annotation 2020-0...

All responses (8)

Answers (0)

Eddine_Touati 2 on 26 May 2022 at 11:15:38

Like (0)

Report

Re: Display Planner bucket name instead of id in Powerapps gallery

Try the following function

First(Filter(Planner.ListBucketsV2(ThisItem.planId).value,id=ThisItem.bucketId)).name
QTButton 4 on 18 Feb 2022 at 20:19:37

Like (0)

Report

Re: Display Planner bucket name instead of id in Powerapps gallery

I did this and am STILL not getting the bucket name

Still no Name.JPG
QTButton 4 on 15 Feb 2022 at 17:47:13

Like (0)

Report

Re: Display Planner bucket name instead of id in Powerapps gallery

The Question was still not answered and I am looking for the same thing. I have the beckets in a gallery, I have the Plan ID and the Group ID.... the question is in the Gallery where ALL THE TASKS are listed, I want the status line to have the bucket Title based of the Bucket ID..... "ThisItem.bucketID"... So, ThisItem.bucketTITLE... how do you do that?

Question.JPG
RezaDorrani 12,141 on 27 Apr 2020 at 17:49:59

Like (0)

Report

Re: Display Planner bucket name instead of id in Powerapps gallery

@BaderTOO

If trying in text property of label use

First(Filter(Planner.ListBucketsV3( planId,groupid).value,id=bucketId)).name

plug the planid groupid and bucketid values correctly

--------------------------------------------------------------------------------
If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.
BaderTOO 4 on 27 Apr 2020 at 17:45:49

Like (0)

Report

Re: Display Planner bucket name instead of id in Powerapps gallery

I will give that try. Where exactly should I be putting that line of code? Within the Items formula for the gallery, or in the Text formula for the text label?
RezaDorrani 12,141 on 27 Apr 2020 at 17:36:32

Like (0)

Report

Re: Display Planner bucket name instead of id in Powerapps gallery

@BaderTOO

Set(buckets,Planner.ListBucketsV3(planid,groupid).value)

This will give you a collection of Buckets associated with the plan and group

You will need both the planid and the groupid

Next within this collection you will have to search for the bucketit in order to get its name

Literally a long route just to get the bucket name.

The Planner API's must be improved

--------------------------------------------------------------------------------
If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.
BaderTOO 4 on 27 Apr 2020 at 17:27:14

Like (0)

Report

Re: Display Planner bucket name instead of id in Powerapps gallery

@RezaDorrani Thanks for the quick reply. I have seen that post you shared but I'm not entirely sure it is what I need. I should preface this by saying that I am very new to Powerapps so I could just be overlooking something simple.

The gallery I am showing is a ListMyTasks gallery, where I want the name of the bucket to show up within a text label. Here (in the attachment) you can see the Items formula for the gallery. According to that post you shared I would want to modify that code, is there a way to insert the bucket id bit of code into the existing formula I have?

Annotation 2020-0...
RezaDorrani 12,141 on 27 Apr 2020 at 16:40:51

Like (0)

Report

Re: Display Planner bucket name instead of id in Powerapps gallery

Hi @BaderTOO

check this post

https://powerusers.microsoft.com/t5/Building-Power-Apps/Planner-ListBuckets/td-p/415565

--------------------------------------------------------------------------------
If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.