Unanswered

Produce error message if entered entry on PowerApps is not on database

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Can I produce an error message if the submitted entry on PowerApps is not on my connected database (Oracle) and subsequently pipe the submitted entry onto a sharepoint list?

For example, i have to enter a product code, B123, and B123 is not in my database so I want to produce an error message for the user to rectify. If B123 is in my database, then I want to submit and let the entry be reflected on my connected Sharepoint List. Is this possible?

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

WarrenBelz 154,492 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hi @Anonymous ,

Do a Lookup to Oracle

If( !IsBlank( LookUp( YourOracleTable, ProductCode=123 ).ProductCode ), Patch( YourOracleTable, {MatchingCriteriaHere} {PatchDataHere} ), Patch( YourSPList, {MatchingCriteriaHere} {PatchDataHere} ); Notify("Added to SharePoint") )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No
JamesYumnam on at

Like (0)

Report
Copy link

Link copied!

Seems like quite possible and easier too, using Power Automate.

Was this reply helpful? Yes No
JamesYumnam on at

Like (0)

Report
Copy link

Link copied!

@Anonymous You can pass the value from your PowerApp to the Flow.
In the flow, connect to your Oracle DB and check if there are rows with same value as you have passed.
If no(data does not exist), send response from the flow to your app.
If yes(data exists), continue to add actions to connect to your SP list and add the new record.

Was this reply helpful? Yes No