Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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?
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.
Hi @joybre
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
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.
Hi @joybre
To troubleshoot the issue, I need a few more information
Hi Thanks I have tried this and I get an error when adding result to the code.
Hi @joybre
Set the update property of Site/Function Card to
SiteDropdown.Selected.Result
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
site/function DataCardValue2.Selected
work area DataCardValue3.Selected
line manager Dropdown1.Selected
they are all from one sharepoint list of single line of text
Hi @joybre
Please make sure to set update property of Datacard for each like below
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