Push notifications

(0) Share

Report

Posted on by answeriver

110

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?

Categories:

Building Power Apps

I have the same question (0)

All responses (18)

Answers (2)

Sort by

Drrickryp Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi @answeriver

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

Was this reply helpful? Yes No
answeriver 110 on at

Like (0)

Report
Copy link

Link copied!

@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?

Was this reply helpful? Yes No
v-bofeng-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
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

Was this reply helpful? Yes No
answeriver 110 on at

Like (0)

Report
Copy link

Link copied!
@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.

Was this reply helpful? Yes No
v-bofeng-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
answeriver 110 on at

Like (0)

Report
Copy link

Link copied!

@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.

Was this reply helpful? Yes No
v-bofeng-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
answeriver 110 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Verified answer

v-bofeng-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
answeriver 110 on at

Like (0)

Report
Copy link

Link copied!

@v-bofeng-msft i do it all what you wrote and all ok.
One more, i export my data excel in sharepoint list and try just change connection in my current app but it's broke.
It means to beter do new app?

Was this reply helpful? Yes No