Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Syndicate_Admin
Administrator
Administrator

Sort Distinct not updating to my sharepoint list or keeping the information in the app

HI

 

I currently have a few dropdowns that populate from a sharepoint list using Sort(Distinct('8 Step Improvement Plan Lookup Info','Site/Function'),Result), 

Distinct(Filter('8 Step Improvement Plan Lookup Info','Site/Function'=DataCardValue2.Selected.Result),'Work Area')

Distinct(Filter('8 Step Improvement Plan Lookup Info','Work Area'=DataCardValue3.Selected.Result),Owner)

 

these work fine until I submit the form and it does not take these results with it. all other options are updating fine any ideas where I am going wrong please?

10 REPLIES 10
Syndicate_Admin
Administrator
Administrator

I know this post is old, but I have the same issue.   

I have tried making these text columns in the sharepoint list and lookup columns.  At some point PowerApps changed the ability to enter in "datacolumn.Selected.Result" you can now only select "Selected.Value", and since this change it will not write the value to the text column on the SharePoint list. 

 

 

Syndicate_Admin
Administrator
Administrator

Hi @joybre 

 

  • What property you are getting after the . (Result is not getting)?
  • What're your Items property?

 

Syndicate_Admin
Administrator
Administrator

joybre_0-1634887419707.png

joybre_1-1634887516759.png

joybre_2-1634887598582.png

the filters are working correctly as you can see from the images above. the final picture is my detail screen after I have submitted the form showing that the filtered results are not submitting. all other fields are submitting correctly they do not have any filters on them. the pictures in my previous message show the error when i use .selected.result it does not like the result part 

joybre_3-1634888336810.png

im not getting any errors on any other fields and yes I have tried everything that you have suggested.

 

excuse the last image. this is the one.

joybre_4-1634888439435.png

 

Syndicate_Admin
Administrator
Administrator

Hi @joybre 

 

To troubleshoot the issue, I need a few more information

 

  • If the filter works properly?
  • What output you are getting when WorkAreDropdown.Selected.Result?
  • Are you getting errors for all fields?
  • Is items property of dropdown the same as mine?
Syndicate_Admin
Administrator
Administrator

Hi Thanks I have tried this and I get an error when adding result to the code.

 

joybre_0-1634823091745.pngjoybre_1-1634823137607.png

 

Syndicate_Admin
Administrator
Administrator

Hi @joybre 

 

Set the update property of Site/Function Card to

SiteDropdown.Selected.Result

StalinPonnusamy_0-1634819461113.png

 

Set Update property of Work Area Card to

 

WorkAreDropdown.Selected.Result

 

Set the Update property of Owner Card to 

OwnerDropdown.Selected.Result

 

Site dropdown Items property to

Sort(Distinct('8 Step Improvement Plan Lookup Info','Site/Function'),Result)

WorkArea dropdown Items property to

Distinct(Filter('8 Step Improvement Plan Lookup Info','Site/Function'=SiteDropdown.Selected.Result),'Work Area')

Owner Dropdown Items property to

Distinct(Filter('8 Step Improvement Plan Lookup Info','Work Area'=WorkAreDropdown.Selected.Result),Owner)

 

I just tested this use case and works fine.

 


Thanks,
Stalin - Learn To Illuminate

 

Syndicate_Admin
Administrator
Administrator

site/function DataCardValue2.Selected

work area DataCardValue3.Selected

line manager Dropdown1.Selected

they are all from one sharepoint list of single line of text

Syndicate_Admin
Administrator
Administrator

Hi @joybre 

 

Please make sure to set update property of Datacard for each like below

 

StalinPonnusamy_0-1634788664203.png

 

Note: Update property based on the data type and how items property is filled. So please share each column datatype so that we can provide a better answer.


Thanks,
Stalin - Learn To Illuminate

 

 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors