Value changes back

[IvenSch]

Hi together,

in my PowerApp for request I have a field which is changed in relation to another field.

So, as soon as a PO no. is written in the left field, 'PO sent' jumps to 'Waiting for Approval'. That works.

If the PO is released, the 'PO sent' status is manually set to 'Sent'. This also works and appears in the SP list correctly.

But if I open the form again from SP list to change something, it shows 'Waiting for Approval' again. 

If you forget to change it to 'Sent' than, it is stored with 'Waiting for Approval' which is not correct.

Here are the codelines for 'PO sent' field:

Items: 

Choices([@'Purchasing requests'].'PO sent')

DefaultSelectedItems:

If(IsBlank(DataCardValue23.Text);{Value:""};{Value:"Waiting for Approval"})

Maybe the error occurs as I also added a new Flow after setting the 'PO sent' to 'Sent'?

Thanks for your help!

[IvenSch]

This is the error:

[DBO_DV]

Do you have a self created Table in the dropdownbox or does it come from the Data source?

[IvenSch]

The values come from the datasource = SP List.

[DBO_DV]

Well then we need to first identify where he expects a table. 
you can try this by removing the ".Value" at one place after another. (Could be that you need to replace Blank with IsEmpty since Empty is made for tables and Blank for values).

Afterwards you could try to comment out the "{value:...}"
Like that you can find what is causing the issue

[IvenSch]

I`m sorry, but where do I have to place the IsEmpty

[DBO_DV · Accepted solution]

If(
IsBlank(DataCardValue23.Text);
{Value:""};
IsEmpty(LookUp(SPList;PO no.=DataCardValue23.Text).Po sent);
{Value:"Waiting for Approval"};
LookUp(SPList;PO no.=DataCardValue23.Text).Po sent.value
)

[IvenSch]

Now it says this:

_____________________________________________________

______________________________________________________

But DataCardValue24 is a Value-Field

[DBO_DV]

try to remove the last ".Value" as well

[IvenSch]

Than I just have one more mistake:

But if I remove this '.value' as well, it is:

[DBO_DV]

Your PO no. are unique identifiers right?
If so replace LookUp with Filter and power apps should get what it wants