Unanswered

Report illness and recovery from SharePoint page

(0) Share

Report

Posted on by iSolitaire

Hi everyone
Can an expert in power automate help me with this.
For a sharepoint page I would like to make an automated flow to do the following:
Create a form where a user can enter and choose information
- Enter a Manger name (retrive auto from azure in field)
- Enter his user own name (retrive auto from azure in field)
- Enter some text info (Text field 1, text field2...)
- Coose from a drop down menu (- sick leave, partial sick leave, recovery, partial recovery)
- Date of sick leave
- Extra text field for partial work hours
when choosen for Recovery
-Date of recovery
- Extra text field for partial work hours
-Choose Yes or No field for some extra info

Finally E-mail button and cancel

Much precited

Categories:

General topics

I have the same question (0)

All responses (11)

Answers (1)

SudeepGhatakNZ 14,394 Most Valuable Professional on at

Like (0)

Report

@iSolitaire ,

A single Power App form with a SharePoint list with Power Automate in the backend will tick all the boxes.

Do you have the process diagram (including approver stages, etc) sorted?

Was this reply helpful? Yes No
iSolitaire 16 on at

Like (0)

Report

Thanks SudeepGhatakNZ

I don't have any experience in automation 🙂 yet.
The process is exact as i listed above, we don't need any approver, at the end of de form when the user hit e-mail button, the information entered will be e-mailed to a mailbox where it will be processed by a HR user.
Now we have a working form made in Infopath, but this one is deprecated in de Cloud.
Cheers

Was this reply helpful? Yes No
SudeepGhatakNZ 14,394 Most Valuable Professional on at

Like (1)

Report

@iSolitaire ,

You can achieve this simply via a Power Apps form then.

Step 1: Add Outlook Connector

Step 2: Add this code to a button. Specify email, Subject and Body as parameters to the function.

Was this reply helpful? Yes No
iSolitaire 16 on at

Like (0)

Report

@SudeepGhatakNZ great you just put me in the good path 🙂 _/\_

I managed to fill a SPO list with the needed info and used as a data source in power apps, i think that am almost there, but one thing i cannot fix.
In the list i made a Choice column this one is ok but what i need is when Choice is "sick leave" then the the user get to see only some fields for example "Date of sick leave" and a "text field" and when his choice is "partial sick leave" then he get "Date of sick leave" plus "partial work hours"
Can you tough some magic? 🙂

Regards

Was this reply helpful? Yes No
SudeepGhatakNZ 14,394 Most Valuable Professional on at

Like (1)

Report

@iSolitaire

Send me a screenshot of your form.

I will provide you with the steps

Was this reply helpful? Yes No
iSolitaire 16 on at

Like (0)

Report

@SudeepGhatakNZ ok thanks
the choice dropdown is in the yellow, and accordingly the user get for example the circled ones in red.

Was this reply helpful? Yes No
Verified answer

SudeepGhatakNZ 14,394 Most Valuable Professional on at

Like (1)

Report

You can set a conditional visibility on the controls that you would like to show and hide.

Was this reply helpful? Yes No
iSolitaire 16 on at

Like (0)

Report

I can not use the codes on it because it is not a combobox, the field comes from the SharePoint list, if i want to use the combo then i have to create the form in power apps (from my understanding so far)
Is there away to apply de visibility to the fields that originate from SPO list?
Regards

Was this reply helpful? Yes No
SudeepGhatakNZ 14,394 Most Valuable Professional on at

Like (1)

Report

But the screenshot you included above is a PowerApps form.

You can set conditional expressions in SharePoint form too.

Click on New - Edit Layout

Was this reply helpful? Yes No
iSolitaire 16 on at

Like (0)

Report
@SudeepGhatakNZ I managed to get the conditional visibility working 🙂 with an iF function.
Now the second challenge 😉 i have a send e-mail button that i will be using with an outlook connector like you said in the beginning, i want to collect the entered information from the form and send it as an e-mail to a mailbox, but i want also to customize the e-mail in a way that it user friendly.
I have a start but its not working yet, can you take a look? Thanks
SubmitForm(Form1);Office365Outlook.SendEmailV2("test@xxxxx.com", "Same letters", "Field name: "&Form1.LastSubmit.DataCardValue4&"<br> Field Name2:"&Form1.LastSubmit.DataCardValue7&"<br> Field name3:"&Form1.LastSubmit.DataCardValue5&" ) Back() NewForm(Form1)

Was this reply helpful? Yes No