Power app return empty/ blank from collection in sharepoint only

(0) Share

Report

Posted on by Janneke123

Hi all,

I have the following business case for my field "SMO" (this field is set up as a choice in sharepoint list)

1. on ITEMS I put below formula so that PowerApps knows the active user is me & does a lookup in my reference list which "SMO" drop downs can be visible:

Distinct(Filter('Accesibility reference list' ,Or(Title= varUser, SMO = Blank())),SMO)

2. on On select I put below, so that I create a collection called findSMOref that I will use for later "conditional" drop downs:

ClearCollect(findSMOref, {Result:"-"}); Collect(findSMOref, Filter('SMO Cluster Country Brand Family 3 reference', TDSMO = DataCardValue11_2.Selected.Result));

In my Powerapp test environment all is working, I only see the "SMO" fields that I want (2 our of 10). Also my other conditional field are working.

However when I save and check it back in my Sharepoint list, it did not save SMO field.

My Key User in PowerApps also doesn't know how this happened.

Does anyone know or know a workaround?

Categories:

Building Power Apps

SPscreenshot.PNG

I have the same question (0)

All responses (4)

Answers (1)

JimmyW 2,563 on at

Like (0)

Report

So you want to save your collection into a SharePoint column?
How does your save function look?

Was this reply helpful? Yes No
Janneke123 11 on at

Like (0)

Report

HI Jimmy,
maybe to give more background:
1. I am working from a sharepoint list
2. I created a power app, so that I can modify the columns more advanced
3. I already created the field "SMO" as a choice in sharepoint, and I modify the conditions in PowerApp with the formulas I described above
4. so if user name is Janneke, then I created a lookup that only 2 choices (out of 10) are visible.
5. this is all working in Power apps, but as soon as I go back to Sharepoint --> create "NEW" item, its going to the App picklist, I fill out all the fields --> its not saving my selected SMO.

I enclosed a picture of the dropdown and how the sharepoint looks like.
Note that I updated all fields (show screen, create screen and edit screen with the same formulas)

powerapp.png

SPscreenshot.PNG

Was this reply helpful? Yes No
Janneke123 11 on at

Like (0)

Report

by the way, I think related to this I face an issue with my conditional fields: if I set up the sharepoint list as "choice", they all jump back to the default value when I want to create a new one.

Was this reply helpful? Yes No
Verified answer

Drrickryp Super User 2024 Season 1 on at

Like (2)

Report

@Janneke123

Don't use Choice fields in SharePoint. Change it to Single line of text and use PowerApps to supply the options for example in a dropdown or radio control set the Items property to ["Choice1","Choice2","etc"]. Check out this blog post by @WarrenBelz https://www.practicalpowerapps.com/data/constructing-your-first-power-app-before-you-start/

Was this reply helpful? Yes No