Creating a collection from sharepoint

Like (0) Share

Report

Posted on 22 Jun 2022 21:35:31 by Community Power Pla...

I have created a collection from SharePoint. In the SharePoint this column is set up as choices.

I have created a collection using this formula

ClearCollect(Deadline, {Result: "All"}); Collect(Deadline, Choices('Test Closing calendar'.'Deadline Day'))

However the items collected from SharePoint are displayed or collected as values not results.

Can I change them into results? or when using this collection for filtering the gallery I need to play with formula a bit?

All responses (19)

Answers (1)

WarrenBelz 148,929 Most Valuable Professional on 23 Jun 2022 at 08:00:18

Like (0)

Report
Re: Creating a collection from sharepoint

@Anonymous ,

No it is not - the field name is field_4 you must have imported this from Excel - you need

field_4.Value = 'Deadline Selection'.Selected.Value

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps
Community Power Pla... on 23 Jun 2022 at 06:23:24

Like (0)

Report

Re: Creating a collection from sharepoint

Got the same link
WarrenBelz 148,929 Most Valuable Professional on 23 Jun 2022 at 01:41:50

Like (0)

Report

Re: Creating a collection from sharepoint

@Anonymous ,

You are missing the end - another way is to hover over the field name and the URL is at the bottom.
Community Power Pla... on 23 Jun 2022 at 00:34:41

Like (0)

Report

Re: Creating a collection from sharepoint

https://my.sharepoint.com/teams/List/_layouts/15/FldEdit.aspx?List=%7BBBF96339%2D4AB2%2D4E42%2D9F90%2DE13690DF39FD%7D&Field=field%5F4

This is what I see as URL
WarrenBelz 148,929 Most Valuable Professional on 23 Jun 2022 at 00:26:49

Like (0)

Report
Re: Creating a collection from sharepoint

@Anonymous ,

Maybe it should be

'Deadline Day'.Value

or you could also try

Deadline_x0020_Day'.Value

The actual name is at the end of the URL of the screen you have posted.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps
Community Power Pla... on 23 Jun 2022 at 00:22:16

Like (0)

Report

Re: Creating a collection from sharepoint

If you mean what is the Dropdown box that shows the collection of Deadline it's exactly the list you see as Choice (WD1, WD2, ...)
Community Power Pla... on 23 Jun 2022 at 00:20:45

Like (0)

Report

Re: Creating a collection from sharepoint

I am sorry but on the settings for this field I don't see any URL
WarrenBelz 148,929 Most Valuable Professional on 23 Jun 2022 at 00:11:57

Like (0)

Report

Re: Creating a collection from sharepoint

@Anonymous ,

Go to your SharePoint List Settings, select Deadline_Day and look at the end of the top URL to see the actual field name. Also what are the Items of the Combo Box ?
Community Power Pla... on 23 Jun 2022 at 00:05:53

Like (0)

Report

Re: Creating a collection from sharepoint

When I type this one in, I got an error message "Name isn't valid. Value isn't recognized".

On the SharePoint this field is a single choice field.
WarrenBelz 148,929 Most Valuable Professional on 22 Jun 2022 at 23:50:27

Like (0)

Report
Re: Creating a collection from sharepoint

@Anonymous ,

That is why I used .Value - are you saying there is an error on

Deadline_Day.Value = 'Deadline Selection'.Selected.Value

also what are the Items of 'Deadline Selection' and is Deadline_Day a single or multiple choice in SharePoint ?