collect a sharepoint onlines choice columns lists items (the selection of the sharepoints choices not the items used see description)

(0) Share

Report

Posted on by ShaneITAutomate

301

Hi,

I wish to collect a few choice columns choices into dropdowns, if i use the code

If(
 Connection.Connected,
 ClearCollect(
 colLVPrestarts,
 {
 ShiftTypeText: "",
 CrewTypeText: "",
 DepartmentText: ""
 }
 );
 Collect(
 colLVPrestarts,
 ( AddColumns(
 'LV Prestarts',
 "ShiftTypeText",
 Shifttype.Value,
 "CrewTypeText",
 Crew.Value,
 "DepartmentText",
 Department.Value
 ) )
 )
)

I get the choices used however i wish to gain the list items from sharepoint ie

not the ones that have been used in the last 2000 entries ie

I also need it too pull the information from sharepoint not type in ["A","B" etc etc] in the items

Also how would i patch it after wards too?

Categories:

Building Power Apps

All responses (2)

Answers (0)

Sort by

v-qiaqi@microsoft.com Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi@ShaneITAutomate,
Do you want to collect the Choice column options?
Could you please share a bit more about your scenario,:
Collect the whole options within the Choice column, or every selected item from the Choice column by the user?
How you set the Items property of the Dropdown?
If you just want to collect the Choice column options to a Dropdown, you could try the following workaround.
Set the Dropdown Items property as below:

Choices(DateSource.ChoiceColumn)

If you want to collect every selected item from the Choice column once select, you should use the Distinct() function to distinct the selections.
Set the OnSelect property of the Dropdown1 as below:

Collect(ColChoi,{ChoiceSelection:Dropdown1.Selected.Value})

Set the Items property of the Dropdown2 as below:

Distinct(ColChoi,ChoiceSelection)

Best Regards,
Qi
ShaneITAutomate 301 on at

Like
a
(0)

Report
Copy link

Link copied!
No. The app needs to be 100% offline after the initial Onstart, Please read my description again and pay close attention to the pictures which describes exactly what i need, i take it you have .js and images turned off for security? or did you skim read lols.

@v-qiaqi-msft wrote:
Hi@ShaneITAutomate,
Do you want to collect the Choice column options?
Could you please share a bit more about your scenario,:
Collect the whole options within the Choice column, or every selected item from the Choice column by the user?
How you set the Items property of the Dropdown?
If you just want to collect the Choice column options to a Dropdown, you could try the following workaround.
Set the Dropdown Items property as below:

Choices(DateSource.ChoiceColumn)

If you want to collect every selected item from the Choice column once select, you should use the Distinct() function to distinct the selections.
Set the OnSelect property of the Dropdown1 as below:

Collect(ColChoi,{ChoiceSelection:Dropdown1.Selected.Value})

Set the Items property of the Dropdown2 as below:

Distinct(ColChoi,ChoiceSelection)

Best Regards,
Qi
when you use a collection it grabs all the items in the sharepoint list used i wish to use items in the choice column in the sharepoint list. The app is completely offline.

Sometimes if the users go over 2000 entries and only use say A and B . C and D will not show, i do not wish to use the syntax ["A","B", etc et

I guess my only option is to create a list have a row with all available selections and update the list using flow from the master list that inputs the example dropdown fields selected. (This was just an example)

Choices(DateSource.ChoiceColumn)

This one says name is not valid when using a collection.. is there a modification of this? or when i collect i somehow can grab the list?