cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
mturner17
New Member

Add row to Lists or Excel table when Planner task created - even if some information is missing

Question: How do I add a row to either a SharePoint List or Excel table (I've tried both) when a Planner task is created.  One of the row columns will record the person assigned to the task (assignments Assigned To User Id).  The trick is that sometimes the task will have someone assigned to it and sometimes it will not.

 

Background: The issue is that when the trigger is executed (a Planner task is created) the task may or may not have someone assigned to it.  One of the columns in my List or Table will be the person assigned to the task.  The problem is that if "assignments Assigned To User Id" is blank the add row function will complete without populating any of the other information and therefore the row will not be created.  The result is that the flow says it has completed successfully but no row is added and the flow shows the actions within the "Apply to each" control as grayed out.

 

mturner17_2-1621362129310.png

 

 

mturner17_0-1621361787466.png

 

3 REPLIES 3
CasperRoseboom
Helper I
Helper I

If there isn't someone assigned to the task your array will be empty and your for each will not contain any items (and no rows will be created). Also if more then one person is assignd to the task it will create more then one row with the same task (don't know if that is what you want or not).

 

Do you want one row per task or more then one row (if more then one person is assigned to it)?

I realize the "Assigned to User ID" array will be blank, but in this case I would like the row to still be created with the rest of the relevant information (task ID, Bucket ID, etc.).  If there is no one assigned to the task, I would like to simply leave that field blank for the created row.

 

Ideally, I would have just one row per task, even if multiple people are assigned, but I can deal with that separately once I have this issue resolved.

 

Any suggestions?

CasperRoseboom
Helper I
Helper I

You could try to set a variable with all the users (if any) in it and set the assigned to in your excel to the value of the variable . 

 

CasperRoseboom_0-1621369330710.png

CasperRoseboom_1-1621369353022.png

 

Helpful resources

Announcements
MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

New Process Advisor Capabilities carousel.png

Read the blog for the latest news

Read the latest about new experiences and capabilities in the Power Automate product blog.

PA Survey Carousel Image.png

We want to hear from you!

If you are a small business ISV/Reseller, share your thoughts with our research team.

AI Builder AMA June 7th carousel (up on May 25th, take down June 8th) (1).png

'Ask Microsoft Anything' about AI Builder!

The AI Builder team invite you to ask questions and provide helpful answers at our next AMA.

Users online (1,429)