Push notifications

[answeriver]

Hello all.

I have powerapp based on excel on OneDrive.

Purpose of app is create records for excel.

I need when records in cell equal "Accept" then send notification to user whose record created. 

How I can do it?

[Drrickryp]

Hi @answeriver 

Shane Young has a video on how to send an email from PowerApps here: https://www.youtube.com/watch?v=bF7WkqtxKB0 

[answeriver]

@Drrickryp  thanks for link.

In video Shane makes sending email by push button, but I need notifications by condition of records.

 Do you have some for this?

[v-bofeng-msft]

Hi @answeriver :

Could you tell me :

• When a specific field is changed to "accept", do you want to send a notification to the user who created the record?
• Whether each record in the data source has a field containing the email address of the creator of the record?
• Can the operation of changing the value of the specified field be "Accept" only in this app?

I assume the above assumption holds.

Firstly,If my above assumption holds I suggest you take @Drrickryp 's solution.

You only need to put the code to send the email after the code to modify the specified field to "Accept". Then send the email to the creator's mailbox saved in the record.

Secondly,I suggest you migrate the data to SharePoint list, because excel has many restrictions.

There are three following benefits:

• High degree of automation:Can automatically detect whether the target field has changed through flow and trigger the specified event.
• Support delegation function:By default, if there are more than 500 records in the excel data source, problems will occur
• No need to manually save record creator information:Automatically save the information of the creator of the record in the default field ‘Created by’.

Finally,I've made a test for your reference:

My data source(Share Point List):'List A'

Column (click to edit) Type

Title	Single line of text
NUM1	Number
status	Single line of text
date	Date and Time

I assume ‘status’ is the specified field.

1\Create a flow

Best Regards,

Bof

[answeriver]

@v-bofeng-msft 

Could you tell me :

• When a specific field is changed to "accept", do you want to send a notification to the user who created the record?
• Yes who's created records
• Whether each record in the data source has a field containing the email address of the creator of the record?
• Yes i has column with created by.email
• Can the operation of changing the value of the specified field be "Accept" only in this app?
• Basicly Column status editing in fileLet tell you about purpose of my app, maybe it gives you more understanding:In my company has excel file Journal of recieving documents. This file is stand in local network disk. So example i want give my document to Accountant department, before i need to create record in this file. Im doing this and put my document to document box. Later, the accounting officer receives documents in the order of priority and, if everything is correct, then marks the status in the file as accepted. This flow has many uncomfortable things:1. When someone open the file i can use it too.2. For seeing status i need go inside file and watch status3. It work only on PCSo that why i try to improve this process. Actualy im newbie in powerapps, try to learn by themself. And all of you wrote about migration, Sharepoint, automated flow e.t.c is absolutly new things for me.

[v-bofeng-msft]

Hi @answeriver :

Can you tell me that these files are stored in a table of excel in the form of records? Is the file status a field in the table?
Can you tell me how the accountant marked the status of the file? Is it through the Canvas App? If yes, what is the control? How is it set up?

Best Regards,

Bof

[answeriver]

@v-bofeng-msft 

Can you tell me that these files are stored in a table of excel in the form of records? Is the file status a field in the table?

File only one in one table with 10 columns, records of  5 columns edit/create through app, other 5 columns edit through the excel and in the app available only view of this columns in card of record

Can you tell me how the accountant marked the status of the file? Is it through the Canvas App? If yes, what is the control? How is it set up?

Accountant edit in excel by manual input in column Status.

[v-bofeng-msft]

Hi @answeriver :

I am afraid that the functions you need cannot be realized through PowerApps (because OneDrive does not have related triggers)Triggers

I have three alternatives:

1\Let the finance staff modify the status in the powerapp you created. In this way, you can add the code to send the email after the code to submit the record.

2\According to your description, the structure of your table is very simple, and the amount of data is not large. I suggest you create a SharePoint list as your data source. The specific steps can refer to the solution I provided before.

Best Regards,

Bof

[answeriver]

Dear @v-bofeng-msft,

With my colleague from IT we done:

1. Create group in Teams.

2. Put excel file into

And after it i opened this file in sharepoint and try to make powerapps from it.

Is this the way what you did talk about? - migrate to sharepoint

[v-bofeng-msft · Accepted solution]

Hi @answeriver :

You could creat a new list instead of put the excel file in to the SharePoint library.

The point is using the list as the date source instead of excel file.

In addition,there is a veary simple way to creat a new list:

I think this link will help you a lot:

Export an Excel table to SharePoint

Best Regards,

Bof