Dropdown Filter Not Updating Record

(0) Share

Report

Posted on by chris_young

136

Hello everyone,

I have a screen named Project linked to SharePoint List Project

I have another list - PM which does not have a screen

PM is a field on the form Project, which as a whole has a data source of Project except this one field . I am using Filter(BIS_PMs, Status.Value = "Active").Title to display only Active items for this single field.

The screen is displaying the active items only so that part is working.

What is not working is the submit for this single field. When I submitform, it does not submit this field back to the SharePoint List Project, but it will save the other fields back to the sharepoint list as expected. The update statement in this datacard is DataCardValue153.Selected.

Any help would be appreciated. Thank you

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (1)

Sort by

cds 1,001 on at

Like
a
(0)

Report
Copy link

Link copied!

DataCardValue153.Selected.Value ?

Was this reply helpful? Yes No
chris_young 136 on at

Like
a
(0)

Report
Copy link

Link copied!

@cds
Thank you for such a quick response. I should have stated I tried that already.
It doesn't like .Value
It looks like it is pulling the other fields from the PM List to update and not the Project list where I want it to do.

Was this reply helpful? Yes No
Verified answer

v-siky-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @chris_young ,

The PM column is LookUp type column, right? If so, please refer to the following steps:

1. modify the Items property of DataCardValue153 as follows, and select Title column in Field property

Filter(BIS_PMs, Status.Value = "Active")

2. modify the Update property as follows.

{ '@odata.type':"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference", Id: DataCardValue153.Selected.ID, Value: DataCardValue153.Selected.Title }

Hope this helps.

Sik

Was this reply helpful? Yes No
chris_young 136 on at

Like
a
(0)

Report
Copy link

Link copied!
@v-siky-msft

Thank you for the reply. When I go to paste the UPDATE code in, I get an error at
Id: DataCardValue153.Selected.ID,
The .ID is red, my only option is either without the .ID or with the Field Name (.Name)
I tried both but when I submit either I get a Bad Gateway response.

Was this reply helpful? Yes No
v-siky-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @chris_young ,

Please make sure the Items property of DataCardValue153 is as follows, without '.Title' code. Then 'DataCardValue153.Selected.ID' code should work.

Filter(BIS_PMs, Status.Value = "Active")

If the issue still exist, please go to SharePoint list - List Setting -Edit LookUp column to show us the Additional Column Settings.

Hope this helps.

Sik

Was this reply helpful? Yes No
chris_young 136 on at

Like
a
(0)

Report
Copy link

Link copied!

@v-siky-msft

Thank you, everything is working perfectly.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi,
Need help with filter dropdown – the formula is app is working fine – but data is not getting updated in SharePoint. Below are the details:
Attached all details

PowerApp Help.docx

Was this reply helpful? Yes No