Update Sharepoint List including column formatting

(0) Share

Report

Posted on by Jtaylor95

126

I have a flow that creates an event in a shared calendar for a holiday request based on having this MS form approved:

Screenshot 2023-03-01 at 16.48.56.png

I need to add an action to update the circled sharepoint list column below (Holiday Days Taken), totalling the answers to number 4 above (i.e. total working days off), which I would do by an 'update item' action.

Screenshot 2023-03-01 at 16.44.04.png

Question 1

How do I make sure every time someone submits a form, the column is added to not overridden?

For example -

User submits form & requests 3 days off. Update item action populates 'Holiday Days Taken' column as 3.

A month later, the same user submits form again and requests 7 days off. How can I get the formula to continually add the number instead of populating the 'Holiday Days Taken' column as 7. It should show as 10 (3 + 7)

Question 2

How do write the flow so that the system knows what person to allocate this to on the SP list? Presumably its a condition that matches the email address of the person submitting the form with the 'employee email' column. How do I do this?

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (1)

Sort by

wskinnermctc 6,519 Moderator on at

Like (0)

Report
Copy link

Link copied!

To start thinking about this, you should put Question 2 first, and then you can answer Question 1.

So when someone submits a form, you need to Get Items from the SharePoint list and filter it based on the email address or unique identifier of the employee.

If the employee is not already in the list, then it will add a row with values from the form response.

If the employee is already in the list then you will have to add the values in an expression that will be something like add({FormResponseHoliday},{GetItemsHolidaysTaken) in the Update Item.

You will have to show a screenshot of your flow to get a more specific answer.

Was this reply helpful? Yes No
Jtaylor95 126 on at

Like (0)

Report
Copy link

Link copied!

I havent built the flow yet as I wasnt sure how best to do so.

The employee will always be on the list if that helps but any guidance on the specifics of building the flow would be much appreciated!

thanks

Was this reply helpful? Yes No
Verified answer

v-liwei-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @Jtaylor95

I have made a test for your reference:

1.

2.

3.

4.

add(items('Apply_to_each')?['HolidayDaysTaken'],int(outputs('Get_response_details')?['body/rfddadb25e35549c3942beae9724b9d34']))

Best Regards,

Levi

Was this reply helpful? Yes No
Jtaylor95 126 on at

Like (0)

Report
Copy link

Link copied!

Thanks!

Was this reply helpful? Yes No