Basically I have a powerapps application and a flow in which the two of them are working together. I will upload an excel file through powerapps and that file will be uploaded to my sharepoint documents where its records will then be read and appended to an existing sharepoint list. Although there are two conditions in my power automate flow where if a record in the excel file is already existing in the sharepoint list (this is checked using the Doctor Code column in both excel and sharepoint list), then it will update the record in the sharepoint list with the record from the excel file, otherwise if the record does not exist in the sharepoint list then it will just straight up create it in the sharepoint list.
So the scenario right now is I upload an excel file and the sharepoint list gets updated right away. But that is not what I want, what I want to happen is:
I upload an excel file in powerapps, then if the record in the excel file already exists in the sharepoint list, a popup will appear in powerapps giving the users an option to choose whether they want to update the record in the sharepoint list or reject it. How can I achieve that?
I figured I should include my flow here as well.
Thank you in advance!
