Answered

help need - SharePoint list using ms form to submit. anyone??

(0) Share

Report

Posted on by bbsin

1,994

Currently I have a SP list that staff will submit as an consent acknowledge, I want to add one more step, for submitted consent - can it based by their email to auto pop up notification to inform the person that they have alert submitted the form and stop it from updating into the SP list. Not sure if work flow can do it or need something else. please advise.

Thank you

Categories:

Building Power Apps

All responses (3)

Answers (1)

Sort by

JR-BejeweledOne 5,836 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

I have actually done something similar. First let me get some additional information.

When the consent is submitted is a new item created in the SharePoint list? Is there any other data in the list besides the consent?
bbsin 1,994 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi JR

Yes it basically the list has Name. Dept email and yes they agreed fr MS form That's all

Thanks
Verified answer

JR-BejeweledOne 5,836 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

On app start

Set(varUser, Office365Users.MyProfileV2().mail);

ClearCollect(Agreements, Filter(DataSource, varUser in datasource.emailcolumn)

Then in your 'pop up' warning label, set the visible property to

If(

CountRows(Agreements) >0, true, false

)

This will collect the items in your list only for the logged in user. Then CountRows will count the rows in the collection. If there are more than 0 rows, the warning will be displayed