cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
iwonder
Impactful Individual
Impactful Individual

Update a Yes No field in SharePoint List from Excel file

Thank you for taking the time to read my question.

 

I have a SharePoint list that I want to add some data to from an Excel file that has a data table. The list has 3 fields: Title, ProductName, IsActive.

 

In my flow I can add the Title values and the ProductName values but I can't seem to figure out how to add the IsActive value. I don't want it to be all Yes or all No, I need the value in the Excel file. I tried clicking on Enter custom value but don't understand what I need to do to get the IsActive value from Excel

 

iwonder_0-1618603238761.png

any help would be great.

 

Thanks

1 ACCEPTED SOLUTION

Accepted Solutions
iwonder
Impactful Individual
Impactful Individual

I created a variable and set the IsActive value to the variable vIsActive. Then I added the new variable to the Create Item.

 

iwonder_0-1618608296113.png

iwonder_1-1618608334026.png

 

That worked for me. Not sure if that's the right way but it's working

 

Thanks

View solution in original post

1 REPLY 1
iwonder
Impactful Individual
Impactful Individual

I created a variable and set the IsActive value to the variable vIsActive. Then I added the new variable to the Create Item.

 

iwonder_0-1618608296113.png

iwonder_1-1618608334026.png

 

That worked for me. Not sure if that's the right way but it's working

 

Thanks

Helpful resources

Announcements
 WHAT’S NEXT AT MICROSOFT IGNITE 2022

WHAT’S NEXT AT MICROSOFT IGNITE 2022

Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Register for a Free Workshop.png

Register for a Free Workshop

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

Users online (1,314)