Unanswered

What is formular still display error?

(0) Share

Report

Posted on by PC-02040703-0

Patch(
    'Purchase Price Approval',
    Defaults('Purchase Price Approval'),
    {   'Supplier Code':DataCardValue50.Selected.Value,
        'Supplier Name':DataCardValue58.Selected.Value,
        'Part Name': DataCardValue56.Selected.Value,
        'Approval Purpose': DataCardValue57.Selected.Value,
        'Part Number': DataCardValue60.Selected.Value,
        'Model': DataCardValue61.Selected.Value,
        'Qty per Year': Value(DataCardValue62.Text),
        'Previous Price': Value(DataCardValue63.Text),
        'Final Price': Value(DataCardValue64.Text),
        'PO Effective Date': DateValue(DataCardValue65.SelectedDate),
        'Shokaihin Date': DateValue(DataCardValue66.SelectedDate),
        'Shokaihin PO#': DataCardValue67.Text,
        'Delivery Lead Time': DataCardValue68.Text,
        'Supplier stock Q''ty': Value(DataCardValue69.Text),
        'Ship by': DataCardValue70.Text,
        'PO Remain Q''ty': Value(DataCardValue71.Text),
        'YSP Stock Q''ty': Value(DataCardValue72.Text),
        'Comment': DataCardValue73.Text,
        'Request Date': DateValue(DataCardValue74.SelectedDate),
        'Requested by': DataCardValue75.Text
    }
);
Notify("✅ Data submitted successfully!", NotificationType.Success);
Navigate(ThanksScreen);

Categories:

Power Query

sampel of propert...

I have the same question (0)

All responses (3)

Answers (0)

mmbr1606 14,605 Super User 2025 Season 2 on at

Like (0)

Report

hello

please let us know what your issue is. withaout a specific question we cant help

thanks

Was this reply helpful? Yes No
WarrenBelz 153,127 Most Valuable Professional on at

Like (0)

Report

@PC-02040703-0,

Please also supply the field types of each one of those fields and your data source type (assume SharePoint?)

Was this reply helpful? Yes No
stampcoin 5,058 Super User 2025 Season 2 on at

Like (0)

Report
@PC-02040703-0 Hi,

Do you mean how to use formula to display error ?

if so, do something like :

Set( MyResult, Patch( 'Purchase Price Approval', Defaults('Purchase Price Approval'), { //your code. } ) ); If( IsError(MyResult), Notify("Your customized message for the error.", NotificationType.Error), Notify("✅ Data submitted successfully!", NotificationType.Success); Navigate(ThanksScreen) )

Was this reply helpful? Yes No