Unanswered

I want to update "H" value based on the Quarter

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

For Single item there is 4 Quarter is there in the SP list

in the PowerApps I wanted to Set a variable if they click on the button . for the particular quarter value it will save collection and SharePoint

If I click on the logo in the SP and Collection it will Save value for the particular Qtr with the value of "H"

Categories:

Building Power Apps

All responses (8)

Answers (0)

Sort by

StalinPonnusamy Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
I assume you have a gallery with 4 buttons. For Button 1, OnSelect property of button to

Patch(Datasource, LookUp(Datasource, ID = ThisItem.ID), {Q1MappedAct:"H"})
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

only one button that with Eye Icon .
but I'm using dropdown value for filtering the gallery
StalinPonnusamy Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Anonymous
Sharepoint will be updated based on the dropdown and when the user clicks an icon on the gallery.
Patch( [@Projects], LookUp( [@Projects], ID = ThisItem.ID ), If( "FY" in Dropdown1.Selected.Value, { Q1MappedAct: "H", Q2MappedAct: "H", Q3MappedAct: "H", Q4MappedAct: "H" }, "Q1" in Dropdown1.Selected.Value, {Q1MappedAct: "H"}, "Q2" in Dropdown1.Selected.Value, {Q2MappedAct: "H"}, "Q3" in Dropdown1.Selected.Value, {Q3MappedAct: "H"}, "Q4" in Dropdown1.Selected.Value, {Q4MappedAct: "H"} ) )

Please let me know how the year is mapped to SP. So that we can change the patch command
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Dropdown value we are greeting from
StalinPonnusamy Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Anonymous

Let me know if the patch command works or not.
If not then please share the Sharepoint structure to see how the year is utilized.
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

I don't want to patch directly to SP
First I want update in collection after that I want save in SP
Sharepoint I'm using end Qtr filed
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Suppose I want to hide data for Qtr 1
then I need save the data on the same line Q1MappedAct field value should be to "H"
If Qtr3 then Q3MappedAct field value should be to "H"

and currently in which QTR we will find from the drop down

First I want save data to Collection using of the "update if" function
and all the value I want to save in the function using forAll function
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Suppose I want to hide data for Qtr 1
then I need save the data on the same line Q1MappedAct field value should be to "H"
If Qtr3 then Q3MappedAct field value should be to "H"

If I want to unhide the row for the particular QTR if I click to the eye icon value should be for Column Q1MappedAct "" blank() data

and currently in which QTR we will find from the drop down

First I want save data to Collection using of the "update if" function
and all the value I want to save in the function using forAll function